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.

Journal Entries

No entries yet. Link your entries with 'sqlalchemy' to include this project.


Ratings & Reviews

Community Rating
4.5/5.0

Based on 46 user ratings.

Your Rating

Click to rate this project.

Links

4 links submitted so far. Submit your own links.

News

Edit RSS feeds.

    Timing All Queries

    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 ... [More] logging
     
    logging.basicConfig()
    logger = logging.getLogger("myapp.sqltime")
    logger.setLevel(logging.DEBUG)
     
    class TimerProxy(ConnectionProxy):
    def cursor_execute(self, execute, cursor, statement, parameters, context, executemany):
    [...] [Less]

    Selecting Booleans

    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, [...]

    Ajax the Mako Way

    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, [...]

    Better Form Generation with Mako and Pylons

    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 [...]

    SQLAlchemy code swarm

    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.

Read all SQLAlchemy articles…

Download Page
15 downloads

Who uses SQLAlchemy?

Roger Demetrescu Christoph Zwerschke Christopher Arndt clj Victor Lin liff apollo13 Pedro Algarvio, aka, s0undt3ch armaud slav0nic Luis Bruno Florian Mayer

Who contributes to SQLAlchemy?

zzzeek Jason Kirtland ellisj Ants Aasma Gaƫtan de Menten empty Roger Demetrescu ram lele paj rtl cleverdevil catherinedevlin ash sean jeff
I'm a contributor

Who manages SQLAlchemy?

I'm a manager

Where in the world?




People who use SQLAlchemy also use:

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