SliTaz Repositories

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/python-sqlalchemy/description.txt	Thu Jul 21 06:45:43 2022 +0100
     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.