Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... The differences between an SQLITE_OPEN_TEMP_DB database and an
SQLITE_OPEN_TRANSIENT_DB database is this: The SQLITE_OPEN_TEMP_DB
is used for explicitly declared and named TEMP tables (using the
CREATE TEMP TABLE syntax) or for named tables in a temporary database
that is created ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA locking_mode
... If no
database name qualifier precedes the "locking_mode" keyword then
the locking mode is applied to all databases, including any new
databases added by subsequent ATTACH commands.
The "temp" database (in which TEMP tables and indices are stored)
and in ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... this locking mechanism might
not work correctly if the database file is kept on an NFS filesystem.
This is because fcntl() file locking is broken on many NFS implementations.
You should avoid putting SQLite database files on NFS if multiple ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... No locking style. If none of the above can be supported, this
locking style is used. No database locking mechanism is used. When
this system is used it is not safe for a single database to be
accessed by multiple ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... phrase is an SQLite extension and
is not portable to other SQL database engines.
The "INDEXED BY index-name" phrase specifies
that the named index
must be used in order to look up values on the preceding table.
If index ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... If any process is writing to
the database no other process is allows to read or write. If any process
is reading the database other processes are allowed to read but not write.
The entire database shared a single lock ...
|
|
Isolation In SQLite
(isolation.html)
... There can be multiple database connections
open at the same time, and all of those database connections can write
to the database file, but they have to take turns. SQLite uses locks
to serialize the writes automatically; this is not ...
|
|
Database File Format
(fileformat.html)
1.2. Pages
... At any point in time, every page in the main database has a single
use which is one of the following:
A b-tree page
A table b-tree interior page
A table b-tree leaf page
An index b ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... 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 */
#define SQLITE_INTERRUPT 9 /* Operation terminated by ...
|
|
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 ...
... longer
read or write to the database file.
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 ...
|
Page generated by FTS5 in about 137.19 ms.