Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.27. The preupdate method
... dbcmd preupdate count
dbcmd preupdate depth
dbcmd preupdate new INDEX
dbcmd preupdate old INDEX
The count submethod returns the number ...
|
|
Recent SQLite News
(news.html)
... These problems could results in incorrect query results or corrupt
indexes. See the associated forum threads for details.
Other trifling fixes are also included in the patch.
2024-01-30 - Version 3.45.1
Version 3.45.1 is a ...
|
|
The WITH Clause
(lang_with.html)
... CREATE TABLE edge(aa INT, bb INT);
CREATE INDEX edge_aa ON edge(aa);
CREATE INDEX edge_bb ON edge(bb);
The indexes are not required, but they do help performance
for large graphs.
To find all nodes of the graph that ...
|
|
Generated Columns
(gencol.html)
2.2. Capabilities
... Generated columns can participate in indexes, just like ordinary
columns.
The expression of a generated column can refer to any of the
other declared columns in the table, including other generated columns,
as long as the expression does not directly ...
|
|
UPSERT
(lang_upsert.html)
... A "uniqueness constraint"
is an explicit UNIQUE or PRIMARY KEY constraint within
the CREATE TABLE statement, or a unique index.
UPSERT does not intervene for failed NOT NULL, CHECK,
or foreign key constraints
or for constraints that are implemented using ...
|
|
JSON Functions And Operators
(json1.html)
4.9. The -> and ->> operators
... The -> and ->> operators take a JSON string or JSONB blob
as their left operand and a PATH expression or object field
label or array index as their right operand. The -> operator
returns a text JSON representation of the selected subcomponent ...
|
|
Application-Defined SQL Functions
(appfunc.html)
3. Security Implications
... In the expression part of an index on an expression.
In the WHERE clause of a partial index.
To put it another way, this setting requires that application-defined
functions only be run directly by top-level SQL invoked from ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.2. The xConnect Method
... Another example is a virtual table that implements a full-text index.
The xCreate method must create and initialize data structures to hold
the dictionary and posting lists for that index. The xConnect method,
on the other hand, only has ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1.1. Limitations
... Sometimes (for example if the
corruption is restricted to indexes) the recovery will perfectly restore
the database content. However in other cases, the recovery will be imperfect.
The impact of this imperfection depends on the application. A database that
holds ...
|
|
Database Remote-Copy Tool For SQLite
(rsync.html)
3. Limitations
... All of the table (and index) content will be byte-for-byte
identical in the replica. However, there can be some minor changes in
the database header. In particular, the replica will have the following
differences from the origin:
The ...
|
Page generated by FTS5 in about 94.37 ms.