Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.13. The xUpdate Method
... The value of argc will be 1 for a pure delete operation or N+2 for an insert
or replace or update where N is the number of columns in the table.
In the previous sentence, N includes any hidden ...
|
|
SQLite Older News
(oldnews.html)
... Upgrading from version 3.7.6.3, 3.7.7, 3.7.7.1, 3.7.8, or 3.7.9 is
optional. Upgrading from other releases is recommended.
The SQLITE_CONFIG_PCACHE mechanism has been replaced with
SQLITE_CONFIG_PCACHE2. If you do ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... CREATE and DROP
Using CREATE or DROP to create or destroy a table or index is
really the same as doing an INSERT or DELETE from the special
"sqlite_master" table, at least from the point of view of the VDBE ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
... 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 ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
... Memory allocator overlays
An application can insert layers or "overlays" in between the
SQLite core and the underlying memory allocator.
For example, the out-of-memory test logic
for SQLite uses an overlay that can simulate memory allocation
failures.
An ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SELECT statements that use the
UNION, UNION ALL, INTERSECT or EXCEPT compound SELECT operators will
cause a parse error.
An INSERT statement with multiple values in the VALUES clause is
implemented internally as a compound SELECT. Hence, this option also ...
|
|
Query Planning
(queryplanner.html)
... SELECT price FROM FruitsForSale WHERE fruit='Orange' OR state='CA';
When confronted with OR-connected terms in a WHERE clause, SQLite
examines each OR term separately and tries to use an index to
find the rowids associated with each term ...
|
|
Database File Format
(fileformat.html)
... Pointer Map or Ptrmap Pages
Pointer map or ptrmap pages are extra pages inserted into the database
to make the operation of auto_vacuum and incremental_vacuum modes
more efficient. Other page types in the database typically have pointers
from parent to ...
|
|
Recent SQLite News
(news.html)
... start-time setting, or the
sqlite3_db_config(SQLITE_DBCONFIG_LOOKASIDE)
run-time setting.
2017-01-06 - Release 3.16.2
One of the performance optimizations added in 3.16.0 caused triggers
and foreign keys to malfunction for the REPLACE statement on
WITHOUT ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
... INSERT statements and discover where in the
database file the new information should be stored.
The first step toward reading from the database file
is obtaining a shared lock on the database file. A "shared"
lock allows two or more ...
|
Page generated by FTS5 in about 91.93 ms.