If you want to understand the implementation, the DeepWiki documentation is very helpful:

https://deepwiki.com/drhsqlite/fossil-mirror/