PUBLIC MARKS with tag sqlalchemy

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. SQLALCHEMY'S PHILOSOPHY SQL databases behave less like object collections the more size and performance start to matter; object collections behave 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.

Using SQLAlchemy in TurboGears The simplest way to get started using SQLAlchemy is to quickstart new project with --sqlalchemy switch: tg-admin quickstart --sqlalchemy (Or more briefly: tg-admin quickstart -s) This switch sets up your model.py properly for using SQLAlchemy. If you said yes to the identity prompt, you'll get the ActiveMapper version of the identity tables. Now change the value of sqlalchemy.dburi to point to a valid database connection. To init the database schema you need to run: tg-admin sql create If you're converting a project from SQLObject to SQLAlchemy, we recommend that you quickstart a new project and then copy in the identity tables piece by piece.

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.

Multi protocol Python/Twisted CMS with a SQLAlchemy based persistence engine

sAsync: SQLAlchemy done Asynchronously