Global web icon
sqlalchemy.org
https://www.sqlalchemy.org/
SQLAlchemy - The Database Toolkit for Python
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It 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.
Global web icon
sqlalchemy.org
https://docs.sqlalchemy.org/
SQLAlchemy Documentation — SQLAlchemy 2.0 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.
Global web icon
sqlalchemy.org
https://www.sqlalchemy.org/features.html
Features - SQLAlchemy
Different parts of SQLAlchemy can be used independently of the rest. Elements like connection pooling, SQL statement compilation and transactional services can be used independently of each other, and can also be extended through various plugin points.
Global web icon
sqlalchemy.org
https://www.sqlalchemy.org/download.html
Download - SQLAlchemy
Updates for critical fixes will be made available as needed, but applications which continue to be under active development are advised to begin upgrading to the current series of SQLAlchemy (currently the 2.0 series).
Global web icon
sqlalchemy.org
https://www.sqlalchemy.org/library.html
Library - SQLAlchemy
A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram.
Global web icon
sqlalchemy.org
https://docs.sqlalchemy.org/en/14/orm/tutorial.htm…
Object Relational Tutorial (1.x API) - SQLAlchemy
The SQLAlchemy Object Relational Mapper presents a method of associating user-defined Python classes with database tables, and instances of those classes (objects) with rows in their corresponding tables.
Global web icon
sqlalchemy.org
https://docs.sqlalchemy.org/en/21/tutorial/index.h…
SQLAlchemy Unified Tutorial — SQLAlchemy 2.1 Documentation
SQLAlchemy Core is the foundational architecture for SQLAlchemy as a “database toolkit”. The library provides tools for managing connectivity to a database, interacting with database queries and results, and programmatic construction of SQL statements.
Global web icon
sqlalchemy.org
https://www.sqlalchemy.org/philosophy.html
Philosophy - SQLAlchemy
The main goal of SQLAlchemy is to change the way you think about databases and SQL! Read some key features of SQLAlchemy, as well as what people are saying about SQLAlchemy.
Global web icon
sqlalchemy.org
https://docs.sqlalchemy.org/en/21/tutorial/data_se…
Using SELECT Statements — SQLAlchemy 2.1 Documentation
SQLAlchemy uses the Subquery object to represent a subquery and the CTE to represent a CTE, usually obtained from the Select.subquery() and Select.cte() methods, respectively. Either object can be used as a FROM element inside of a larger select() construct.
Global web icon
sqlalchemy.org
https://docs.sqlalchemy.org/en/21/intro.html
Overview — SQLAlchemy 2.1 Documentation
The SQLAlchemy SQL Toolkit and Object Relational Mapper is a comprehensive set of tools for working with databases and Python. It has several distinct areas of functionality which can be used individually or combined together.