SQLite sqlite_compileoption_get() Function

The SQLite sqlite_compileoption_get() function returns compile-time options for the specified location used to build SQLite.

Syntax

Here is the syntax of the SQLite sqlite_compileoption_get() function:

sqlite_compileoption_get(N)

Parameters

N

Required. A 0-based integer. It indicates the N-th option to get.

Return value

The SQLite sqlite_compileoption_get(N) function returns the N-th compile-time option used to build SQLite .

If N is out of range, the sqlite_compileoption_get(N) function will return NULL.

Examples

To get the first compile-time option for building SQLite, use the following statement:

SELECT sqlite_compileoption_get(0);

sqlite_compileoption_get(0)
---------------------------
ATOMIC_INTRINSICS=1

Of course, you can also the others multiple compile-time options, use the following statement:

SELECT
    sqlite_compileoption_get(1),
    sqlite_compileoption_get(2),
    sqlite_compileoption_get(3),
    sqlite_compileoption_get(4),
    sqlite_compileoption_get(5),
    sqlite_compileoption_get(6),
    sqlite_compileoption_get(7),
    sqlite_compileoption_get(8),
    sqlite_compileoption_get(9);

sqlite_compileoption_get(1) = COMPILER=gcc-7.5.0
sqlite_compileoption_get(2) = DEFAULT_AUTOVACUUM
sqlite_compileoption_get(3) = DEFAULT_CACHE_SIZE=-2000
sqlite_compileoption_get(4) = DEFAULT_FILE_FORMAT=4
sqlite_compileoption_get(5) = DEFAULT_JOURNAL_SIZE_LIMIT=-1
sqlite_compileoption_get(6) = DEFAULT_MMAP_SIZE=0
sqlite_compileoption_get(7) = DEFAULT_PAGE_SIZE=4096
sqlite_compileoption_get(8) = DEFAULT_PCACHE_INITSZ=20
sqlite_compileoption_get(9) = DEFAULT_RECURSIVE_TRIGGERS