In-memory database with basic SQL

1Give yourself 5 minutes
2Answer out loud, not in your head
3Then compare with the answer below

Reference answer

Then expect these follow-ups

  • How would you add `GROUP BY`?

  • `ORDER BY`?

  • Indexed lookups via B-trees?

  • How would you shard across 16 nodes?

  • How would you test it (correctness fuzzing vs property-based testing)?

Free to read · better with Enzo

Practice this out loud with Enzo

Enzo runs it as a mock interview, pushes back with follow-ups, and grades you on the rubric.

Next question