- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
New Trade Paper
Ships in 1 to 3 days
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBN
Essential SQLAlchemyby Rick Copeland
Synopses & Reviews
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:
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)
"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
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computer Languages » Python