Small. Fast. Reliable.
Choose any three.
Choose any three.
|
STRICT Tables
(stricttables.html)
3. The ANY datatype
... As far as we know, SQLite is the only SQL database engine
that supports this advanced capability.
The behavior of ANY is slightly different in a
STRICT table versus an ordinary non-strict table. In a STRICT table,
a column ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
3.3. The datatype is optional
Because SQLite is flexible and forgiving with regard to datatypes,
table columns can be created that have no specified datatype at all.
For example:
CREATE TABLE t1(a,b,c,d);
The table "t1" has four columns "a", "b", "c ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3.3. Return Value
The xBestIndex method should return SQLITE_OK on success. If any
kind of fatal error occurs, an appropriate error code (ex: SQLITE_NOMEM)
should be returned instead.
If xBestIndex returns SQLITE_CONSTRAINT, that does not indicate an
error. Rather, SQLITE_CONSTRAINT indicates that the ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.3. Querying An R*Tree Index
... SELECT * FROM demo_index WHERE id=28269;
Of course, an ordinary SQLite table will also do a query against its
integer primary key efficiently, so the previous is not important.
The big reason for using an R*Tree is so that ...
|
|
Uniform Resource Identifiers
(uri.html)
3.3. Recognized Query Parameters
... All query parameters
are always passed through into the xOpen method of the VFS even if
they are previously read and interpreted by the SQLite core.
The following query parameters are recognized by SQLite as of
version 3.15.0 ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.3. Updating Existing Zip Archive Entries
Existing zip archive entries may be modified using UPDATE statements.
The three leftmost columns of a zipfile virtual table, "name", "mode"
and "mtime", may each be set to any value that may be inserted into the same
column (see above ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
... Compiling and Using Swarmvtab
The code for the swarmvtab virtual table is found in the
ext/misc/unionvtab.c file of the main SQLite source tree. It may be compiled
into an SQLite loadable extension using a command like:
gcc ...
|
|
Database File Format
(fileformat.html)
1.3.3. File format version numbers
The file format write version and file format read version at offsets
18 and 19 are intended to allow for enhancements of the file format
in future versions of SQLite. In current versions of SQLite, both of
these values are ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3. Cases Where Flexible Typing Is Useful
Some readers, upon first encountering flexible typing in SQLite, ask
themselves "how could this ever be useful?" Here is an
attempt to answer that question:
|
|
The Percentile Extension
(percentile.html)
3.3. The percentile_cont(Y,P) aggregate function
... SELECT percentile_cont(Y,P) FROM tab;
SQLite will support the SQL-standard syntax, but only if it is compiled
(from canonical sources, not from the amalgamation) using the
-DSQLITE_ENABLE_ORDERED_SET_AGGREGATES=1 compile-time option. Without that
compile-time option, only the ...
|
Page generated by FTS5 in about 363.99 ms.