[simonw]

Not for this technique, because this relies on the fact that SQLite databases are a single file that can be checked into Git.

MySQL and PostgreSQL use a whole directory full of files. You could try storing that whole thing in Git and then tiring a custom diff command that can load those directories into a temporary database sever and dump out SQL for comparison, but it would be very slow and brittle if you could even get it to work at all.

Instead, a better strategy would be to dump your MySQL or PostgreSQL database to plain SQL and store that in your Git repo. Or use the trick in using here for my PostgreSQL database: https://news.ycombinator.com/item?id=38114171

[infamia]

> Or use the trick in using here for my PostgreSQL database: https://news.ycombinator.com/item?id=38114171

I wonder how this approach handles converting decimal fields, considering SQLite does not have a decimal field type and only has floats (i.e., you could potentially lose some precision during the conversion)?

[simonw]

Probably! I don't deal with decimal fields in my projects so I've not explored that yet.