A complete guide to connecting to MySQL from Python using mysql-connector-python — creating connections, CRUD operations, parameterized queries, transactions, connection pooling, and safe error handling.
A complete guide to connecting to Microsoft SQL Server from Python using pyodbc — connection strings, CRUD operations, parameterized queries, stored procedures, transactions, and production-safe connection patterns.
A complete guide to connecting to Oracle Database from Python using python-oracledb — thin/thick modes, CRUD operations, named placeholders, RETURNING INTO, stored procedures, transactions, and LOB handling.
A complete guide to connecting to PostgreSQL from Python using psycopg2 — connections, CRUD operations, RETURNING, PostgreSQL-specific data types, UPSERT, connection pooling, transactions, and error handling.
A complete guide to SQLAlchemy in Python — Core vs ORM, defining models, table relationships, CRUD operations, advanced queries (joins, filters, subqueries), session management, and migrations with Alembic.
A complete guide to the Django ORM — model definitions, field types, ForeignKey/ManyToMany/OneToOne relationships, the QuerySet API, advanced filtering, aggregation, select_related, prefetch_related, transactions, and raw SQL.