How do I store a sqlite database as plaintext in git, in a lossless way?

Asked Aug 11 '20 at 17:13

Active Feb 28 '21 at 15:59

Viewed 1,311 times

I want to store (small) sqlite database files as plaintext in my git repos. The goal is to make it easier to use traditional version-control features (easy-to-grok diffs, mergeability, ...) on such files. I have seen this approach thus far:

git config filter.sqlite3.clean 'sqlite3 %f .dump'
git config filter.sqlite3.smudge 'sqlite3 %f'
echo '*.db filter=sqlite3' >> .git/info/attributes

Is this a viable option? What are the failure modes? What are the costs? What other options exist?

Update: This causes weird checkout problems. Avoid it unless you're quite proficient with git.

edited Feb 28 '21 at 15:59

asked Aug 11 '20 at 17:13

HappyFace

3,439
2
24
43

https://stackoverflow.com/a/38271631/7976758 – phd Aug 11 '20 at 19:38
@phd I am very much interested in the data of the database, but I'll take a look at that anyway. Thanks. – HappyFace Aug 11 '20 at 19:53
The linked answer talks more about data (`.dump`) than just schema (`.schema`) and is easily adaptable anyway. – phd Aug 11 '20 at 19:54

How do I store a sqlite database as plaintext in git, in a lossless way?

0 Answers0