//
Search across all documentation pages
12 pages in this section.
How DB-API 2.0 drivers, SQLAlchemy Core, and the ORM stack on top of each other, why sync and async access are separate implementations of that stack rather than a toggle, and why connection pooling - not raw driver speed - is usually the real concurrency limit on a Python service.
Learn Python database fundamentals with 9 examples covering DB-API connections, explicit transactions, and SQLAlchemy engine usage.
Learn to use SQLAlchemy Core for direct SQL operations, including table definition, inserts, selects, and updates, with practical Python examples.
Learn to use SQLAlchemy ORM 2.0 for declarative models, sessions, and relationships. Understand eager loading, typed Mapped annotations, and common pitfalls.
Learn to autogenerate, review, and apply database schema revisions with Alembic. Understand its workflow, upgrade operations, and common pitfalls.
Learn database best practices for Python services, including safe schema changes, indexing, query hygiene, operations, and security.
A single-page roundup of every highlight bullet from the 11 pages in the Databases section, grouped by source page so you can scan all 63 takeaways without opening each article individually.