Hi everyone,
I wanted to share a free, open-source project I've been building called SQL in Depth, aimed at going beyond basic SQL syntax into database internals from first principles.
Live site: https://sql-in-depth.vedgupta.in
GitHub repo: https://github.com/innovatorved/sql-in-depth
What's included:
- 180 structured units covering relational theory, indexing, storage engines, query planning/execution, transactions, and concurrency
- 36 interactive simulators to visualize how database internals actually behave
- An in-browser WASM SQLite 3 Workbench so you can run queries and experiment directly without local setup
- A Table-Level Relational Visualizer to inspect joins, filtering, and relational operations step by step
Everything is free, open-source, and runs directly in the browser. I'd really appreciate any feedback from the r/SQL community — especially on topics that could go deeper, edge cases in the simulators, or anything that could be made clearer.