SQLite Is Transactional
(transactional.html)
... SQLite implements
serializable
transactions that are atomic, consistent, isolated, and durable,
even if the transaction is interrupted by a program crash, an
operating system crash, or a power failure to the computer.
We here restate and amplify the previous sentence ...
|
C API: Function Flags
(c3ref/c_deterministic.html)
SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_SUBTYPE, SQLITE_INNOCUOUS, SQLITE_RESULT_SUBTYPE
... SQLITE_DIRECTONLY
The SQLITE_DIRECTONLY flag means that the function may only be invoked
from top-level SQL, and cannot be used in VIEWs or TRIGGERs nor in
schema structures such as CHECK constraints, DEFAULT clauses,
expression indexes, partial indexes, or generated ...
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... The
extension can add new functions or collating sequences, but cannot
modify or delete existing functions or collating sequences because
those functions and/or collating sequences might be used elsewhere
in the currently running SQL statement. To load an extension ...
|
Generated Columns
(gencol.html)
2. Syntax
... The "GENERATED ALWAYS" keywords at the beginning of the constraint
and the "VIRTUAL" or "STORED" keyword at the end are all optional.
Only the "AS" keyword and the parenthesized expression are required.
If the trailing "VIRTUAL" or "STORED" keyword is ...
|
SQLite's Built-in printf()
(printf.html)
2.5. The Options Flags Field
Flags consist of zero or more characters that immediately follow the
"%" that introduces the substitution. The various flags and their meanings
are as follows:
Flag
Meaning
-
Left-justify the value in the output. The default is to right-justify.
If ...
|
Command Line Shell For SQLite
(cli.html)
23.3. The --no-utf8 and --utf8 command-line options
On the Windows platform, when the console is used for input or output,
translation is required between character encoding available from or sent to
the console and the CLI's internal, UTF-8 text representation. Past versions
of the CLI ...
|
Compile-time Options
(compile.html)
12. Compiler Linkage and Calling Convention Control
... This
macro is used on varargs routines and so cannot be set to "__stdcall"
since the __stdcall calling convention does not support varargs functions.
A single function declaration should contain no more than one of
the following: SQLITE_APICALL, SQLITE_CDECL, or ...
|
The Next-Generation Query Planner
(queryplanner-ng.html)
3.4. The N Nearest Neighbors or "N3" Heuristic
... In the
case where two or more paths are equivalent (they have the same set of
visited nodes, though possibly in a different order) only the
first and lowest-cost path is retained. We have:
R-N1 (cost: 7.03 ...
|
C API: SQL Trace Hook
(c3ref/trace_v2.html)
sqlite3_trace_v2()
The sqlite3_trace_v2(D,M,X,P) interface registers a trace callback
function X against database connection D, using property mask M
and context pointer P. If the X callback is
NULL or if the M mask is zero, then tracing ...
|
SQLite Is Serverless
(serverless.html)
2. Classic Serverless Vs. Neo-Serverless
... With SQLite, there are no other processes, threads, machines, or
other mechanisms (apart from host computer OS and filesystem)
to help provide database services or implementation. There really
is no server.
Microsoft Azure Cosmo DB
and
Amazon S3
are examples ...
|
Page generated by FTS5 in about 294.10 ms.