Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
4.2. Shadow Tables
... Then the geoploy_overlap() and/or geopoly_within() routines further
refine the search to the exact answer.
This page last modified on 2023-12-05 14:43:20 UTC
|
|
CREATE TABLE
(lang_createtable.html)
... If the default value of a column is CURRENT_TIME, CURRENT_DATE or
CURRENT_TIMESTAMP, then the value used in the new row is a text
representation of the current UTC date and/or time. For CURRENT_TIME, the
format of the value is ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
18. The Constant Propagation Optimization
... might use the transitive property
of equality to construct new "virtual" constraints that can be used to
simplify expressions and/or improve performance. This is called the
"constant-propagation optimization".
For example, consider the following schema and query:
CREATE TABLE ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
4.2. Ductile failure
... And it is usually the
case that the memsys5 memory allocator will continue to function
without fragmentation even if M and/or n exceeds the limits
imposed by the Robson proof. The Robson proof shows that it is
possible for ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
2.1. Query Planning In SQLite
SQLite computes joins using nested loops,
one loop for each table
in the join. (Additional loops might be inserted for IN
and OR operators in the WHERE clause. SQLite considers those too,
but for simplicity we will ignore them in ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
1. Introduction
... So it is impossible to truly write many different sectors of a
database file simultaneously and/or instantaneously.
But the atomic commit logic within
SQLite makes it appear as if the changes for a transaction
are all written instantaneously and ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
9. The editdist3 COST table
... To disable the default insertion, deletion, and/or substitution
set their respective cost to 10000 or more.
Other entries in the cost table specific transforms for particular
characters.
The cost of specific transforms should be less than the default costs ...
|
|
The RBU Extension
(rbu.html)
1. The RBU Extension
... RBU runs incrementally
RBU operations may be suspended and then later resumed, perhaps with
intervening power outages and/or system resets. For an RBU update, the
original database content remains visible to all database readers until
the entire update has ...
|
|
The WITH Clause
(lang_with.html)
... The recursive-select is allowed to include an
ORDER BY, LIMIT, and/or OFFSET but may not use
aggregate functions or window functions.
The ability for the recursive-select to be a compound
was added in version 3.34.0 ...
|
|
SQLite Older News
(oldnews.html)
... This release fixes two obscure bugs that can result in incorrect
query results and/or application crashes, but not (as far as we can
tell) security vulnerabilities. Both bugs have been latent in the
code across multiple prior releases and ...
|
Page generated by FTS5 in about 157.93 ms.