Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Database Remote-Copy Tool For SQLite
(rsync.html)
6. Why Can't I Just Use Ordinary rsync?
Ordinary rsync does not understand SQLite transactions. Rsync will make a
copy of ORIGIN into REPLICA, however the copy might not be consistent. Parts
of the copy might be from one transaction, while other parts might from
a different transaction ...
|
|
C API: Determine If A Prepared Statement Has Been Reset
(c3ref/stmt_busy.html)
sqlite3_stmt_busy()
... This can be used,
for example, in diagnostic routines to search for prepared
statements that are holding a transaction open.
See also lists of
Objects,
Constants, and
Functions.
|
|
C API: Configure an auto-checkpoint
(c3ref/wal_autocheckpoint.html)
sqlite3_wal_autocheckpoint()
The sqlite3_wal_autocheckpoint(D,N) is a wrapper around
sqlite3_wal_hook() that causes any database on database connection D
to automatically checkpoint
after committing a transaction if there are N or
more frames in the write-ahead log file. Passing zero or ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... But it will only do a few dozen transactions
per second. Transaction speed is limited by the rotational speed of
your disk drive. A transaction normally requires two complete rotations
of the disk platter, which on a 7200RPM disk drive ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.3. The transaction method
The "transaction" method is used to execute a TCL script inside an SQLite
database transaction. 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 ...
|
|
DROP TABLE
(lang_droptable.html)
... If
the implicit DELETE FROM causes any
deferred foreign key constraints to be violated, and the violations still
exist when the transaction is committed, an error is returned at the time
of commit.
|
|
SQLite Foreign Key Support
(foreignkeys.html)
4.2. Deferred Foreign Key Constraints
... Deferred foreign key constraints are not checked
until the transaction tries to COMMIT.
For as long as the user has
an open transaction, the database is allowed to exist in a state that
violates any number of deferred foreign key ...
|
|
SQLite: Single File Database
(onefile.html)
... Temporary journal files are created as part of transaction control,
but those extra files are not part of the steady-state database.
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... 7.0 Transaction Control At The SQL Level
The changes to locking and concurrency control in SQLite version 3 also
introduce some subtle changes in the way transactions work at the SQL
language level.
By default, SQLite version 3 operates ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA synchronous
... With synchronous=FULL in WAL mode, an additional
sync operation of the WAL file happens after each transaction commit.
The extra WAL sync following each transaction helps ensure that
transactions are durable across a power loss. Transactions are
consistent with ...
|
Page generated by FTS5 in about 119.49 ms.