sqlite3
sqlite3 copied to clipboard
janet-lang
Bindings to sqlite for the Janet language.
I wanted to build the version with my system's SQLite library. As far as I have debugged, the compilation steps do not create the output object files in the *build/*...
This also fixed some warning during compile for me, but is mainly just a plain old update.
Quick fix that I'm using: Add these lines after `sqlite3_open()` in `main.c`'s `sql_open()` : ``` status = sqlite3_enable_load_extension(conn, 1); if (status != SQLITE_OK) janet_panic(sqlite3_errmsg(conn)); ``` This enables the SQL function...
Test case: Running this: ``` (import sqlite3 :as sql) (def db (sql/open "test.db")) (sql/eval db `CREATE TABLE customers (id INTEGER PRIMARY KEY, "first-name" TEXT);`) (sql/eval db `INSERT INTO customers (id,...
[3.38.0](https://www.sqlite.org/releaselog/3_38_0.html) released early 2022 added json support by default so it might be good to upgrade at least to that point.
Is it currently possible to create a read-only connection to a sqlite DB file? I have zero experience with the C programming language, but from what I understand it should...
The version has fallen behind and some new features are in sqlite3
