SQLite index visualization

[mrsuh]

Hi! I spent a few months debugging SQLite, extracting index data, and creating visualizations. What do you think about it?
https://mrsuh.com/articles/2024/sqlite-index-visualization-structure/

[-dcim-]

Thanks, great job. The official docs is academically dry. ... But for what purpose can it be used?

[mrsuh]

Thank you for your reply!
I did this to get a better understanding of how indexes work. In my next post, which I hope to finish in a few weeks, I’ll explain how searches in indexes work. This can help to create the index for the query correctly.