Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Session Module C/C++ Interface
(session.html)
... For each table that is not excluded by the filter callback, this function
tests that the target database contains a compatible table. A table is
considered compatible if all of the following are true:
The table has the same name ...
|
|
Window Functions
(windowfunctions.html)
6. History
... Many test cases have been run against PostgreSQL
to ensure that window functions operate the same way in both
SQLite and PostgreSQL.
In SQLite version 3.28.0 (2019-04-16),
windows function support was extended to include the EXCLUDE ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... Though this
feature was originally intended for testing and debugging, it can also
be useful in learning about how the VDBE operates.
Use "PRAGMA vdbe_trace=ON;" to turn tracing on and
"PRAGMA vdbe_trace=OFF" to turn tracing back ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3. The xBestIndex Method
... False for ASC. */
} *const aOrderBy; /* The ORDER BY clause */
/* Outputs */
struct sqlite3_index_constraint_usage {
int argvIndex; /* if >0, constraint is part of argv to xFilter */
unsigned char omit; /* Do not code a test for this constraint */
} *const aConstraintUsage;
int idxNum; /* Number used ...
|
|
SQLite FTS5 Extension
(fts5.html)
4.6. The Detail Option
... In one test that indexed a large set of emails (1636 MiB on disk), the FTS
index was 743 MiB on disk with detail=full, 340 MiB with detail=column and 134
MiB with detail=none.
|
Page generated by FTS5 in about 129.61 ms.