SQLAlchemy

The Python SQL Toolkit and Object Relational Mapper

Language: PythonCategory: ORMFirst released: 2006Created by: Michael BayerLicense: MIT

SQLAlchemy is the most mature and popular Python database toolkit. It provides a full suite of enterprise-level persistence patterns, designed for efficient and high-performing database access. SQLAlchemy includes both a Core expression language for raw SQL composition and a powerful ORM layer. It supports PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server, and is widely used in web frameworks like Flask and FastAPI.

Links

Key Features

Core & ORM LayersConnection PoolingSchema MigrationsEager & Lazy LoadingMulti-Database Support