SQLite Diff
SQLite Diff is a graphical comparison tool for SQLite database files, comparing both the schema and the data. Schema results include comparisons of tables/columns, triggers, indexes and views. Changed SQL code including trigger SQL, index creation SQL, view creation SQL code and changed data records are displayed with yellow highlighting to make it easier to see the differences between the compared files.
Advantages for Revolution Developers
Revolution's built-in revDB functionality supports the use of SQLite database files within Revolution projects. SQLite can be used as a fast and lightweight database engine useful for storing application preferences or even as the main data store for single-user applications.
Why might you need a SQLite comparison tool?
- You need to read undocumented (or poorly documented) SQLite database files created by popular applications including:
- Photoshop Lightroom, Adobe AIR, Skype, FireFox, Apple Mail, Safari, Aperture, Solaris 10, Revolution, REALbasic and Bento by FileMaker.
- SQLite Diff is optimized for reverse-engineering complex SQLite schemas, enabling you to see the changes within the SQLite database file as it is modified by an application.
- You might have made undocumented changes to your own SQLite database files and you need to figure out what you changed weeks or months ago.
- Troubleshooting your own application - which previously worked but now has unexpected errors. Did you change your schema or data within the database in such as way as to cause an unexpected program error? Compare a previous known working SQLite database with the current one to find answers to these questions in seconds.
SQLite Schema Comparison
Comparing two SQLite database files is as simple as dragging and dropping the files onto SQLite Diff and pressing the Compare button. The schemas of each file are compared and the results are displayed in a few seconds. Clicking each object (Table, Trigger, View or Index) instantly displays the detailed results for the selected object.
SQLite Data Comparison
SQLite Diff uses the SQLite ROWID value to compare each record between each of the database files.
The tables list contains summary info displaying the difference count and number of records found in each source database file.
Clicking on an individual table displays the added/deleted/changed records as a comparison between first database (DB1) and the second database file (DB2).