Is there any value to SQLite in VCS

Question

Having an argument with my team. We are developing an application using SQLite, and some want to add it to the repo (GIT), and some do not. Previously, in the RDBMS system, the advantages of using VCS in a database were not visible. However, SQLite is a stand-alone file without external dependencies, so I assume that even if it is binary, fixing the project code + SQLite file will give an accurate snapshot of the game’s state at this point.

I also assume that branch and merge will work as well.

Has anyone really done this, and if it works that way?

Answer 1

You will get more benefits from GIT version control if you saved a dump of the SQLite database (i.e. the commands needed to create it), rather than the database file itself. Thus, you can look at the history of the dump file and see tables or data being added, etc.

Answer 2

Generally speaking, it is preferable to include the full set of dependencies in the VCS repository. It makes your life a lot easier.

If you are using the DB schema version, check out Wizardby .