This native module proves sqlite bindings for janet.

jpm install sqlite3 

To build, use the jpm tool and make sure you have janet installed.

jpm build 

Usually, a Linux system has a package for SQLite installed globally. This packages will usually have many plugins for SQlite enabled (e.g JSON1, FTS3 etc.). The Debian package or Gentoo ebuild are good examples.

This package allows one to use it instead of the SQLite sources included with the package. To do this use:

export JANET_SYSTEM_SQLITE=1 jpm build 

Note, if you intead to install the package globally, use:

sudo -E jpm build 

You can use the jpm rule to update the version of SQLite included.

jpm run update-sqlite3 

You can find the latest version https://sqlite.org/index.html.

Next, enter the repl and create a database and a table. By default, the generated module will be in the build folder.

janet:1:> (import build/sqlite3 :as sql) nil janet:2:> (def db (sql/open "test.db")) <sqlite3.connection 0x5561A138C470> janet:3:> (sql/eval db `CREATE TABLE customers(id INTEGER PRIMARY KEY, name TEXT);`) @[] janet:4:> (sql/eval db `INSERT INTO customers VALUES(:id, :name);` {:name "John" :id 12345}) @[] janet:5:> (sql/eval db `SELECT * FROM customers;`) @[{"id" 12345 "name" "John"}] 

Finally, close the database connection when done with it.

janet:6:> (sql/close db) nil