3 ms·
I made a SQLite disk-page explorer a little while ago, helped me understand B-trees a lot better: https://github.com/QuadrupleA/sqlite-page-explorer https://gi
by QuadrupleA 2y ago
I made a SQLite disk-page explorer a little while ago, helped me understand B-trees a lot better:
https://github.com/QuadrupleA/sqlite-page-explorer https://github.com/QuadrupleA/sqlite-page-explorer
- nayuki 2y agoI understood B-trees for their own sake since 2017 ( https://www.nayuki.io/page/btree-set https://www.nayuki.io/page/btree-set ), not motivated by SQLite. But relevant to what you shared, I wrote some tools in 2023 to parse SQLite files in TypeScript, right in the web browser: https://www.nayuki.io/page/sqlite-database-file-visualizations https://www.nayuki.io/page/sqlite-database-file-visualizatio...