Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Obtain Values For URI Parameters
(c3ref/uri_boolean.html)
sqlite3_uri_parameter(), sqlite3_uri_boolean(), sqlite3_uri_int64(), sqlite3_uri_key()
... Beginning with SQLite version 3.31.0 (2020-01-22) the input F
parameter can also be the name of a rollback journal file or WAL file
in addition to the main database file. Prior to version 3.31.0 ...
|
|
C API: Status Parameters for database connections
(c3ref/c_dbstatus_options.html)
SQLITE_DBSTATUS_LOOKASIDE_USED, SQLITE_DBSTATUS_CACHE_USED, SQLITE_DBSTATUS_SCHEMA_USED, SQLITE_DBSTATUS_STMT_USED, SQLITE_DBSTATUS_LOOKASIDE_HIT, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE ...
... Specifically, the number of pages written to the
wal file in wal mode databases, or the number of pages written to the
database file in rollback mode databases. Any pages written as part of
transaction rollback or database recovery operations ...
|
|
C API: Write-Ahead Log Commit Hook
(c3ref/wal_hook.html)
sqlite3_wal_hook()
The sqlite3_wal_hook() function is used to register a callback that
is invoked each time data is committed to a database in wal mode.
The callback is invoked by SQLite after the commit has taken place and
the associated write-lock ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The SQLITE_PROTOCOL error is currently only
returned when using WAL mode and attempting to start a new transaction.
There is a race condition that can occur when two separate
database connections both try to start a transaction at the same ...
|
|
C API: Create and Destroy VFS Filenames
(c3ref/create_filename.html)
sqlite3_create_filename(), sqlite3_free_filename()
... The sqlite3_create_filename(D,J,W,N,P) allocates memory to hold a version of
database filename D with corresponding journal file J and WAL file W and
with N URI parameters key/values pairs in the array P. The result ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... The use of WAL mode largely obviates the
need for this asynchronous I/O module. Hence, this module is no longer
supported. The source code continues to exist in the SQLite source tree,
but it is not a part of ...
|
|
Powersafe Overwrite
(psow.html)
... In WAL mode, each transaction had to be padded out to the
next 4096-byte boundary in the WAL file, rather than the next 512-byte
boundary, resulting in thousands of extra bytes being written
per transaction.
The extra write ...
|
|
Version Numbers in SQLite
(versionnumbers.html)
1.2. The Historical Numbering System (Before 2015-10-14)
... The 3.6.23 to 3.7.0 change
was a result of adding support for WAL mode.
The 3.7.17 to 3.8.0 change was a result of rewrite known as the
next generation query planner.
The ...
|
|
Architecture of SQLite
(arch.html)
... WAL mode logic is in the separate
wal.c. In-memory caching is implemented by the
pcache.c and pcache1.c files.
The interface between page cache subsystem
and the rest of SQLite is defined by the header file pager ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... This step is only necessary if the application desires to keep
the database in WAL mode after the reset if it was in WAL mode before
the reset.
sqlite3_db_config(db, SQLITE_DBCONFIG_RESET_DATABASE, 1, 0);
sqlite3_exec(db, "VACUUM", 0, 0, 0);
sqlite3_db_config ...
|
Page generated by FTS5 in about 40.86 ms.