Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Datatypes In SQLite version 2
(datatypes.html)
... by the fact that a column might have a "numeric"
datatype. This does not mean that the column can contain only numbers.
It merely means that if the column does contain a number, that number
will sort in numerical order ...
|
|
INSERT
(lang_insert.html)
... Any SELECT statement, including
compound SELECTs and SELECT statements with ORDER BY and/or LIMIT clauses,
may be used in an INSERT statement of this form.
To avoid a parsing ambiguity, the SELECT statement should always
contain a WHERE clause ...
|
|
C API: Evaluate An SQL Statement
(c3ref/step.html)
... More information may be found by calling sqlite3_errmsg().
With the legacy interface, a more specific error code (for example,
SQLITE_INTERRUPT, SQLITE_SCHEMA, SQLITE_CORRUPT, and so forth)
can be obtained by calling sqlite3_reset() on the
prepared statement. In the "v2" interface,
the ...
|
|
The UNION Virtual Table
(unionvtab.html)
... If the results of query change, then
the union-vtab should be DROP-ed and recreated in order
to cause the query to be run again.
There must be no overlap in the bands of rowids for the various tables ...
|
|
SQLite Keywords
(lang_keywords.html)
... So to prevent your code from being broken by future enhancements, you should
normally quote any identifier that is an English language word, even if
you do not have to.
The list below shows all possible keywords used by any ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... SQLITE_DBCONFIG_TRIGGER_EQP
By default, the output of EXPLAIN QUERY PLAN commands does not
include output for any operations performed by trigger programs. This
option is used to set or clear (the default) a flag that governs this
behavior. The first parameter ...
|
|
Uniform Resource Identifiers
(uri.html)
2. Backwards Compatibility
In order to maintain full backwards compatibility for legacy applications,
the URI filename capability is disabled by default.
URI filenames can be enabled or disabled using the SQLITE_USE_URI=1
or SQLITE_USE_URI=0 compile-time options.
The compile-time setting for ...
|
|
C API: OS Interface File Virtual Methods Object
(c3ref/io_methods.html)
struct sqlite3_io_methods
Every file opened by the sqlite3_vfs.xOpen method populates an
sqlite3_file object (or, more commonly, a subclass of the
sqlite3_file object) with a pointer to an instance of this object.
This object defines the methods used to perform various operations ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... Changes within a patchset are ordered in the same way as for changesets
generated by the sqlite3session_changeset() function (i.e. all changes for
a single table are grouped together, tables appear in the order in which
they were attached to ...
|
|
In-Memory Databases
(inmemorydb.html)
... in order for the special ":memory:" name to apply and to
create a pure in-memory database, there must be no additional text in the
filename. Thus, a disk-based database can be created in a file by prepending
a ...
|
Page generated by FTS5 in about 236.23 ms.