Database Access
6 Topics
1
SQLite with Python
Built-in relational database — sqlite3 module for creating databases, tables, CRUD operations, transactions, and parameterized queries.
Database fundamentals — SQLite is used in mobile apps, embedded systems, and prototyping.
2
Python DB-API
PEP 249 standard database interface — common API across all database drivers (sqlite3, psycopg2, mysql-connector, etc.).
Database standards — understanding the DB-API lets you work with any database driver.
3
ORM Basics
Object-Relational Mapping concepts — mapping Python classes to database tables, advantages, trade-offs, and when to use ORM vs raw SQL.
Database abstraction — understanding ORM trade-offs is important for architecture decisions.
4
SQLAlchemy
SQL toolkit and Object Relational Mapper (ORM) for Python.
Industry standard for SQL databases in Python. Crucial for understanding ORM patterns, session lifecycles, and N+1 query problems.
5
Connection Pooling
Technique to cache database connections for reuse, improving performance by avoiding connection overhead.
Performance tuning — understanding how connection pools work under load is critical for building scalable applications.
6
Async Database Access
Non-blocking database operations in Python utilizing asyncio for high concurrency.
Modern web architectures — vital for designing high-performance async APIs with FastAPI/asyncio.