This folder has no README. Everything inside it is listed below.
Folders
- sqlalchemy (15)
Notes
- SQL fundamentals
- Database Indexes — Fundamentals · 10 angles
- How SQL Queries Are Processed by the Engine · 4 angles
- SQL Transactions · 4 angles
- Relationships and Keys in PostgreSQL · 4 angles
- SQLAlchemy · 3 angles
- N+1 query problem
- Transactions and isolation levels
- Connection pooling
- EXPLAIN and EXPLAIN ANALYZE
- Index types
- Window functions and CTEs
- Zero-downtime migrations
- Sharding and Partitioning · 10 angles
- CAP, ACID, BASE, PACELC
- Alembic · 6 angles
- MySQL · 5 angles
- SQLite · 5 angles
- VACUUM, autovacuum, table bloat, and transaction wraparound · 7 angles
- PostgreSQL Advisory Locks · 6 angles
- Replication and Logical Decoding · 6 angles
- WAL, Checkpoints, and fsync · 6 angles
- Isolation Anomalies Across Databases — Postgres vs MySQL vs SQLite · 7 angles