Small. Fast. Reliable.
Choose any three.
Choose any three.
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... A hot journal is created when a process is in the middle of a database
update and a program or operating system crash or power failure prevents
the update from completing.
Hot journals are an exception condition.
Hot journals exist ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
1. Summary
... sqlite3_prepare() →
Compile SQL text into
byte-code that will do the work of querying or updating the database.
The constructor for sqlite3_stmt.
sqlite3_bind() →
Store application data into
parameters of the original SQL.
sqlite3_step() →
Advance an sqlite3_stmt to ...
|
|
Quality Management
(qmplan.html)
4. Software Verification Plan
... The set of checklist items for release checklist is potentially
updated for each release. The content and complete
history of each release checklist are retained for the historical
record.
|
|
VACUUM
(lang_vacuum.html)
... Frequent inserts, updates, and deletes can cause the database file
to become fragmented - where data for a single table or index is scattered
around the database file. Running VACUUM ensures that each table and
index is largely stored contiguously within ...
|
|
SQLite FTS5 Extension
(fts5.html)
4.4.2. Contentless-Delete Tables
... Contentless-delete tables do not support the
FTS5 delete command.
-- Supported UPDATE statement:
UPDATE ft SET a=?, b=?, c=? WHERE rowid=?;
-- This UPDATE is not supported, as it does not supply a new value
-- for column "c".
UPDATE ft SET ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... In this case either
the update or pre-update hook, or both, may be invoked. The P1 cursor must
have been positioned using NotFound prior to invoking this opcode in
this case. Specifically, if one is configured, the pre-update ...
|
|
SQLite Backup API
(backup.html)
3.1. File and Database Connection Locking
... and uses the same database handle (pDb), then the destination
database (the one opened using connection pFile) is automatically updated
along with the source. The backup process may then be continued after the
sqlite3_sleep() call returns as if nothing had ...
|
|
Why Is SQLite Coded In C
(whyc.html)
1.4. Stability
... Writing a small, fast, and reliable database engine is hard enough as it
is without the implementation language changing out from under you with
each update to the implementation language specification.
|
|
Transaction
(lang_transaction.html)
... A read transaction is started
by a SELECT statement, and a write transaction is started by
statements like CREATE, DELETE, DROP, INSERT, or UPDATE (collectively
"write statements"). If a write statement occurs while
a read transaction is active, then the ...
|
|
Imposter Tables
(imposter.html)
2.2. Transient Imposter Tables
Another (safer) approach to creating an imposter table is to add an
entry for the imposter table to SQLite's internal symbol table without
updating the "sqlite_schema" table on disk.
That way, the imposter table exists in only a single ...
|
Page generated by FTS5 in about 135.97 ms.