Skip to content

Database

Notes, interview prep, and deep dives on relational database fundamentals — built from real-world troubleshooting and study.

In This Section

  • Indexing — pages and full table scans, B-trees, hash indexes, geospatial indexes (geohash, quad tree, R-tree), inverted indexes, and how to pick one.
  • Sequence — how SQL sequences generate unique, auto-incrementing values.
  • Senior Engineer Database Answers — detailed answers to senior-level database questions.
  • Bigint vs Uuidv7 Id Strategy — choosing a primary key strategy and the trade-offs involved.

A companion question bank lives in database_questions.md.