Comment by high_byte

I think EXPLAIN is a little known feature that gives a lot of insight about database internals, especially in Sqlite.

Funny you posted this now, I just recently researched Sqlite internals for my own project. Maybe you will find it interesting: https://twitter.com/high_byte/status/1607853384123703296

Interesting blog, I love that you keep consistency writing for so long.