Small. Fast. Reliable.
Choose any three.
Choose any three.
|
pressrelease-20071212.html
(pressrelease-20071212.html)
... Additional
information regarding the SQLite Consortium is available at the SQLite website,
http://www.sqlite.org/.
# # #
About SQLite
SQLite is a software library that implements a self-contained, embeddable,
serverless, zero-configuration, transactional SQL database engine. The code for
SQLite ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... A write
lock is obtained on the database file when a transaction is started.
No other process can read or write the file while the transaction is
underway. Starting a transaction also creates a rollback journal. A
transaction must be ...
|
|
SQLite Autoincrement
(autoinc.html)
3. The AUTOINCREMENT Keyword
... Only ROWID values from previous transactions that
were committed are considered. ROWID values that were rolled back
are ignored and can be reused.
SQLite keeps track of the largest ROWID
using an internal table named "sqlite_sequence".
The sqlite_sequence table is ...
|
|
The Error And Warning Log
(errlog.html)
3. Variety of Error Messages
... SQLITE_NOTICE messages are logged whenever a database has to be recovered
because the previous writer crashed without completing its transaction.
The error code is SQLITE_NOTICE_RECOVER_ROLLBACK when recovering a
rollback journal and SQLITE_NOTICE_RECOVER_WAL when recovering a
write-ahead log.
SQLITE_WARNING messages ...
|
|
Memory-Mapped I/O
(mmap.html)
... First, changes to the database
are not supposed to be visible to other processes until
after the transaction commits and so the changes must occur in private memory.
Second, SQLite uses a read-only memory map to prevent stray pointers ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
7.4. The "merge=X,Y" command
... Each "merge=X,Y" command will run in a separate
transaction (unless they are grouped together using BEGIN...COMMIT,
of course). The transactions can be kept small by choosing a value
for X in the range of 100 to 300 ...
|
|
SQLite Archive Files
(sqlar.html)
2. Advantages Of SQLite Archives
... An SQLite Archive is transactional.
Updates are atomic and durable, even if there are crashes
or power losses in the middle of the update.
Readers see a consistent and unchanging version of the content even
is some other process is ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.15. The xBegin Method
int (*xBegin)(sqlite3_vtab *pVTab);
This method begins a transaction on a virtual table.
This method is optional. The xBegin pointer of sqlite3_module
may be NULL.
This method is always followed by one call to either the
xCommit or xRollback method ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
2. The VFS In Relation To The Rest Of SQLite
... The Pager module is responsible for loading pages of the database
file into memory, for implementing and controlling transactions, and
for creating and maintaining the journal files that prevent database
corruption following a crash or power failure.
The OS Interface ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... When this option is enabled, SQLite automatically detects
that the underlying filesystem supports batch atomic writes, and
when it does so it avoids writing the rollback journal for transaction
control. This can make transactions over twice as fast, while
simultaneously ...
|
Page generated by FTS5 in about 128.14 ms.