Loading...
Widely used ORM library providing a full suite of enterprise-level persistence patterns. Designed for efficient, high-performing database access with flexible SQL abstraction.
SQLAlchemy is the standard Python database toolkit for data engineers. The Core layer is used to construct and execute SQL queries programmatically — building dynamic INSERT/UPDATE statements, managing connection pools in long-running services, and reading query results into pandas DataFrames via `pd.read_sql()`. The ORM layer manages schema-as-code in application codebases.
Widely used ORM library providing a full suite of enterprise-level persistence patterns. Designed for efficient, high-performing database access with flexible SQL abstraction.
Yes, SQLAlchemy is free to use.
SQLAlchemy is listed under the ORMs for Python category on Python Data Engineering.
Details
Projects
Learn the most popular Python ORM by building a complete database application with SQLAlchemy. Master model definitions, database sessions, CRUD operations, and query building. Essential skills for any data engineer working with relational databases in Python.
Learn how to use Alembic, the standalone database migration tool for SQLAlchemy, to manage schema changes over time. This project demonstrates creating initial migrations, adding columns, creating new tables, and rolling back changes - essential skills for maintaining database schemas in production.
Master Flask-Migrate, the Flask extension that integrates Alembic for database migrations. Learn to manage schema changes in Flask applications, add fields to models, create new tables, and maintain database version control - essential for Flask-based data applications.
Related
| Tool | Pricing | Rating | |
|---|---|---|---|
DO Django ORMfeatured Django's Built-in ORM | Free | ★ 4.8 | → |
PE Peewee Small Expressive ORM | Free | ★ 4.6 | → |
PO Pony ORM Pythonic Query Language | Free | ★ 4.5 | → |