3 ms·
Is there a Ubuntu PPA or docker image of SQLite + JSON extension enabled? I can't get the compiled json1.so to load on Ubuntu 14.04 lts with stock SQLite.
by tenken 10y ago
Is there a Ubuntu PPA or docker image of SQLite + JSON extension enabled?
I can't get the compiled json1.so to load on Ubuntu 14.04 lts with stock SQLite.
- onli 10y agoI think the version on 14.04 is too old. I found the statement you need 3.9 for that (is that somewhere documented properly?). For what is worth, the sqlite3 version in Ubuntu 16.04 has that json1-extension loaded by default: sqlite> CREATE TABLE user (name TEXT, phone TEXT); sqlite> INSERT INTO user VALUES("tester", '{"phone":"704-56"}'); sqlite> SELECT DISTINCT user.name FROM user, json_each(user.phone) WHERE json_each.value LIKE '704-%'; tester I'm now even more happy I upgraded my server to that version yesterday, the server for that project was like yours on 14.04. It was even also because of sqlite, I wanted to have a version that supports the WITH clause. Upgrading to 16.04 (actually, I made a fresh install and moved the data over) seemed like the easiest way to get that.