Some questions on SQLite internals
I am a student and looking for a project to implement.
Any documentation / write up which explains how SQLite WAL works? I checked this - https://sqlite.org/wal.html but I needed more info on how it is exactly implemented
Any documentation / write up which explains how SQLite handles page cache / virtual memory?
"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.