Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Identify and handle IN constraints in xBestIndex
(c3ref/vtab_in.html)
sqlite3_vtab_in()
... All-at-once processing of the IN operator is selected if both of the
following conditions are met:
The P->aConstraintUsage[N].argvIndex value is set to a positive
integer. This is how the virtual table tells SQLite that it ...
|
|
RETURNING
(lang_returning.html)
... These expressions are similar to the expressions following
the SELECT keyword in a SELECT statement in that they
define the values of the columns in the result set. Each expression
defines the value for a single column. Each expression may ...
|
|
The Percentile Extension
(percentile.html)
3.3. The percentile_cont(Y,P) aggregate function
... P)", the
SQL-standard syntax goes like this:
SELECT percentile_cont(P) WITHIN GROUP (ORDER BY Y) FROM tab;
That is a lot of syntax to mean exactly the same thing as:
SELECT percentile_cont(Y,P) FROM tab;
SQLite will support ...
|
|
STRICT Tables
(stricttables.html)
3. The ANY datatype
... STRICTordinary non-strict
CREATE TABLE t1(a ANY) STRICT;
INSERT INTO t1 VALUES('000123');
SELECT typeof(a), quote(a) FROM t1;
-- result: text '000123'
CREATE TABLE t1(a ANY);
INSERT INTO t1 VALUES('000123');
SELECT typeof(a), quote(a) FROM ...
|
|
The UNION Virtual Table
(unionvtab.html)
... The query for the CREATE VIRTUAL TABLE statement of a union-vtab
can be either a SELECT statement or a VALUES clause.
The query is run once when the CREATE VIRTUAL TABLE statement is
first encountered and the results of ...
|
|
SQLite Keywords
(lang_keywords.html)
... PRECEDING
PRIMARY
QUERY
RAISE
RANGE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RELEASE
RENAME
REPLACE
RESTRICT
RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER
UNBOUNDED
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE ...
|
|
C API: Mutexes
(c3ref/mutex_alloc.html)
sqlite3_mutex_alloc(), sqlite3_mutex_free(), sqlite3_mutex_enter(), sqlite3_mutex_try(), sqlite3_mutex_leave()
... An appropriate implementation
is selected automatically at compile-time. The following
implementations are available in the SQLite core:
SQLITE_MUTEX_PTHREADS
SQLITE_MUTEX_W32
SQLITE_MUTEX_NOOP
The SQLITE_MUTEX_NOOP implementation is a set of routines
that does no real locking and is appropriate for use in ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... Instead, whenever
the user selects "File/Save", the entire ZIP archive is rewritten.
Hence, "File/Save" takes longer than it ought, especially on
older hardware. Newer machines are faster, but it is still bothersome
that changing a single character in ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... are not supported
directly by statements inside of triggers but may be embedded within
sub-selects used by statements inside of triggers.
3. INSTEAD OF triggers
BEFORE and AFTER triggers work only on ordinary tables.
INSTEAD OF triggers work only ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
3. Checklist For Choosing The Right Database Engine
... Hence, it is usually better to select a client/server
database engine when the data is on a separate device from the
application.
Nota Bene:
In this rule, "application" means the code that issues SQL statements.
If the "application" is ...
|
Page generated by FTS5 in about 159.08 ms.