Essential SQLAlchemy introduces a highlevel opensource code library thatmakes it easier for Python programmers to access relational databases such asOracle DB2 ... » 

Essential SQLAlchemy introduces a highlevel opensource code library thatmakes it easier for Python programmers to access relational databases such asOracle DB2 MySQL PostgreSQL and SQLite. SQLAlchemy has become increasinglypopular since its release but it still lacks good offline documentation. Thispractical book fills the gap and because a developer wrote it you get anobjective look at SQLAlchemys tools rather than an advocates description ofall the cool features. SQLAlchemy includes both a database serverindependentSQL expression language and an objectrelational mapper ORM that lets you mapplain old Python objects POPOs to database tables without substantiallychanging your existing Python code. Essential SQLAlchemy demonstrates how touse the library to create a simple database application walks you throughsimple queries and explains how to use SQLAlchemy to connect to multipledatabases simultaneously with the same Metadata. You also learn how to Create custom types to be used in your schema and when its useful to usecustom rather than builtin types Run queries updates and deletes withSQLAlchemys SQL expression language Build an object mapper with SQLAlchemyand understand the differences between this and active record patterns used inother ORMs Create objects save them to a session and flush them to thedatabase Use SQLAlchemy to model object oriented inheritance Provide adeclarative active record pattern for use with SQLAlchemy using the Elixirextension Use the SQLSoup extension to provide an automatic metadata andobject model based on database reflection In addition youll learn how andwhen to use other extensions to SQLAlchemy including AssociationProxyOrderingList and more. Essential SQLAlchemy is the muchneeded guide for everyPython developer using this code library. Instead of a featurebyfeaturedocumentation this book takes an essentials approach that gives you exactlywhat you need to become productive with SQLAlchemy right away. «