I recently wrote an explainer for the sqlite file format with some helpful diagrams. This might help.

https://blog.jabid.in/2024/11/24/sqlite.html