Sqlite - (Compile) Options

Sqlite Banner


Options in Sqlite permits to see which feature is enabled or not.

The options are dependent:

  • of the compile option. They may be or not enabled when creating the sqlite application
  • on the sqlite version. For instance, json support is only available since the version 3.9.0

How to list the options

From the cli

From the cli with the pragma command

  • Start the cli at the command line
  • Execute the pragma
PRAGMA compile_options;

From SQL

From any sql client with the sql version of the pragma command

select * from pragma_compile_options() where compile_options = 'xxxx';

For instance for json

select * from pragma_compile_options() where compile_options = 'ENABLE_JSON1';

Discover More
Card Puncher Data Processing
Datacadamia - Data all the things

Computer science from a data perspective
Sqlite Banner

sqlite can query the json format with the JSON extension since the version 3.9.0 (2015-10-14) If you have a json string stored in a text data type, you can extract...

Share this page:
Follow us:
Task Runner