3

Is there a SQLite distribution for Linux/Ubuntu that is compiled with the JSON1 extension. The instructions on the SQLite JSON1 page only explain how to load the extension after compiling it - a digression I would like to avoid.

DroidOS
  • 8,530
  • 16
  • 99
  • 171

1 Answers1

14

Ubuntu Xenial comes with SQLite 3.11.0-1ubuntu1 which is compiled with JSON1 extension.

$ docker run --rm -it ubuntu:xenial
# apt-get update && apt-get install --no-install-recommends -y sqlite3
# echo "PRAGMA compile_options;" | sqlite3 | grep JSON1
ENABLE_JSON1
saaj
  • 23,253
  • 3
  • 104
  • 105
  • 2
    Perfect! Not only do you tell me that is available by default, you also tell me now to verify that it is. Nice answer. – DroidOS Mar 18 '18 at 05:43