Comment by justinclift

On the more practical side, SQLite has the "sqldiff" utility:

https://www.sqlite.org/sqldiff.html

By default it compares whole databases, but it can be told to only compare a specific table in each:

    sqldiff -t mytable database1.sqlite database2.sqlite