Tin mới
For most purposes, SQLite can be built just fine using the default compilation options. However, if required, the compile-time options documented below can be used to omit SQLite features (resulting in a smaller compiled
SQLITE_OMIT_DECLTYPE. By omitting the (seldom-needed) ability to return the declared type of columns from the result set of query, prepared statements can be made to consume less memory.
This macro determines the initial setting for PRAGMA automatic_index for newly opened database connections. For all versions of SQLite through 3.7.17, automatic indices are normally enabled for new database connections i
The default schema format number used by SQLite when creating new database files is set by this macro. The schema formats are all very similar. The difference between formats 1 and 4 is that format 4 understands descendi
Sets the default size of the lookaside memory allocator memory pool to N entries of SZ bytes each. This setting can be modified at start-time using sqlite3_config(SQLITE_CONFIG_LOOKASIDE) and/or as each database connecti
This macro is used to determine whether or not the features enabled and disabled using the SQLITE_CONFIG_MEMSTATUS argument to sqlite3_config() are available by default. The default value is 1 (SQLITE_CONFIG_MEMSTATUS re
This macro is used to determine whether or not the features enabled and disabled using the SQLITE_CONFIG_MEMSTATUS argument to sqlite3_config() are available by default. The default value is 1 (SQLITE_CONFIG_MEMSTATUS re
https://sqlite.org/src/info/05f43be8fdda9f
This compile-time option causes the LIKE operator to always return False if either operand is a BLOB. The default behavior of LIKE is that BLOB operands are cast to TEXT before the comparison is done.
This option limits the total amount of memory that SQLite will request from malloc() to N bytes. Any attempt by SQLite to allocate new memory that would cause the sum of all allocations held by SQLite to exceed N bytes w
Set an upper bound on the sqlite3_limit(db,SQLITE_LIMIT_WORKER_THREADS,N) setting that determines the maximum number of auxiliary threads that a single prepared statement will use to aid with CPU-intensive computations (
Set the default size limit (in bytes) for in-memory databases created using sqlite3_deserialize(). This is just the default. The limit can be changed at start-time using sqlite3_config(SQLITE_CONFIG_MEMDB_MAXSIZE,N) or a
This option limits the maximum width and precision of substitutions for the printf() SQL function and the other C-language string formatting functions such as sqlite3_mprintf() and sqlite3_str_appendf(). This is turn can
This option limits the maximum width and precision of substitutions for the printf() SQL function and the other C-language string formatting functions such as sqlite3_mprintf() and sqlite3_str_appendf(). This is turn can
This compile-time option sets an upper bound on the size of memory allocations that can be requested using sqlite3_malloc64(), sqlite3_realloc64(), and similar. The default value is 2,147,483,391 (0x7ffffeff) and this sh
This option is typically used when building SQLite for an embedded platform with a custom operating system.
To put it another way, SQLITE_THREADSAFE=1 sets the default threading mode to Serialized. SQLITE_THREADSAFE=2 sets the default threading mode to Multi-threaded. And SQLITE_THREADSAFE=0 sets the threading mode to Single-t
To put it another way, SQLITE_THREADSAFE=1 sets the default threading mode to Serialized. SQLITE_THREADSAFE=2 sets the default threading mode to Multi-threaded. And SQLITE_THREADSAFE=0 sets the threading mode to Single-t
Future versions of SQLite might enable the batch-atomic-write capability by default, at which point this compile-time option will become superfluous.
sqlite3_column_database_name()
This option was formerly used to enable the sqlite3_serialize() and sqlite3_deserialize() interfaces. However, as of SQLite 3.36.0 (2021-06-18) those interfaces are enabled by default and a new compile-time option SQLITE
This macro enables the built-in SQL math functions. This option is automatically added to the Makefile by the configure script on unix platforms, unless the --disable-math option is used. This option is also included on
This option adds extra logic to SQLite that allows it to release unused memory upon request. This option must be enabled in order for the sqlite3_release_memory() interface to work. If this compile-time option is not use
This option includes the sqlite3_normalized_sql() API.
This option enables an optimization that omits NULL columns at the ends of rows, for a space savings on disk.
This option causes the query planner stability guarantee (QPSG) to be on by default. Normally the QPSG is off and must be activated at run-time using the SQLITE_DBCONFIG_ENABLE_QPSG option to the sqlite3_db_config() inte
This option enables the sqlite3_stmt_scanstatus() and sqlite3_stmt_scanstatus_v2() interfaces and activates the nexec and ncycle columns of the bytecode virtual table. These features are normally omitted or deactivated b
This option enables the sqlite3_unlock_notify() interface and its associated functionality. See the documentation titled Using the SQLite Unlock Notification Feature for additional information.
Using the SQLite Unlock Notification Feature
This option enables the sqlite3_unlock_notify() interface and its associated functionality. See the documentation titled Using the SQLite Unlock Notification Feature for additional information.
Defining this option causes the sqlite3_set_authorizer() API function and related logic to be omitted.
This option is omits the AUTOINCREMENT feature. When this is macro is defined, columns declared as "INTEGER PRIMARY KEY AUTOINCREMENT" behave in the same way as columns declared as "INTEGER PRIMARY KEY" when a NULL is in
This option is used to omit the compile-time option diagnostics available in SQLite, including the sqlite3_compileoption_used() and sqlite3_compileoption_get() C/C++ functions, the sqlite_compileoption_used() and sqlite_
This option causes the sqlite3_complete() and sqlite3_complete16() interfaces to be omitted.
This option causes support for common table expressions to be omitted.
This option causes SQLite to omit support for the sqlite3_column_decltype() and sqlite3_column_decltype16() interfaces.
This option is used to omit floating-point number support from the SQLite library. When specified, specifying a floating point number as a literal (i.e. "1.01") results in a parse error.