Small. Fast. Reliable.
Choose any three.
Choose any three.
|
CREATE TRIGGER
(lang_createtrigger.html)
... The INDEXED BY and NOT INDEXED clauses are not supported for UPDATE and
DELETE statements.
The ORDER BY and LIMIT clauses on UPDATE and DELETE statements are not
supported. ORDER BY and LIMIT are not normally supported for UPDATE or ...
|
|
SQLite Version 3 Overview
(version3.html)
... This is just an implementation issue and there is nothing to prevent
future versions of SQLite from parsing UTF-16 encoded SQL natively.
When creating new user-defined SQL functions and collating sequences,
each function or collating sequence can specify ...
|
|
CREATE INDEX
(lang_createindex.html)
... Descending Indexes
Each column name or expression can be followed by one
of the "ASC" or "DESC" keywords to indicate sort order.
The sort order may or may not be ignored depending
on the database file format, and in particular ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... For the INSERT and
UPDATE commands, the keywords "ON CONFLICT" are replaced by "OR" so that
the syntax reads more naturally. For example, instead of
"INSERT ON CONFLICT IGNORE" we have "INSERT OR IGNORE".
The keywords change but the meaning ...
|
|
Implementation Limits For SQLite
(limits.html)
... You can raise or lower this value at compile-time using a command-line
option like this:
-DSQLITE_MAX_LENGTH=123456789
The current implementation will only support a string or BLOB
length up to 231-1 or 2147483647. And
some built-in ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... Otherwise, the value inserted into this field is the file contents
for a regular file, or the target of a symbolic link.
method
This field must be set one of integer values 0 and 8, or else to
NULL.
For ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
6. Shared Cache And In-Memory Databases
... Enabling shared-cache for an in-memory database allows two or more
database connections in the same process to have access to the same
in-memory database. An in-memory database in shared cache is automatically
deleted and memory is ...
|
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... The
sqlite3_value_text16be() and sqlite3_value_text16le() interfaces
extract UTF-16 strings as big-endian and little-endian respectively.
If sqlite3_value object V was initialized
using sqlite3_bind_pointer(S,I,P,X,D) or sqlite3_result_pointer(C,P,X,D)
and if X and Y ...
|
|
C API: Setting The Result Of An SQL Function
(c3ref/result_blob.html)
sqlite3_result_blob(), sqlite3_result_blob64(), sqlite3_result_double(), sqlite3_result_error(), sqlite3_result_error16(), sqlite3_result_error_toobig ...
These routines are used by the xFunc or xFinal callbacks that
implement SQL functions and aggregates. See
sqlite3_create_function() and sqlite3_create_function16()
for additional information.
These functions work very much like the parameter binding family of
functions used to bind values to ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA locking_mode
... Database locks obtained by a connection in EXCLUSIVE mode may be
released either by closing the database connection, or by setting the
locking-mode back to NORMAL using this pragma and then accessing the
database file (for read or write ...
|
Page generated by FTS5 in about 569.61 ms.