TableOfContents

简介

Python 中最好的 ORM ！

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

哲学

SQL databases behave less and less like object collections the more size and performance start to matter; object collections behave less and less like tables and rows the more abstraction starts to matter. SQLAlchemy aims to accommodate both of these principles.

SQLAlchemy doesn't view databases as just collections of tables; it sees them as relational algebra engines. Its object relational mapper enables classes to be mapped against the database in more than one way. SQL constructs don't just select from just tables—you can also select from joins, subqueries, and unions. Thus database relationships and domain object models can be cleanly decoupled from the beginning, allowing both sides to develop to their full potential.

相关链接

• [http://www.sqlalchemy.org/ 首页]

• [http://www.sqlalchemy.org/docs/ 文档]

• [http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html A step-by-step SQLAlchemy tutorial]

• [http://erosson.com/migrate/ Migrate: sqlalchemy的数据库版本控制]

• [http://turboentity.ematia.de/ TurboEntity: 对 sqlalchemy 的一层封装]

• [http://www.sqlalchemy.org/trac/wiki/SqlSoup SqlSoup: 建立在 sqlalchemy 基础上的一个 sql 工具]

• [http://spyced.blogspot.com/2006/04/introducing-sqlsoup.html Introducing SqlSoup]

• [http://spyced.blogspot.com/2007/01/why-sqlalchemy-impresses-me.html Why SQLAlchemy impresses me](使用 sqlalchemy 表达复杂的关联)

• [http://spyced.blogspot.com/2006/02/why-schema-definition-belongs-in.html Why schema definition belongs in the database] (与 sqlalchemy 无关)

讨论