How to compare two SQLite databases on Linux

Question

Using Linux, I want to compare two SQLite databases that have the same schema. There will be just a few differences.

Is there a tool that would output these differences? Preferably output them to the command line, so that I can grep/sed them.

SQLite uses SQL, so a general SQL tool might also do.

Answer 1

One possibility is to use the sqlite3 command line client to export both databases and then diff the output. For example,

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