sqlite3 CLI

To use sqlite-jsonschema with the sqlite3 command line interface, either download a pre-compiled extension for your machine from a Github Release, or compile your own version.

Once you have a jsonschema0.so, jsonschema0.dylib, or jsonschema0.dll extension, use the .load command in the sqlite3 CLI to load the extension into your connection.

sqlite> .load ./jsonschema0
sqlite> select jsonschema_version();
'v0.2.1'

You can include .load ./jsonschema0 at the top of your .sql scripts to load sqlite-jsonschema into your projects.

In build.sql:

.bail on

.load ./jsonschema0

select jsonschema_version();

Then run with:

sqlite3 :memory: '.read build.sql'