Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The WITH Clause
(lang_with.html)
... The basic procedure above may modified by the following additional rules:
If a UNION operator connects the initial-select with the
recursive-select, then only add rows to the queue if
no identical row has
been previously added to the ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
Overview
SQLite uses dynamic memory allocation to obtain
memory for storing various objects
(ex: database connections and prepared statements) and to build
a memory cache of the database file and to hold the results of queries.
Much effort has gone ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
... SQLite stores this first "role" value in an
internal variable that we will here call "$role". Then SQLite
runs a query like: "SELECT name FROM people WHERE role=$role AND height>=180".
This query has an equality constraint on the ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... The default sorting procedure is to gather all information that will
ultimately be output into a "record" and pass that complete record
to the sorter. But in some cases, for example if some of the output
columns consists of large ...
|
|
SQLite Older News
(oldnews.html)
... And, of course, it passes our rigorous testing procedures with no
problems detected. Version 3.7.8 is recommended for all new development.
2011-06-28 - Version 3.7.7.1
SQLite version 3.7.7.1 adds a one ...
|
Page generated by FTS5 in about 28.71 ms.