SQLite and JSON

SQLite with JSON

Below shows you how to compile SQLite to enable JSON. In addition, I’ve added a local location for the installation.

./configure --enable-json1 --enable-readline  --prefix=/home/user/sqlite
make
make install

Example

Below is an example from the SQLite command prompt

sqlite> select json_extract('{"a":2,"c":[4,5,{"f":7}]}', '$.c[2].f');
7