> this could've been an sqlite db

And yet Fossil doesn't use SQLite for its own data model, just as a blob store with indices.

"Fossil is not Relational": https://fossil-scm.org/home/doc/trunk/www/fossil-is-not-rela...