docs.sqlalchemy.orgSQLAlchemy Documentation — SQLAlchemy 1.3 Documentation

via SQLAlchemy adapter -- home features Feature Overview Testimonials blog library Reference Reference Documentation Architecture Citing SQLAlchemy Blog Posts Talks Tutorials Recipes community Get Support Participate Develop Code of Conduct Github download Current Release Series (1.3) Maintenance Release (1.2) Development Access License Version Numbering Release Status Release: 1.3.17 current release | Release Date: May 13, 2020 SQLAlchemy 1.3 Documentation Search terms: Contents | Index SQLAlchemy Documentation ¶ Getting Started ¶ A high level view and getting set up. Overview | Installation Guide | Frequently Asked Questions | Migration from 1.2 | Glossary | Error Messages | Changelog catalog SQLAlchemy ORM ¶ Here, the Object Relational Mapper is introduced and fully described. If you want to work with higher-level SQL which is constructed automatically for you, as well as automated persistence of Python objects, proceed first to the tutorial. Read this first: Object Relational Tutorial ORM Configuration: Mapper Configuration | Relationship Configuration Configuration Extensions: Declarative Extension | Association Proxy | Hybrid Attributes | Automap | Mutable Scalars | Indexable ORM Usage: Session Usage and Guidelines | Loading Objects | Cached Query Extension Extending the ORM: ORM Events and Internals Other: Introduction to Examples SQLAlchemy Core ¶ The breadth of SQLAlchemy’s SQL rendering engine, DBAPI integration, transaction integration, and schema description services are documented here. In contrast to the ORM’s domain-centric mode of usage, the SQL Expression Language provides a schema-centric usage paradigm. Read this first: SQL Expression Language Tutorial All the Built In SQL: SQL Expression API Engines, Connections, Pools: Engine Configuration | Connections, Transactions | Connection Pooling Schema Definition: Overview | Tables and Columns | Database Introspection (Reflection) | Insert/Update Defaults | Constraints and Indexes | Using Data Definition Language (DDL) Datatypes: Overview | Building Custom Types | API Core Basics: Overview | Runtime Inspection API | Event System | Core Event Interfaces | Creating Custom SQL Constructs | Dialect Documentation ¶ The dialect is the system SQLAlchemy uses to communicate with various types of DBAPIs and databases. This section describes notes, options, and usage patterns regarding individual dialects. PostgreSQL | MySQL | SQLite | Oracle | Microsoft SQL Server More Dialects … © Copyright 2007-2020, the SQLAlchemy authors and contributors. Created using Sphinx 3.0.4. SQLAlchemy Sponsors Website content copyright © by SQLAlchemy authors and contributors. SQLAlchemy and its documentation are licensed under the MIT license. SQLAlchemy is a trademark of Michael Bayer. mike(&)zzzcomputing.com All rights reserved. Website generation by zeekofile , with huge thanks to the Blogofile project....