SQLite Version 3 Overview
(version3.html)
... A limited form of table-level locking is now also available in SQLite.
If each table is stored in a separate database file, those separate
files can be attached to the main database (using the ATTACH command)
and the combined ...
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Another solution might be to limit
the number of times that any single query could be reattempted (to say
100). Although this might be less efficient than one might wish, the
situation in question is not likely to occur often ...
|
SQL Language Expressions
(lang_expr.html)
... Hexadecimal integer literals are interpreted as 64-bit
two's-complement integers and are thus limited
to sixteen significant digits of precision.
Support for hexadecimal integers was added to SQLite
version 3.8.6 (2014-08-15).
For backwards compatibility ...
|
SQLite FTS5 Extension
(fts5.html)
6.2. The 'crisismerge' Configuration Option
... The difference between this option and the 'automerge' option is that when
the 'automerge' limit is reached FTS5 only begins to merge the b-trees
together. Most of the work is performed as part of subsequent INSERT,
UPDATE or DELETE ...
|
How SQLite Is Tested
(testing.html)
4.3. Boundary Value Tests
SQLite defines certain limits on its operation, such as the
maximum number of columns in a table, the maximum length of an
SQL statement, or the maximum value of an integer. The TCL and TH3 test
suites both contains numerous ...
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... The disabled
features include but are not limited to the following:
The PRAGMA writable_schema=ON statement.
The PRAGMA journal_mode=OFF statement.
The PRAGMA schema_version=N statement.
Writes to the sqlite_dbpage virtual table.
Direct writes to shadow tables.
SQLITE_DBCONFIG_WRITABLE_SCHEMA
The SQLITE_DBCONFIG_WRITABLE_SCHEMA ...
|
ALTER TABLE
(lang_altertable.html)
... Overview
SQLite supports a limited subset of ALTER TABLE.
The ALTER TABLE command in SQLite allows
these alterations of an existing table:
it can be renamed;
a column can be renamed;
a column can be added to it;
or
a ...
|
Recent SQLite News
(news.html)
... One bug of note is
ticket 9936b2fa443fec
which describes a hard-to-reach condition where the ORDER BY LIMIT
optimization might cause an infinite loop during query evaluation.
This ticket raised a lot of
concern on
HackerNews and
Reddit,
probably ...
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
4.2. Shadow Tables
... The underlying R-Tree implementation uses bounding boxes to limit the search
space. Then the geoploy_overlap() and/or geopoly_within() routines further
refine the search to the exact answer.
This page last modified on 2023-12-05 14:43:20 UTC
|
Vulnerabilities
(cves.html)
3. Status Of Recent SQLite CVEs
... This might enable a denial-of-service, if the
application has not taken appropriate and prudent steps
to limit the run-time of SQL statements. This is not a vulnerability, as there
are countless perfectly valid SQL queries, especially queries ...
|
Page generated by FTS5 in about 79.34 ms.