I wrote a tool that dumps a SQLite database out to disk as diffable JSON, precisely so you can easily record changes made to the database over time: https://github.com/simonw/sqlite-diffable
I have a demo of it running against my blog's database here: https://github.com/simonw/simonwillisonblog-backup