FAQ www.sqlalchemy.org
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.
Updated 05 Oct 2008 08:18 UTC
Based on 46 user ratings.
Click to rate this project.
4 links submitted so far. Submit your own links.
A few people have been asking about this one as of late, it's quite easy to do with a ConnectionProxy. Here's a quick recipe (yes, this is 0.5):
from sqlalchemy.interfaces import ConnectionProxy
import time
import
Ticket 798, allow conjunctions to act as column elements, is complete after a long wait, finally attended to for the great reason that I suddenly needed this feature myself ;). A few tweaks and we can now talk about asking yes/no questions of our database.
As we head into the 0.5 era of SQLAlchemy, [...]
My previous post (updated!) demonstrated how Mako's "defs with embedded content" feature was used to build a library of form tags, keeping all HTML and layout within templates, as well as a succinct method of linking them to form validation and data state. The "def with embedded content", a feature derived from HTML::Mason, [...]
If you're a web developer in New York City, unless you work here, here or maybe here, you're probably not using Python for primary development (if you are, please post your company here). Since I'm not a PHP monkey or a Microsoftie, everywhere I work they're using Struts, which is where [...]
Django's already got one, and Brian Rosner made one for us too: link. SQLA's pre-release development is apparent here which is why it floats around "zzzeek" for so long.
ADOdb, DataMapper, DBIx::Class, Rose::DB::Object, Storm Object-Relational Mapper
FormEncode
Genshi Python Paste nose Routes
psycopg
Mako Werkzeug
Project Cost |
|
|---|---|
| This calculator estimates how much it would cost to hire a team to write this project from scratch. More » | |
| Include | |
| Codebase | 80,206 |
| Effort (est.) | 20 Person Years |
| Avg. Salary | $ year |
| $ 1,095,230 | |