https://www.sqlite.org/json1.html%|%JSON1%|% is an [SQLite] extension that provides functions for manipulating [JSON]. JSON data itself is not special-cased in SQLite when JSON1 is enabled; it is simply regarded as text. It's [JSON value extraction benchmark%|%fast%|%]. ** Installation ** Run the following POSIX shell commands to compile and install the SQLite Tcl extension with JSON1. If the installation is a success, be sure to remove the version installed with your OS' package manager to prevent Tcl from loading it instead. You can do this, e.g., with the command `sudo apt remove libsqlite3-tcl` on Debian/Ubuntu. ======none #! /bin/sh set -e version=3250100 wget "https://sqlite.org/2018/sqlite-autoconf-$version.tar.gz" tar zxvf "sqlite-autoconf-$version.tar.gz" cd "sqlite-autoconf-$version/tea" CFLAGS='-DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1' ./configure make sudo make install ====== ---- '''[oldlaptop] - 2021-11-09 05:55:17''' Probably good to check first before performing a manual installation on Linux/BSD/etc. - some (including recent Debian as of this writing) build their sqlite with JSON1 enabled by default. (Do note however that it's possible for the sqlite3 shell program to have a different set of extensions enabled than the C or Tcl libraries!) <<categories>> Data Serialization Format | SQLite