For your own information, here is an alphabetical list of SQLite documents. There you can find lots of good stuff about SQLite.
The First thing I found particular important is also from that list - SQLite’s Architecture. Read the document carefully and examine what it says by tracing some codes in sqlite3 source.
Document some of your own findings below: