Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Profiling SQL Queries
(profile.html)
3. Complex Cases - Rows, Loops and Cycles
... AS v1 CROSS JOIN
ft('sqlite'),
cnt
WHERE cnt.i=ft.rowid AND v1.a=ft.rowid;
<...query results...>
QUERY PLAN (cycles=177665334 [100%])
|--CO-ROUTINE v1 (cycles=4500444 [3%])
| |--SCAN t1 (cycles=397052 ...
|
|
The Carray() Table-Valued Function
(carray.html)
3.1. Single-Argument CARRAY
... SQLITE_STATIC → This means that the application that invokes
sqlite3_carray_bind() maintains ownership of the data array and that
the application promises SQLite that it will not change or deallocate
the data until after the prepared statement is finialized.
SQLITE_TRANSIENT &rarr ...
|
|
Generated Columns
(gencol.html)
3. Compatibility
Generated column support was added with SQLite version 3.31.0
(2020-01-22). If an earlier version of SQLite attempts to read
a database file that contains a generated column in its schema, then
that earlier version will perceive ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
8.5. Corruption following alternating writes from 3.6 and 3.7
SQLite version 3.7.0 introduced a number of new enhancements to
the SQLite database file format (such as but not limited to WAL).
The 3.7.0 release was a shake-out release for these new features.
We expected ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.3. The transaction method
The "transaction" method is used to execute a TCL script inside an SQLite
database transaction. The transaction is committed when the script completes,
or it rolls back if the script fails. If the transaction occurs within
another transaction (even one ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
3.3. Reading Information Out Of The Database
After the shared lock is acquired, we can begin reading
information from the database file. In this scenario, we
are assuming a cold cache, so information must first be
read from mass storage into the operating system cache then
transferred ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
... 2.2.2 Direction
The SQLite Architect shall coordinate the activities of SQLite
Developers and shall publish from time to time a roadmap of
proposed future changes and enhancements to SQLite.
2.2.3 Oversight
The SQLite Architect shall personally ...
|
|
ALTER TABLE
(lang_altertable.html)
... PRAGMA foreign_keys
PRAGMA legacy_alter_table
Parent Table
references are updated
SQLite version
OffOffNo< 3.26.0
OffOffYes>= 3.26.0
OnOffYesall
OffOnNoall
OnOnYesall
3. ALTER TABLE RENAME COLUMN
The RENAME COLUMN TO syntax changes the
column-name of table ...
|
|
NUL Characters In Strings
(nulinstr.html)
2. Unexpected Behavior
... 1,'abc',3
(Through this document, we assume that the CLI has ".mode quote" set.)
But if you run:
SELECT * FROM t1 WHERE b='abc';
Then no rows are returned. SQLite knows that the t1.b column actually
holds a ...
|
|
Datatypes In SQLite
(datatype3.html)
3.3. Column Affinity For Views And Subqueries
The "columns" of a VIEW or FROM-clause subquery are really
the expressions
in the result set of the SELECT statement that implements the VIEW
or subquery. Thus, the affinity for columns of a VIEW or subquery
are determined by ...
|
Page generated by FTS5 in about 357.86 ms.