Projects / SQLAlchemy

SQLAlchemy

SQLAlchemy is a SQL toolkit and object relational mapper for Python. It encourages "relational mapping" as opposed to "table mapping" and includes enterprise-level features such as eager loading, unit-of-work object commits, topological dependency sorting, and full usage of bind parameters. It supports MySQL, Postgres, Oracle, and SQLite.

Implementation

Recent releases

  •  22 May 2010 16:13

    Release Notes: Dialect modules are now broken up into distinct subcomponents. The boolean value of Python boolean expressions now evaluates accurately with regards to the two clause objects being compared. The "executemany" behavior was improved. DDL functionality was expanded. The logging level of engines, pools, and mappers can be modified after creation. The Enum type was added.

    •  30 May 2006 05:16

      Release Notes: This release adds a new level of functionality, including reworkings of almost every area, from more explicit contexual control of connections and sessions to polymorphic loading, new plugins, and improved APIs.

      •  27 Mar 2006 08:34

        Release Notes: Improvements were made to Oracle support. A new engine capability was added, allowing nested transactions at the connection or unit-of-work level. Control of unit-of-work scoping was improved for individual objects. Many fixes and enhancements were made to table inheritance patterns. A new PickleType was added. Bugs in SQL construction were fixed. Mapping patterns were added.

        Screenshot

        Project Spotlight

        OpenStack4j

        A Fluent OpenStack client API for Java.

        Screenshot

        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.