SQLite

The sq Postgres driver implements connectivity for the SQLite database. The driver implements all optional driver features.

Add source

Use sq add to add a source. The location argument is simply the filepath to the SQLite DB file. For example:

sq add ./sakila.db

You can also supply the absolute filepath, or use a URI with the sqlite3:// prefix. For example:

$ sq add /Users/neilotoole/sakila.db
$ sq add 'sqlite3:///Users/neilotoole/sakila.db'

Create new SQLite DB

You can use sq to create a new, empty, SQLite DB file.

$ sq add --driver sqlite3 hello.db
@hello_sqlite  sqlite3  hello.db