Database
This section covers databases, caching, query optimization, and data modeling — focused on the complete path from business models to query performance.
- MySQL, Postgres, and Redis
- Table structure design, indexing, and query optimization
- Transactions, concurrency, and consistency
- Data migration, backup, and debugging methods
Planned Notes
Section titled “Planned Notes”- Common index design decisions
- Postgres query analysis
- Redis caching strategies and invalidation issues
- Release workflows for data migrations