Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Frequently Asked Questions
(faq.html)
... If your application has a need for a lot of concurrency, then you should
consider using a client/server database. But experience suggests that
most applications need much less concurrency than their designers imagine.
When SQLite tries to access a ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
6.3. Cache Spill Prior To Commit
... At the beginning of a cache spill, the status of the database
connection is as shown in step 3.6.
Original page content has been saved in the rollback journal and
modifications of the pages exist in user memory. To ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... To avoid encountering SQLITE_BUSY errors in the middle of a transaction,
the application can use BEGIN IMMEDIATE instead of just BEGIN to
start a transaction. The BEGIN IMMEDIATE command might itself return
SQLITE_BUSY, but if it succeeds, then SQLite guarantees ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA wal_checkpoint
... This ensures
that the next client to write to the database file restarts the log file
from the beginning. RESTART blocks concurrent writers while it is
running, but allowed readers to proceed.
TRUNCATE
This mode works the same way as ...
|
|
Database File Format
(fileformat.html)
... The names of internal schema objects
always begin with "sqlite_" and any table, index, view, or trigger
whose name begins with "sqlite_" is an internal schema object.
SQLite prohibits applications from creating objects whose names begin
with "sqlite_".
Internal schema ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
... The sqlite3_rsync utility program (available beginning with
SQLite 3.47.0 (2024-10-21) and later) will make a copy
of a live SQLite over SSH using a bandwidth-efficient protocol.
The VACUUM INTO filename command copies out
the current ...
|
|
WAL-mode File Format
(walformat.html)
... Because the shm is only used to coordinate access between concurrent
clients, the shm file is omitted if exclusive locking mode
is set, as an optimization. When exclusive locking mode is set,
SQLite uses heap memory in place of the ...
|
|
How SQLite Is Tested
(testing.html)
... The "mptester.c" program is a stress test for multiple processes
concurrently reading and writing a single database.
The "threadtest3.c" program is a stress test for multiple threads using
SQLite simultaneously.
The "fuzzershell.c" program is used to
run ...
|
|
SQLite Older News
(oldnews.html)
... A problem appeared in the CREATE INDEX command beginning with
version 3.8.2 (2013-12-06) that allowed, under some circumstances,
a UNIQUE index to be created on a column that was not unique. Once
the index was created ...
|
|
Compile-time Options
(compile.html)
... Because of security concerns, the two-argument fts3_tokenizer() feature
was disabled beginning with Version 3.11.0 (2016-02-15)
unless this compile-time option is used.
Version 3.12.0 (2016-03-29) added the
sqlite3_db_config(db,SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER,1 ...
|
Page generated by FTS5 in about 40.03 ms.