> Going with sqlite might not have been the best decision
Many have tried out this general idea. I myself evaluated git-bug for a few days in 2018 when it was a novel idea, but I ran into issues I tried to raise in my previous comment.
The data format you chose is not even the main issue here.
Binary data that keeps changing is generally always unfit for source control.
In your use case, you can solve that by committing sql dumps of the database in a text format.
Last week, I asked Gemini to give me episode names and air dates for a tv show, and it proceeded to fabricate two seasons worth of titles, not a single name or air date was correct. The episode names was even listed on (swedish) wikipedia, so it should been in their training data.
I just read that, too. Its interesting and somewhat depressing that the best option for the last 10+ years according to ars and this linked reddit thead, and comments in this thread all suggesting Apple TV. I hope to see a viable foss option soon.