Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 Pro Support
(prosupport.html)
... The
SQLite Encryption
Extension (SEE),
the ZIPVFS Extension,
and the Compressed and
Encrypted ReadOnly Database (CEROD) extension are enhanced versions
of SQLite that handle encrypted
and/or compressed databases. SEE can read and write encrypted databases.
SEE encrypts all database ...
|
|
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 ...
|
|
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 ...
|
|
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: Memory Allocation Subsystem
(c3ref/free.html)
sqlite3_malloc(), sqlite3_malloc64(), sqlite3_realloc(), sqlite3_realloc64(), sqlite3_free(), sqlite3_msize()
... The pointer arguments to sqlite3_free() and sqlite3_realloc()
must be either NULL or else pointers obtained from a prior
invocation of sqlite3_malloc() or sqlite3_realloc() that have
not yet been released.
The application must not read or write any part of
a ...
|
Page generated by FTS5 in about 280.46 ms.