Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Copyright
(copyright.html)
... Open-Source, not Open-Contribution
SQLite is open-source, meaning that you can make as many copies of it as
you want and do whatever you want with those copies, without limitation.
But SQLite is not open-contribution. In order ...
|
|
The CSV Virtual Table
(csv.html)
1. Overview
... One can use the CSV virtual table inside subqueries,
or common table expressions or add WHERE, GROUP BY, HAVING, ORDER BY,
and LIMIT clauses as required.
|
|
pressrelease-20071212.html
(pressrelease-20071212.html)
... jwaight@outcastpr.com
About Symbian Limited
Symbian is a software licensing company that develops and licenses Symbian OS,
the market-leading open operating system for advanced, data-enabled mobile phones
known as smartphones.
Symbian licenses Symbian OS to the world ...
|
|
The RBU Extension
(rbu.html)
3.1. RBU Vacuum Limitations
When compared with SQLite's built-in VACUUM command, RBU Vacuum has the
following limitations:
It may not be used on a database that contains indexes on expressions.
The database being vacuumed may not be in WAL mode.
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1.3. Subqueries
... sqlite> SELECT * FROM
> (SELECT * FROM t1 WHERE a=1 ORDER BY b LIMIT 2) AS x,
> (SELECT * FROM t2 WHERE c=1 ORDER BY d LIMIT 2) AS y;
QUERY PLAN
|--MATERIALIZE x
| `--SEARCH t1 USING COVERING ...
|
|
Generated Columns
(gencol.html)
2.3. Limitations
Generated columns may not have a default value (they may not use the
"DEFAULT" clause). The value of a generated column is always the value
specified by the expression that follows the "AS" keyword.
Generated columns may not be used ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
7. Configuring SQLite
... After process-wide configuration is complete and database connections
have been created, individual database connections can be configured using
calls to sqlite3_limit() and sqlite3_db_config().
|
|
SQLite Foreign Key Support
(foreignkeys.html)
6. Limits and Unsupported Features
This section lists a few limitations and omitted features that are not
mentioned elsewhere.
No support for the MATCH clause. According to SQL92, a MATCH clause
may be attached to a composite foreign key definition to modify the way
NULL ...
|
|
UPSERT
(lang_upsert.html)
... clause:
INSERT INTO t1 SELECT * FROM t2 WHERE true
ON CONFLICT(x) DO UPDATE SET y=excluded.y;
3. Limitations
UPSERT does not currently work for virtual tables.
The conflict resolution algorithm for the update operation
of the DO UPDATE ...
|
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
2.2. Truncating A Database
... The following are some specific
limitations of null-INSERT:
The sqlite_dbpage table does not allow a null-INSERT into page 1.
Hence, it is not possible to truncate a database to zero bytes or
zero pages using sqlite_dbpage, as doing ...
|
Page generated by FTS5 in about 228.51 ms.