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