Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Powersafe Overwrite
(psow.html)
... When writing, SQLite has made sure
to journal all bytes in the same sector of any modifications
and it pads journal files out to the next sector boundary so that
subsequent appends to that journal cannot damage prior records.
SQLite ...
|
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... For example, an application
that does not care about crash recovery or rollback might make
the open of a journal file a no-op. Writes to this journal would
also be no-ops, and any attempt to read the journal ...
|
|
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 ...
|
|
SQLite: Single File Database
(onefile.html)
... Temporary journal files are created as part of transaction control,
but those extra files are not part of the steady-state database.
|
|
C API: Low-Level Control Of Database Files
(c3ref/file_control.html)
sqlite3_file_control()
... The
SQLITE_FCNTL_JOURNAL_POINTER works similarly except that it returns
the sqlite3_file object associated with the journal file instead of
the main database. The SQLITE_FCNTL_VFS_POINTER opcode returns
a pointer to the underlying sqlite3_vfs object for the file.
The SQLITE_FCNTL_DATA_VERSION returns the data ...
|
|
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 ...
|
|
Isolation In SQLite
(isolation.html)
... Isolation And Concurrency
SQLite implements isolation and concurrency control (and atomicity) using
transient journal files that appear in the same directory as the database file.
There are two major "journal modes".
The older "rollback mode" corresponds to using the "DELETE ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.5. Other Example VFSes
... A quota group is a
set of files (database files, journals, and temporary files) whose
names all match a GLOB pattern. The sum of the sizes of all files
in each quota group is tracked, and if that sum exceeds ...
|
|
Transaction
(lang_transaction.html)
... EXCLUSIVE and IMMEDIATE are the same
in WAL mode, but in other journaling modes, EXCLUSIVE prevents
other database connections from reading the database while the
transaction is underway.
2.3. Implicit versus explicit transactions
An implicit transaction (a transaction that ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... Statement journals are held in memory until their size (in bytes)
exceeds this threshold, at which point they are written to disk.
Or if the threshold is -1, statement journals are always held
exclusively in memory.
Since many statement journals ...
|
Page generated by FTS5 in about 46.30 ms.