Skip to content

Latest commit

 

History

History
13 lines (9 loc) · 709 Bytes

README.md

File metadata and controls

13 lines (9 loc) · 709 Bytes
Raw

sqlitediff

Utility to facilitate fast feedback for learning SQL on a known SQLite database.

Usage: java -jar SQLiteDiff <answer file> <query file> where ...

  • answer file is a CSV representing the desired output of the query
  • query file is a text file containing only SQL to run

The utility reads the query file, executes it on a bundled SQLite database, and then compares rows/columns to the contents of the answer file, providing a detailed account of differences.

Note: the included database is currently Chinook [https://github.com/lerocha/chinook-database] but could theoretically be any SQLite database.

Tested on latest versions of macOS, Ubuntu, and Windows using Oracle/Open JDK 8 - 14.