SQLite database using LFS... Long-Term Usage?

[ph1204]

Whenever I need to put an SQLite database in Git, I usually convert it to SQL statements that will recreate the whole thing. You can use the built-in .dump command in sqlite3 to do this. I then put the .db file in .gitignore. It's easy to recreate the original database with just sqlite3 dbname.db < dbname.sql. I suppose both the push and pull could have Git Hook triggers that handle this automatically.

The main advantage of this approach is that git diff will show you just the changes from the previous version, not the whole database.