Sqlite - (Compile) Options

About

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

./sqlite3

• 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';