Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Appropriate Uses For SQLite
(whentouse.html)
... Also, file locking logic is buggy in
many network filesystem implementations (on both Unix and Windows).
If file locking does not work correctly,
two or more clients might try to modify the
same part of the same database at the ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
1. Overview
... Freelist pages, pointer-map pages, and the lock page are omitted from
the analysis.
By default, there is a single row in the DBSTAT table for each
btree page the database file. Each row provides
information about the space utilization ...
|
|
VACUUM
(lang_vacuum.html)
... Frequent inserts, updates, and deletes can cause the database file
to become fragmented - where data for a single table or index is scattered
around the database file. Running VACUUM ensures that each table and
index is largely stored contiguously within ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
... This separate temporary database file also has an associated
rollback journal.
The temporary database file used to store TEMP tables is deleted
automatically when the database connection is closed
using sqlite3_close().
The TEMP database file is very similar to auxiliary ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.5. Reading And Writing At The Same Time
... For this reason, it is not generally possible to modify
the R-Tree in the middle of a query of the R-Tree. Attempts to do so
will fail with a SQLITE_LOCKED "database table is locked" error.
So, for example ...
|
|
Architecture of SQLite
(arch.html)
... B-Tree
An SQLite database is maintained on disk using a B-tree implementation
found in the btree.c source file. Separate B-trees are used for
each table and each index in the database. All B-trees are stored ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... TableLock
Obtain a lock on a particular table. This instruction is only used when
the shared-cache feature is enabled.
P1 is the index of the database in sqlite3.aDb[] of the database
on which the lock is acquired. A ...
|
|
Distinctive Features Of SQLite
(different.html)
... And because a server
is a single persistent process, it is able control database access with
more precision, allowing for finer grain locking and better concurrency.
Most SQL database engines are client/server based. Of those that are
serverless, SQLite ...
|
|
The RBU Extension
(rbu.html)
2.1. RBU Update Limitations
... No other writes may occur on the target database while the
RBU update is being applied. A read-lock is held on the target
database to prevent this.
|
|
Command Line Shell For SQLite
(cli.html)
2. Special commands to sqlite3 (dot-commands)
... shell
.tables ?TABLE? List names of tables matching LIKE pattern TABLE
.timeout MS Try opening locked tables for MS milliseconds
.timer on|off Turn SQL timer on or off
.trace ?OPTIONS? Output each SQL statement as it is run
.unmodule ...
|
Page generated by FTS5 in about 139.76 ms.