Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA synchronous
... EXTRA (3)
EXTRA synchronous is like FULL with the addition that the directory
containing a rollback journal is synced after that journal is unlinked
to commit a transaction in DELETE mode. EXTRA provides additional
durability if the commit is followed ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... However, if the database file is being synced
as part of a multi-database commit, the argument points to a nul-terminated
string containing the transactions super-journal file name. VFSes that
do not need this signal should silently ignore ...
|
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
... Such changes will eventually
commit if the transaction continues to completion.
Use the sqlite3_blob_bytes() interface to determine the size of
the opened blob. The size of a blob may not be changed by this
interface. Use the UPDATE SQL command ...
|
|
Architecture of SQLite
(arch.html)
... The page cache also provides the rollback and atomic commit abstraction
and takes care of locking of the database file. The
B-tree driver requests particular pages from the page cache and notifies
the page cache when it wants to ...
|
|
WAL-mode File Format
(walformat.html)
2.1.1. The mxFrame field
... Because WAL frame are numbered
starting with 1, mxFrame is also the index of the last valid commit frame
in the WAL. A commit frame is a frame that has a non-zero "size of database"
value in bytes 4 ...
|
|
SQLite Keywords
(lang_keywords.html)
... ABORT
ACTION
ADD
AFTER
ALL
ALTER
ALWAYS
ANALYZE
AND
AS
ASC
ATTACH
AUTOINCREMENT
BEFORE
BEGIN
BETWEEN
BY
CASCADE
CASE
CAST
CHECK
COLLATE
COLUMN
COMMIT
CONFLICT
CONSTRAINT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATABASE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DETACH
DISTINCT ...
|
|
SQLite Older News
(oldnews.html)
... It is
as if ROLLBACK were being run instead of COMMIT in some cases.
Bug Details
Transactions commit in WAL mode by adding a record onto the end of
the WAL (the write-ahead log) that contains a "commit" flag ...
|
|
SQLite Consortium
(consortium.html)
... New SQLite developers
will be recruited and trained as necessary to cover the 23 day/year
support commitment.
Consortium members can call any developer at any time, day or
night, and expect to get their full and immediate attention.
Consortium ...
|
|
pressrelease-20071212.html
(pressrelease-20071212.html)
... said Bruce Carney, Director, Developer Programmes & Services, Symbian.
"Our involvement with the SQL Consortium not only demonstrates Symbian's commitment
to open standards in the industry, but as mobile phones become increasingly powerful
and smartphones become increasingly popular, we are ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... The transaction is committed when the script completes,
or it rolls back if the script fails. If the transaction occurs within
another transaction (even one that is started manually using BEGIN) it
is a no-op.
The transaction command can ...
|
Page generated by FTS5 in about 62.42 ms.