wok diff python-sqlalchemy/description.txt @ rev 25562
ext4magic: add current_version()
author | Pascal Bellard <pascal.bellard@slitaz.org> |
---|---|
date | Mon May 01 08:21:00 2023 +0000 (16 months ago) |
parents | |
children |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/python-sqlalchemy/description.txt Mon May 01 08:21:00 2023 +0000 1.3 @@ -0,0 +1,35 @@ 1.4 +SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that 1.5 +gives application developers the full power and flexibility of SQL. 1.6 +SQLAlchemy provides a full suite of well known enterprise-level 1.7 +persistence patterns, designed for efficient and high-performing database 1.8 +access, adapted into a simple and Pythonic domain language. 1.9 + 1.10 +Major SQLAlchemy features include: 1.11 + 1.12 +- An industrial strength ORM, built from the core on the identity map, 1.13 + unit of work, and data mapper patterns. 1.14 + These patterns allow transparent persistence of objects using a 1.15 + declarative configuration system. Domain models can be constructed and 1.16 + manipulated naturally, and changes are synchronized with the current 1.17 + transaction automatically. 1.18 +- A relationally-oriented query system, exposing the full range of SQL's 1.19 + capabilities explicitly, including joins, subqueries, correlation, and 1.20 + most everything else, in terms of the object model. 1.21 + Writing queries with the ORM uses the same techniques of relational 1.22 + composition you use when writing SQL. While you can drop into literal SQL 1.23 + at any time, it's virtually never needed. 1.24 +- A comprehensive and flexible system of eager loading for related collections 1.25 + and objects. Collections are cached within a session, and can be loaded on 1.26 + individual access, all at once using joins, or by query per collection across 1.27 + the full result set. 1.28 +- A Core SQL construction system and DBAPI interaction layer. The SQLAlchemy 1.29 + Core is separate from the ORM and is a full database abstraction layer in its 1.30 + own right, and includes an extensible Python-based SQL expression language, 1.31 + schema metadata, connection pooling, type coercion, and custom types. 1.32 +- All primary and foreign key constraints are assumed to be composite and 1.33 + natural. Surrogate integer primary keys are of course still the norm, but 1.34 + SQLAlchemy never assumes or hardcodes to this model. 1.35 +- Database introspection and generation. Database schemas can be "reflected" 1.36 + in one step into Python structures representing database metadata; those 1.37 + same structures can then generate CREATE statements right back out - all 1.38 + within the Core, independent of the ORM.