Version 0 of SQLite extension JSON1

Updated 2017-02-03 06:48:13 by dbohdan

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.

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.

#! /bin/sh
version=3160200
wget "https://sqlite.org/2017/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
sudo make install

See also