Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


The Powell's Playlist | June 18, 2014

Daniel H. Wilson: IMG The Powell’s Playlist: Daniel H. Wilson



Like many writers, I'm constantly haunting coffee shops with a laptop out and my headphones on. I listen to a lot of music while I write, and songs... Continue »
  1. $18.87 Sale Hardcover add to wish list

    Robogenesis

    Daniel H. Wilson 9780385537094

spacer
Qualifying orders ship free.
$34.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
4 Remote Warehouse Database- Design

More copies of this ISBN

Essential SQLAlchemy

by

Essential SQLAlchemy Cover

 

Synopses & Reviews

Publisher Comments:

Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the "cool" features.

SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper (ORM) that lets you map "plain old Python objects" (POPOs) to database tables without substantially changing your existing Python code. Essential SQLAlchemy demonstrates how to use the library to create a simple database application, walks you through simple queries, and explains how to use SQLAlchemy to connect to multiple databases simultaneously with the same Metadata. You also learn how to:

  • Create custom types to be used in your schema, and when it's useful to use custom rather than built-in types
  • Run queries, updates, and deletes with SQLAlchemy's SQL expression language
  • Build an object mapper with SQLAlchemy, and understand the differences between this and active record patterns used in other ORMs
  • Create objects, save them to a session, and flush them to the database
  • Use SQLAlchemy to model object oriented inheritance
  • Provide a declarative, active record pattern for use with SQLAlchemy using the Elixir extension
  • Use the SQLSoup extension to provide an automatic metadata and object model based on database reflection

In addition, you'll learn how and when to use other extensions to SQLAlchemy, including AssociationProxy, OrderingList, and more.

Essential SQLAlchemy is the much-needed guide for every Python developer using this code library. Instead of a feature-by-feature documentation, this book takes an "essentials" approach that gives you exactly what you need to become productive with SQLAlchemy right away.

Book News Annotation:

For Python programmers, this guide describes how the SQLAlchemy open source code library can map objects to database tables without substantially changing the Python code. The library bridges the gap between relational databases and traditional object-oriented programming. The book covers the 0.4 release series and installation, engines, running queries and updates, building an object mapper, querying and updating, and extensions. Intermediate to advanced Python skills are assumed, as is moderate exposure to SQL databases. Copeland is a software engineer with a retail analytics firm. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

"Essential SQLAlchemy" introduces a high-level open source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLLite.

About the Author

Rick Copeland is a Florida Department of Environmental Protection hydrogeologist at the Florida Geological Survey and president of the Southeastern Geological Society.

Table of Contents

PrefaceChapter 1: Introduction to SQLAlchemyChapter 2: Getting StartedChapter 3: Engines and MetaDataChapter 4: SQLAlchemy Type EnginesChapter 5: Running Queries and UpdatesChapter 6: Building an Object MapperChapter 7: Querying and Updating at the ORM LevelChapter 8: Inheritance MappingChapter 9: Elixir: A Declarative Extension to SQLAlchemyChapter 10: SqlSoup: An Automatic Mapper for SQLAlchemyChapter 11: Other SQLAlchemy ExtensionsColophon

Product Details

ISBN:
9780596516147
Author:
Copeland, Rick
Publisher:
O'Reilly Media
Subject:
Database Management - General
Subject:
Python (Computer program language)
Subject:
Sql (computer program language)
Subject:
Database design
Subject:
Pylons;Python;SQLAlchemy;SQLObject;TurboGears
Edition Description:
Trade Paper
Publication Date:
20080631
Binding:
TRADE PAPER
Language:
English
Pages:
240
Dimensions:
9.24x7.08x.57 in. .86 lbs.

Other books you might like

  1. Twisted Network Programming Essentials Used Trade Paper $17.95
  2. Beautiful Code: Leading Programmers... Used Trade Paper $31.00
  3. jQuery in Action Used Trade Paper $27.50
  4. The CSS Anthology: 101 Essential... Used Trade Paper $10.50
  5. On Intelligence Used Trade Paper $7.50
  6. Hot Commodities: How Anyone Can... Used Hardcover $1.25

Related Subjects

Computers and Internet » Computer Languages » Python
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » General
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Health and Medicine » General
Health and Self-Help » Health and Medicine » General Medicine
Metaphysics » Healing

Essential SQLAlchemy New Trade Paper
0 stars - 0 reviews
$34.99 In Stock
Product details 240 pages O'Reilly Media - English 9780596516147 Reviews:
"Synopsis" by ,
"Essential SQLAlchemy" introduces a high-level open source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLLite.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.