Small. Fast. Reliable.
Choose any three.
Choose any three.
|
TH3
(th3.html)
5. Mutation Testing
... Nevertheless, the mutation-test.tcl script includes
command-line options to limit the range of code lines tested so that
mutation testing only needs to be performed on blocks of code that
have recently changed.
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... CREATE TABLE t1(a);
CREATE TABLE t2(x);
SELECT * FROM (SELECT t1.a FROM t1 JOIN t2 ORDER BY t2.x LIMIT 1) ORDER BY 1;
In version 3.5.9 the query above would return a single column named ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3.1. Inputs
The main thing that the SQLite core is trying to communicate to
the virtual table is the constraints that are available to limit
the number of rows that need to be searched. The aConstraint[] array
contains one entry for each ...
|
|
The Use Of assert() In SQLite
(assert.html)
2. Examples
... At https://sqlite.org/src/artifact/18a53540aa3?ln=5512-5516
we have a test for two pre-conditions that are true only because
of the limited scope of use of the sqlite3BtreeRowCountEst() function.
Future enhancements to SQLite might use sqlite3BtreeRowCountEst ...
|
|
The SQLite R*Tree Module
(rtree.html)
4.1.1. Limitations
For auxiliary columns, only the name of the column matters.
The type affinity is ignored.
Constraints such as NOT NULL, UNIQUE, REFERENCES, or CHECK
are also ignored. However, future versions
of SQLite might start paying attention to the type affinity ...
|
|
SQLite Archive Files
(sqlar.html)
2. Advantages Of SQLite Archives
... ZIP Archives and Tarballs are limited to storing only files. An
SQLite Archive stores files plus whatever other tabular
and/or relational data seems useful to the application.
An SQLite Archive is transactional.
Updates are atomic and durable, even if ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
4. Algorithm
... To limit
the search space, X is converted to a k2-like key using the
equivalent of:
key = spellfix1_phonehash(lower(spellfix1_translit(X)))
This key is then limited to "scope" characters. The default scope
value is 4, but an alternative scope ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... This maximum length can be changed at compile-time
using the SQLITE_MAX_LENGTH compile-time option, or at run-time using
the sqlite3_limit(db,SQLITE_LIMIT_LENGTH,...) interface. The
SQLITE_TOOBIG error results when SQLite encounters a string or BLOB
that exceeds the compile ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... Application Interface
After a sequence of changes that define a single undo/redo step,
invoke the undo::barrier command to define the limit of that step.
In an interactive program, you can call undo::event after any change
and undo ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
4. Other Temporary File Optimizations
... Each temporary file gets its own private page cache with its
own SQLITE_DEFAULT_TEMP_CACHE_SIZE page limit.
|
Page generated by FTS5 in about 131.57 ms.