SQLite Forum

Some questions on SQLite internals
"Use the source, Luke."

A web search will find you articles on both things.  But some of the things I found were written 18 years ago.  SQLite's internals change frequently.  Old documents may not reflect how SQLite works now.

But SQLite is Open Source.  You can download all the source code, which includes useful comments.  Start there.  If you have specific questions about things you find there, We may be able to help you.