C API: Introduction
(c3ref/intro.html)
C-language Interface Specification for SQLite
These pages are intended to be precise and detailed specification.
For a tutorial introduction, see instead:
SQLite In 5 Minutes Or Less and/or
the Introduction To The SQLite C/C++ Interface.
This same ...
|
C API: Dynamically Typed Value Object
(c3ref/value.html)
struct sqlite3_value
... If SQLite is compiled to be single-threaded
(with SQLITE_THREADSAFE=0 and with sqlite3_threadsafe() returning 0)
or if SQLite is run in one of reduced mutex modes
SQLITE_CONFIG_SINGLETHREAD or SQLITE_CONFIG_MULTITHREAD
then there is no distinction between protected and unprotected
sqlite3_value ...
|
Uniform Resource Identifiers
(uri.html)
3.3. Recognized Query Parameters
... SQLite always opens immutable database files
read-only and it skips all file locking and change detection
on immutable database files. If this query parameter (or
the SQLITE_IOCAP_IMMUTABLE bit in xDeviceCharacteristics)
asserts that a database file is immutable and that ...
|
C API: Name Of A Host Parameter
(c3ref/bind_parameter_name.html)
sqlite3_bind_parameter_name()
... In other words, the initial ":" or "$" or "@" or "?"
is included as part of the name.
Parameters of the form "?" without a following integer have no name
and are referred to as "nameless" or "anonymous parameters".
The first host parameter has ...
|
C API: Create and Destroy VFS Filenames
(c3ref/create_filename.html)
sqlite3_create_filename(), sqlite3_free_filename()
... None of the 2*N pointers in the P array may be
NULL pointers and key pointers should not be empty strings.
None of the D, J, or W parameters to sqlite3_create_filename(D,J,W,N,P) may
be NULL ...
|
CREATE TABLE
(lang_createtable.html)
... If the "TEMP" or "TEMPORARY"
keyword occurs between the "CREATE" and "TABLE" then the new table is
created in the temp database. It is an error to specify both a
schema-name and the TEMP or TEMPORARY keyword, unless the ...
|
Temporary Files Used By SQLite
(tempfiles.html)
2.7. Materializations Of Views And Subqueries
... Whether or not
the query can be flattened depends on such factors as whether
or not the subquery or outer query contain aggregate functions,
ORDER BY or GROUP BY clauses, LIMIT clauses, and so forth.
The rules for when a ...
|
C API: Move a BLOB Handle to a New Row
(c3ref/blob_reopen.html)
sqlite3_blob_reopen()
... If the new row is not present in the table, or if
it does not contain a blob or text value, or if another error occurs, an
SQLite error code is returned and the blob handle is considered aborted.
All ...
|
Custom Builds Of SQLite
(custombuild.html)
Custom Builds Of SQLite
or
Porting SQLite To New Operating Systems
1.0 Introduction
For most applications, the recommended method for building
SQLite is to use the amalgamation code
file, sqlite3.c, and its corresponding header file
sqlite3.h. The ...
|
Datatypes In SQLite
(datatype3.html)
5. Operators
Mathematical operators (+, -, *, /, %, <<, >>,
&, and |) interpret both operands as if they were numbers.
STRING or BLOB operands automatically convert into REAL or INTEGER values.
If the STRING or BLOB looks like a real number (if it has ...
|
Page generated by FTS5 in about 295.32 ms.