Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Imposter Tables
(imposter.html)
2.2. Transient Imposter Tables
Another (safer) approach to creating an imposter table is to add an
entry for the imposter table to SQLite's internal symbol table without
updating the "sqlite_schema" table on disk.
That way, the imposter table exists in only a single ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA count_changes
... Normally, when the
count-changes flag is not set, INSERT, UPDATE and DELETE statements
return no data. When count-changes is set, each of these commands
returns a single row of data consisting of one integer value - the
number of ...
|
|
Measuring and Reducing CPU Usage in SQLite
(cpu.html)
2.2. Workload
... The speedtest1.c program is updated from time to time as the SQLite
developers' understanding of what constitutes "typical" usage evolves.
The
speed-check.sh shell
script, also in the canonical source tree, is used to run the speedtest1.c ...
|
|
SQLite Older News
(oldnews.html)
... The primary reason for this bug-fix release is to address a problem with
updating the value of fields at the end of a table that were added
using ALTER TABLE ADD COLUMN. This problem
1 first appeared in the ...
|
|
How SQLite Works
(howitworks.html)
2.2. Compiling SQLite Programs
... A language keyword like "SELECT" or "UPDATE".
An identifier for a table or column or variable.
Punctuation characters like "," or "==" or ";".
Literal values: numeric or string constants.
Whitespace or comments.
Whitespace and comment tokens are discarded. All other tokens
are ...
|
|
Partial Indexes
(partialindex.html)
2. Creating Partial Indexes
... And changes to the original
purchaseorder table will run faster since the po_parent index only needs
to be updated for those exceptional rows where parent_po is not NULL.
But the index is still useful for querying. In particular, if one ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
2. Using The Geopoly Extension
... INSERT INTO newtab(_shape) VALUES('[[0,0],[1,0],[0.5,1],[0,0]]');
UPDATE and DELETE statements work similarly.
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
1. SQLite Shared-Cache Mode
... Those restrictions were
dropped in 3.5.0 update. This document describes shared-cache mode
as of version 3.5.0.
Shared-cache mode changes the semantics
of the locking model in some cases. The details are described by
this ...
|
|
Command Line Shell For SQLite
(cli.html)
14.4. SQLite Archive Insert And Update Commands
The --update and --insert commands work like --create command, except that
they do not delete the current archive before commencing. New versions of
files silently replace existing files with the same names, but otherwise
the initial contents of the archive ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... changes()
The changes() function returns the number of database rows that were changed
or inserted or deleted by the most recently completed INSERT, DELETE,
or UPDATE statement, exclusive of statements in lower-level triggers.
The changes() SQL function is a ...
|
Page generated by FTS5 in about 139.19 ms.