Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Isolation In SQLite
(isolation.html)
... In other words, if X begins a write transaction using BEGIN IMMEDIATE
then issues one or more UPDATE, DELETE, and/or INSERT
statements, then those changes are visible to subsequent SELECT statements
that are evaluated in database connection X. SELECT ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... It is especially difficult to update individual entries in a ZIP
archive in a way that does not destroy
the entire document if the computer loses power and/or crashes
in the middle of the update. It is not impossible ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
4. VFS Implementations
... the operating system, such
as checking for existence of files, deleting files, creating files
and opening and for reading and/or writing, converting filenames
into their canonical form. The sqlite3_vfs object also contains
methods for obtaining randomness from the operating ...
|
|
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 ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... Some SQLITE_OMIT_* options might cause SQLite to malfunction
and/or provide incorrect answers.
Important Note:
The SQLITE_OMIT_* compile-time options are mostly unsupported.
The following are the available OMIT options:
SQLITE_OMIT_ALTERTABLE
When this option is defined, the
ALTER TABLE command ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.16. The changes method
The "changes" method returns an integer which is the number of rows
in the database that were inserted, deleted, and/or modified by the most
recent "eval" method.
|
|
SQL Language Expressions
(lang_expr.html)
... Input text that looks like floating point (there is a decimal point and/or
an exponent) and the text describes a value that
can be losslessly converted back and forth between IEEE 754 64-bit float and a
51-bit ...
|
|
ALTER TABLE
(lang_altertable.html)
... Carefully test this entire procedure
on a separate test database prior to using it on
a database containing important data and/or make backup copies of
important databases prior to running this procedure.
Increment the schema version number using
PRAGMA ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.6. The xOpen Method
int (*xOpen)(sqlite3_vtab *pVTab, sqlite3_vtab_cursor **ppCursor);
The xOpen method creates a new cursor used for accessing (read and/or
writing) a virtual table. A successful invocation of this method
will allocate the memory for the sqlite3_vtab_cursor (or a subclass),
initialize ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... The set of anytime configuration options can change (by insertions
and/or deletions) from one release of SQLite to the next.
As of SQLite version 3.42.0, the complete set of anytime configuration
options is:
SQLITE_CONFIG_LOG
SQLITE_CONFIG_PCACHE_HDRSZ
New configuration ...
|
Page generated by FTS5 in about 180.52 ms.