Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... Five locking strategies
are available:
POSIX locking style. This is the default locking style and the
style used by other (non Mac OS X) Unixes. Locks are obtained and
released using the fcntl() system call.
AFP locking style. This locking ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SQLite uses reader/writer locks to control access to the database.
(Under Win95/98/ME which lacks support for reader/writer locks, a
probabilistic simulation is used instead.)
But use caution: this locking mechanism might
not work correctly if the ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... The entire database shared a single lock.
When SQLite tries to open a database and finds that it is locked, it
can optionally delay for a short while and try to open the file again.
This process repeats until the ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... SQLITE_ABORT 4 /* Callback routine requested an abort */
#define SQLITE_BUSY 5 /* The database file is locked */
#define SQLITE_LOCKED 6 /* A table in the database is locked */
#define SQLITE_NOMEM 7 /* A malloc() failed */
#define SQLITE_READONLY 8 /* Attempt to write a readonly database ...
|
|
Isolation In SQLite
(isolation.html)
... SQLite uses locks
to serialize the writes automatically; this is not something that
the applications using SQLite need to worry about.
Isolation And Concurrency
SQLite implements isolation and concurrency control (and atomicity) using
transient journal files that appear in the ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... If
INDEXED BY is to be used at all, it should be inserted at the very
end of the development process when "locking down" a design.
2. See Also
The query planner checklist describes steps that application
developers should following ...
|
|
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 ...
... The SQLITE_FCNTL_WAL_BLOCK is a signal to the VFS layer that it might
be advantageous to block on the next WAL lock if the lock is not immediately
available. The WAL subsystem issues this signal during rare
circumstances in order to ...
|
|
SQLite Is Serverless
(serverless.html)
1. SQLite Is Serverless
... And because a server is a single persistent process,
it is able to control database access with more precision,
allowing for finer-grained locking and better concurrency.
Most SQL database engines are client/server based.
Of those that are serverless ...
|
|
C API: Evaluate An SQL Statement
(c3ref/step.html)
sqlite3_step()
... SQLITE_BUSY means that the database engine was unable to acquire the
database locks it needs to do its job. If the statement is a COMMIT
or occurs outside of an explicit transaction, then you can retry the
statement. If the ...
|
|
Uniform Resource Identifiers
(uri.html)
3.3. Recognized Query Parameters
... SQLite always opens immutable database files
read-only and it skips all file locking and change detection
on immutable database files. If this query parameter (or
the SQLITE_IOCAP_IMMUTABLE bit in xDeviceCharacteristics)
asserts that a database file is immutable and that ...
|
Page generated by FTS5 in about 48.02 ms.