4. Invalid UTF in the database schema If a database schema contains names (table names, column names, index names, and so forth) that are invalid UTF, SQLite will continue to operate normally. As far as SQLite is concerned, those names are just byte sequences. SQLite does not ... 

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 ... 

 ... 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 ... 

 ... These problems could result 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 ... 

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 ... 

 ... 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 ... 

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 ... 

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 ... 

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 ... 

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 ...