Compare 2 SQLite databases


Testing a web app, for example with Selenium, might involve a number of CRUD operations on an SQLite database. Given that you do not want to leave the results of the testing in the database it is not a bad idea to try, as part of the test, to reverse all the CRUD operations as part of the testing (possibly as a separate test). It then becomes useful to know if the database has been restored to its original state.

A question on Stackoverflow suggests:

sqlite3 first.sqlite .dump >first.dump
sqlite3 second.sqlite .dump >second.dump
diff first.dump second.dump

In addition to diff one can do an md5sum on the two dumps.