If you’re a Python developer, SQLAlchemy will give you the full flexibility and power of SQL, providing a complete collection of popular enterprise-level persistence patterns, which have been designed for high-performing and efficient database access.
Features at a glance
The software is extremely easy to use, powerful enough for sophisticated tasks, and modular. With SQLAlchemy you will be able to organize pending CRUD operations, allows the use of boolean expressions, functions, operators, table aliases, UNION clauses, correlated EXISTS clauses, create, insert, delete and update queries, selectable subqueries, correlated updates, inner and outer joins, and bind parameters.
Additionally, it can be used to generate databases, as well as to introspect them, support for loading related objects and collections, support for creating transparent persistence of objects based on patterns, support for manipulating and constructing domain models, as well as support for synchronizing all the changes with the current transaction automatically.
Among other features, we can mention a relationally-oriented query system that’s capable of exposing all of SQL’s functionality, including correlation, joins and subqueries, a DBAPI interaction layer, a core SQL construction system, a complete, standalone database abstraction layer, support for extensible SQL schema metadata, expression language, connection pooling, custom types and type coercion.
Supports a wide variety of databases
The program includes dialects for a wide variety of database servers and engines, including MySQL, PostgreSQL, Firebird, Oracle, Microsoft SQL Server, SQLite, Sybase, and many others.
The project is independent of an operating system, which means that it can be easily deployed and used on any GNU/Linux distribution, as well as on the Microsoft Windows, BSD or Mac OS X operating systems. Both 32-bit and 64-bit hardware architectures are supported at this time.
Reviewed by Marius Nestor, last updated on December 15th, 2014
In a hurry? Add it to your Download Basket!
- [orm] [bug] [engine] Fixed bug that affected generally the same classes of event as that of #3199, when the named=True parameter would be used. Some events would fail to register, and others would not invoke the event arguments correctly, generally in the case of when an event was “wrapped” for adaption in some other way. The “named” mechanics have been rearranged to not interfere with the argument signature expected by internal wrapper functions.
- [orm] [bug] Fixed bug that affected many classes of event, particularly ORM events but also engine events, where the usual logic of “de duplicating” a redundant call to event.listen() with the same arguments would fail, for those events where the listener function is wrapped. An assertion would be hit within registry.py. This assertion has now been integrated into the deduplication check, with the added bonus of a simpler means of checking deduplication across the board.
Application descriptionSQLAlchemy is an open source, free and small command-line software written in the Python programming language and desi...