Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Database File Format
(fileformat.html)
2.6. Storage Of The SQL Database Schema
... The sqlite_schema.tbl_name column holds the name of a table or view
that the object is associated with. For a table or view, the
tbl_name column is a copy of the name column. For an index, the tbl_name
is the ...
|
|
The Error And Warning Log
(errlog.html)
1. Setting Up The Error Logging Callback
... The messages do not contain
sensitive or private information that must be protected from unauthorized
viewing. Rather the messages are technical in nature and are not useful
or meaningful to the typical end user. The messages coming from the
error ...
|
|
Why SQLite Does Not Use Git
(whynotgit.html)
2.4. Git does not track historical branch names
... https://sqlite.org/src/timeline?r=prefer-coroutine-sort-subquery
The Fossil view clearly shows that the branch was eventually merged back into
trunk. It shows where the branch started, and it shows two occasions where changes
on trunk were ...
|
|
Implementation Limits For SQLite
(limits.html)
... For example, a web browser application might use an internal database
to track historical page views but have one or more separate databases
that are created and controlled by javascript applications that are
downloaded from the internet.
The sqlite3_limit() interface ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.7. Materializations Of Views And Subqueries
Queries that contain subqueries must sometime evaluate
the subqueries separately and store the results in a temporary
table, then use the content of the temporary table to evaluate
the outer query.
We call this "materializing" the subquery.
The query optimizer ...
|
|
Recent SQLite News
(news.html)
... The
3.25.2 release also contains a fix to window function processing for
VIEWs. There also a slew of other minor fixes that affect obscure
compile-time options. See the
Fossil Timeline for
details.
2018-09-18 - Release 3 ...
|
|
RETURNING
(lang_returning.html)
... PostgreSQL has the ability
to use a DML statement with a RETURNING clause like a view in a
common table expressions. SQLite does not currently have that
ability, though that is something that might be added in a future release ...
|
|
Measuring and Reducing CPU Usage in SQLite
(cpu.html)
3. Performance Measurement Workflow
... The cg_anno.tcl script removes extraneous details from the default
cachegrind annotation
output so that before-and-after reports can be compared using a
side-by-side diff to view specific details of how a
micro-optimization attempt affected performance.
|
|
How SQLite Works
(howitworks.html)
3. Further Reading
... The bytecode engine document has more information
on the bytecode format used by SQLite, and how to view and interpret
an SQLite prepared statement.
The SQLite query planner and
Next Generation Query Planner documents have further details
on the algorithms ...
|
|
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 ...
|
Page generated by FTS5 in about 131.09 ms.