Indexing/search/relations/performance would be some counterpoints that SQlite already solved. I have experience with flat file CMS systems (similar usecase) an

Indexing/search/relations/performance would be some counterpoints that SQlite already solved. I have experience with flat file CMS systems (similar usecase) and at some point of complexity you end up rewriting your own database. Once every file has UUID an you have text file indexes of these than you realize you might have gone too far. But not all projects need that and the argument for version control is big.