Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Compiling An SQL Statement
(c3ref/prepare.html)
sqlite3_prepare(), sqlite3_prepare_v2(), sqlite3_prepare_v3(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_prepare16_v3()
... If there is an error, *ppStmt is set
to NULL. If the input text contains no SQL (if the input is an empty
string or a comment) then *ppStmt is set to NULL.
The calling procedure is responsible for deleting ...
|
|
Datatypes In SQLite
(datatype3.html)
... Example Typenames From TheCREATE TABLE Statement
or CAST Expression
Resulting Affinity
Rule Used To Determine Affinity
INT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
BIGINT
UNSIGNED BIG INT
INT2
INT8
INTEGER
1
CHARACTER(20)
VARCHAR(255)
VARYING CHARACTER(255)
NCHAR(55)
NATIVE CHARACTER ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
5. The LIKE Optimization
... If the ESCAPE option is used, the ESCAPE character must be ASCII,
or a single-byte character in UTF-8.
The LIKE operator has two modes that can be set by a
pragma. The
default mode is for LIKE comparisons ...
|
|
The WITH Clause
(lang_with.html)
... An entry in x(s,ind) means that the 81-character string "s" is a valid
sudoku puzzle (it has no conflicts) and that the first unknown character
is at position "ind", or ind==0 if all character positions are ...
|
|
Implementation Limits For SQLite
(limits.html)
... The default settings
for limits are normally quite large and adequate for almost every
application. Some applications may want to increase a limit here
or there, but we expect such needs to be rare. More commonly,
an application might want ...
|
|
JSON Functions And Operators
(json1.html)
... Within JSON value arguments interpreted as JSON strings, Unicode escape
sequences are not treated as equivalent to the characters or escaped
control characters represented by the expressed Unicode code point.
Such escape sequences are not translated or specially treated; they ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.3. Shared-Memory Files
... The shared-memory file, if it exists, is located
in the same directory as the database file and has the same name as the
database file except with the 4 characters "-shm" appended.
Shared memory files only exist while running ...
|
|
C API: Create Or Redefine SQL Functions
(c3ref/create_function.html)
sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()
... Note that the name
length limit is in UTF-8 bytes, not characters nor UTF-16 bytes.
Any attempt to create a function with a longer name
will result in SQLITE_MISUSE being returned.
The third parameter (nArg)
is the number ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... Otherwise, if it is set to 0, then the file data or symbolic link
target is stored as is in the zip archive and the compression method
set to 0. If it is set to 8, then the file data ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
... An optional parameter
is specified using its name, followed by an "=" character, followed by an
optionally quoted value. Whitespace may separate the name, "=" character
and value. For example:
CREATE VIRTUAL TABLE temp.sv USING swarmvtab (
'SELECT ...', -- the SELECT statement
maxopen ...
|
Page generated by FTS5 in about 56.06 ms.