Jason Myers - Essential SQLAlchemy

Beijing Cambridge Farnham Kln Sebastopol Tokyo

We are surrounded by data everywhere, and your ability to store, update, and report on that data is critical to every application you build. It doesnt matter if you are developing for the web, the desktop or other applications, they all need fast and secure access to data. Relational databases are still one of the most common places to put that data.

SQL is a powerful language for querying and manipulating data in a database, but sometimes its tough to integrate it with the rest of your application. You may have used string manipulation to generate queries to run over an ODBC interface, or used a DB API as a Python programmer. While those can be effective ways to handle data it can make security and database changes very difficult.

This book is about a very powerful and flexible Python library named SQLAlchemy that bridges the gap between relational databases and traditional programming. While SQLAlchemy allows you to drop down into raw SQL to execute your queries, it encourages higher-level thinking through a more pythonic and friendly approach to database queries and updates. It supplies the tools that let you map your applications classes and objects onto database tables once and then to forget about it, or to return to your model again and again to fine-tune performance.

SQLAlchemy is powerful and flexible, but it can also be a little daunting. SQLAlchemy tutorials expose only a fraction of whats available in this excellent library, and though the online documentation is extensive, it is often better as a reference than as a way to learn the library initially. This book is meant as a learning tool and a handy reference for when youre in implementation mode and need an answer fast .

This book focus the 1.0 release of SQLAlchemy; however, much of what will cover has been available for many of the previous versions. It certainly works from 0.8 forward with minor tweaking, and most of it from 0.5.

This book has been written in three majors sections: SQLAlchemy Core, SQLAlchemy ORM, and a Cookbook section. The first two sections are meant to mirror each other as closely as possible. We have taken care to perform the same examples in each section so that you can compare and contrast the two main ways of using SQLAlchemy. The book is also written so that you can read both the SQLAlchemy Core and ORM sections or just the one suits your needs at the moment.