python-sqlalchemy

SQL toolkit and Object Relational Mapper for Python

Description

SQLAlchemy is an SQL database abstraction library for Python. Its strengths are:

* full power and flexibility of SQL. SQLAlchemy 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.

* extremely easy to use for all the basic tasks, such as: accessing pooled

connections, constructing SQL from Python expressions, finding object

instances, and committing object modifications back to the database.

* powerful enough for complicated tasks, such as: eager load a graph of

objects and their dependencies via joins; map recursive adjacency

structures automatically; map objects to not just tables but to any

arbitrary join or select statement; combine multiple tables together to

load whole sets of otherwise unrelated objects from a single result set;

commit entire graphs of object changes in one step.

* built to conform to what DBAs demand, including the ability to swap out

generated SQL with hand-optimized statements, full usage of bind parameters

for all literal values, fully transactionalized and consistent updates

using Unit of Work.

* modular. Different parts of SQLAlchemy can be used independently of the

rest, including the connection pool, SQL construction, and ORM. SQLAlchemy

is constructed in an open style that allows plenty of customization, with

an architecture that supports custom datatypes, custom SQL extensions, and

ORM plugins which can augment or extend mapping functionality.

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Hint: upload an image here from your clipboard with Ctrl-V

Homepage

Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…