Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Constraint values in xBestIndex()
(c3ref/vtab_rhs_value.html)
sqlite3_vtab_rhs_value()
... When the sqlite3_vtab_rhs_value(P,J,V) interface is invoked from within
the xBestIndex method of a virtual table implementation, with P being
a copy of the sqlite3_index_info object pointer passed into xBestIndex and
J being a 0-based index into ...
|
|
CREATE TABLE
(lang_createtable.html)
... It is usually an error to attempt to create a new table in a database that
already contains a table, index or view of the same name. However, if the
"IF NOT EXISTS" clause is specified as part of the ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... Since the index is used to look up values in the table,
it is important that the index and table be kept consistent.
Now that there is an index on the examp table, we will have
to update that index ...
|
|
Implementation Limits For SQLite
(limits.html)
... An "index" in
the previous sentences means an index created explicitly using a
CREATE INDEX statement or implicit indices created by UNIQUE and
PRIMARY KEY constraints.
Whenever a database is opened, the entire schema is scanned and parsed
and a ...
|
|
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 ...
... Prohibit the use of SQL functions inside triggers, views,
CHECK constraints, DEFAULT clauses, expression indexes,
partial indexes, or generated columns
unless those functions are tagged with SQLITE_INNOCUOUS.
Prohibit the use of virtual tables inside of triggers or views
unless those ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SELECT name FROM sqlite_schema
WHERE type='table'
ORDER BY name;
For indices, type is equal to 'index', name is the
name of the index and tbl_name is the name of the table to which
the index belongs. For both tables ...
|
|
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 ...
|
|
C API: Create Or Redefine SQL Functions
(c3ref/create_function.html)
sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()
... The fourth parameter may also optionally include the SQLITE_DIRECTONLY
flag, which if present prevents the function from being invoked from
within VIEWs, TRIGGERs, CHECK constraints, generated column expressions,
index expressions, or the WHERE clause of partial indexes.
For best security ...
|
|
Change in Default Page Size in SQLite Version 3.12.0
(pgszchng2016.html)
... 3.0 Possible Negative Consequences Of This Change
The minimum size of an SQLite database is one page for each table and
each index. With a larger page size, the size of an empty database
for a given schema will ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
2.1. Queries
To query the geopoly table using an indexed geospatial search,
use one of the functions geopoly_overlap()
or geopoly_within() as a boolean function in the WHERE clause,
with the "_shape" column as the first argument to the function.
For example:
SELECT ...
|
Page generated by FTS5 in about 100.37 ms.