Nonficionado Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Q&A | May 20, 2015

    Michael Perry: IMG Powell's Q&A: Michael Perry

    Describe your latest book. On Christmas Eve itself, the bachelor Harley Jackson stepped into his barn and beheld there illuminated in the straw a... Continue »
    1. $18.19 Sale Hardcover add to wish list

      The Jesus Cow

      Michael Perry 9780062289919

Qualifying orders ship free.
List price: $34.99
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton COMP- DATA SQL

More copies of this ISBN

Essential SQLAlchemy


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 (


"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

Copeland, Rick
O'Reilly Media
Database Management - General
Python (Computer program language)
Sql (computer program language)
Database design
CourseSmart Subject Description
Edition Description:
Print PDF
Publication Date:
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 $6.50

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 Used Trade Paper
0 stars - 0 reviews
$14.95 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.
  • back to top


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