Small. Fast. Reliable.
Choose any three.
#define SQLITE_DBCONFIG_MAINDBNAME 1000 /* const char* */
#define SQLITE_DBCONFIG_LOOKASIDE 1001 /* void* int int */
#define SQLITE_DBCONFIG_ENABLE_FKEY 1002 /* int int* */
#define SQLITE_DBCONFIG_ENABLE_TRIGGER 1003 /* int int* */
#define SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER 1004 /* int int* */
#define SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION 1005 /* int int* */
#define SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE 1006 /* int int* */
These constants are the available integer configuration options that
can be passed as the second argument to the sqlite3_db_config() interface.
New configuration options may be added in future releases of SQLite.
Existing configuration options might be discontinued. Applications
should check the return code from sqlite3_db_config() to make sure that
the call worked.
R-42790-23372:[The sqlite3_db_config() interface will return a
non-zero error code if a discontinued or unsupported configuration option
is invoked.
]
- SQLITE_DBCONFIG_LOOKASIDE
-
R-19648-30943:[This option takes three additional arguments that determine the
lookaside memory allocator configuration for the database connection.
]
R-26835-10964:[The first argument (the third parameter to sqlite3_db_config() is a
pointer to a memory buffer to use for lookaside memory.
]
R-61949-35727:[The first argument after the SQLITE_DBCONFIG_LOOKASIDE verb
may be NULL in which case SQLite will allocate the
lookaside buffer itself using sqlite3_malloc().
]
R-47871-25994:[The second argument is the
size of each lookaside buffer slot.
]
R-04460-53386:[The third argument is the number of
slots.
]
The size of the buffer in the first argument must be greater than
or equal to the product of the second and third arguments. The buffer
must be aligned to an 8-byte boundary.
R-33038-09382:[If the second argument to
SQLITE_DBCONFIG_LOOKASIDE is not a multiple of 8, it is internally
rounded down to the next smaller multiple of 8.
]
R-53505-01828:[The lookaside memory
configuration for a database connection can only be changed when that
connection is not currently using lookaside memory, or in other words
when the "current value" returned by
sqlite3_db_status(D,SQLITE_CONFIG_LOOKASIDE,...) is zero.
Any attempt to change the lookaside memory configuration when lookaside
memory is in use leaves the configuration unchanged and returns
SQLITE_BUSY.
]
- SQLITE_DBCONFIG_ENABLE_FKEY
-
R-25136-65062:[This option is used to enable or disable the enforcement of
foreign key constraints.
]
There should be two additional arguments.
The first argument is an integer which is 0 to disable FK enforcement,
positive to enable FK enforcement or negative to leave FK enforcement
unchanged. The second parameter is a pointer to an integer into which
is written 0 or 1 to indicate whether FK enforcement is off or on
following this call. The second parameter may be a NULL pointer, in
which case the FK enforcement setting is not reported back.
- SQLITE_DBCONFIG_ENABLE_TRIGGER
-
R-02005-53466:[This option is used to enable or disable triggers.
]
There should be two additional arguments.
The first argument is an integer which is 0 to disable triggers,
positive to enable triggers or negative to leave the setting unchanged.
The second parameter is a pointer to an integer into which
is written 0 or 1 to indicate whether triggers are disabled or enabled
following this call. The second parameter may be a NULL pointer, in
which case the trigger setting is not reported back.
- SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
-
R-13380-27850:[This option is used to enable or disable the two-argument
version of the fts3_tokenizer() function which is part of the
FTS3 full-text search engine extension.
]
There should be two additional arguments.
The first argument is an integer which is 0 to disable fts3_tokenizer() or
positive to enable fts3_tokenizer() or negative to leave the setting
unchanged.
The second parameter is a pointer to an integer into which
is written 0 or 1 to indicate whether fts3_tokenizer is disabled or enabled
following this call. The second parameter may be a NULL pointer, in
which case the new setting is not reported back.
- SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
-
R-27882-15425:[This option is used to enable or disable the sqlite3_load_extension()
interface independently of the load_extension() SQL function.
]
The sqlite3_enable_load_extension() API enables or disables both the
C-API sqlite3_load_extension() and the SQL function load_extension().
There should be two additional arguments.
When the first argument to this interface is 1, then only the C-API is
enabled and the SQL function remains disabled. If the first argument to
this interface is 0, then both the C-API and the SQL function are disabled.
If the first argument is -1, then no changes are made to state of either the
C-API or the SQL function.
The second parameter is a pointer to an integer into which
is written 0 or 1 to indicate whether sqlite3_load_extension() interface
is disabled or enabled following this call. The second parameter may
be a NULL pointer, in which case the new setting is not reported back.
- SQLITE_DBCONFIG_MAINDBNAME
-
R-06824-28531:[This option is used to change the name of the "main" database
schema.
]
R-34937-45675:[The sole argument is a pointer to a constant UTF8 string
which will become the new schema name in place of "main".
]
R-36257-52125:[SQLite
does not make a copy of the new main schema name string, so the application
must ensure that the argument passed into this DBCONFIG option is unchanged
until after the database connection closes.
]
- SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
- Usually, when a database in wal mode is closed or detached from a
database handle, SQLite checks if this will mean that there are now no
connections at all to the database. If so, it performs a checkpoint
operation before closing the connection. This option may be used to
override this behaviour. The first parameter passed to this operation
is an integer - non-zero to disable checkpoints-on-close, or zero (the
default) to enable them. The second parameter is a pointer to an integer
into which is written 0 or 1 to indicate whether checkpoints-on-close
have been disabled - 0 if they are not disabled, 1 if they are.
See also lists of
Objects,
Constants, and
Functions.