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 ...
|
|
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 ...
|
|
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.
|
|
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 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 ...
|
|
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 ...
|
|
Recent SQLite News
(news.html)
... The "old.*" values in an UPDATE trigger might be incorrect
if the trigger fires in response to an UPSERT.
The sum() function might return NULL in some cases where Infinity
would be a better answer.
None of the problems are ...
|
Page generated by FTS5 in about 157.09 ms.