Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA optimize
... Applications that use long-lived database connections should run
"PRAGMA optimize=0x10002;" when the connection is first opened, and then
also run "PRAGMA optimize;" periodically, perhaps once per day or once
per hour.
All applications should run "PRAGMA optimize;" after ...
|
|
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 ...
... This option sets the
threading mode to Single-thread. In other words, it disables
all mutexing and puts SQLite into a mode where it can only be used
by a single thread. If SQLite is compiled with
the SQLITE_THREADSAFE=0 ...
|
|
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 ...
|
|
The Checksum VFS Shim
(cksumvfs.html)
4. Usage
Open database connections using the sqlite3_open() or
sqlite3_open_v2() interfaces, as normal. Ordinary database files
(without a checksum) will operate normally. Databases with
checksums will return an SQLITE_IOERR_DATA error if a page is
encountered that contains an invalid checksum.
Checksumming only ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
9.5. Deleting Or Renaming A Hot Journal
... opened. If either the original database file or the
hot journal have been moved or renamed, then the hot journal will
not be seen and the database will not be rolled back.
We suspect that a common failure mode for ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... WAL mode with PRAGMA synchronous set to NORMAL avoids calls to
fsync() during transaction commit and only invokes fsync() during
a checkpoint operation. The use of WAL mode largely obviates the
need for this asynchronous I/O module. Hence, this ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... The document only describes locking for the older rollback-mode
transaction mechanism. Locking for the newer write-ahead log or WAL mode
is described separately.
1.0 File Locking And Concurrency In SQLite Version 3
SQLite Version 3.0.0 ...
|
|
Compile-time Options
(compile.html)
2. Recommended Compile-time Options
... However, in WAL mode, complete
database integrity is guaranteed with PRAGMA synchronous=NORMAL. With
PRAGMA synchronous=NORMAL in WAL mode, recent changes to the database might
be rolled back by a power loss, but the database will not be corrupted ...
|
|
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 ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
SQLite Over a Network,Caveats and Considerations
Introduction
Users of the SQLite library, particularly application developers,
who want to access a SQLite database
from different systems connected by a network are often
tempted to simply open a database connection by ...
|
Page generated by FTS5 in about 82.28 ms.