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

Powered by ComboStrap