Part one of this[0] is discussed here[1]

[0]https://jvns.ca/blog/2014/09/27/how-does-sqlite-work-part-1-...

[1]https://news.ycombinator.com/item?id=23663071