Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS5 Extension
(fts5.html)
3.7. FTS5 Boolean Operators
Phrases and NEAR groups may be arranged into expressions using boolean
operators. In order of precedence, from highest (tightest grouping) to
lowest (loosest grouping), the operators are:
Operator Function
<query1> NOT <query2>
Matches if query1 matches ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... For example, SQLite allows the application to store
a large BLOB in a column with a declared type of BOOLEAN. But in a few
cases, SQLite is strict about types. The SQLITE_MISMATCH error is
returned in those few cases when ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SQLITE_OMIT_FLAG_PRAGMAS
This option omits support for a subset of PRAGMA commands that
query and set boolean properties.
SQLITE_OMIT_FLOATING_POINT
This option is used to omit floating-point number support from the SQLite
library. When specified, specifying a floating point number as ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
6. Checklist For Avoiding Or Fixing Query Planner Problems
... In particular, avoid using
boolean or "enum" columns as the left-most columns of your indexes.
The Fossil performance problem described in the previous section of
this document arose because there were over
ten-thousand entries in the TAGXREF table ...
|
|
JSON Functions And Operators
(json1.html)
4.8. The jsonb_extract() function
... For the common case where a text, numeric, null, or
boolean JSON element is returned, this routine works exactly the same
as json_extract().
|
|
The sqlite3_analyzer.exe Utility Program
(sqlanalyze.html)
1.2. Example Output
... The data used to generate this report follows:
*/
BEGIN;
CREATE TABLE space_used(
name clob, -- Name of a table or index in the database file
tblname clob, -- Name of associated table
is_index boolean, -- TRUE if it is an index, false for ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
4.3. The Matchinfo Function
... Instead of the precise number of hits, 'b' provides a single
boolean flag for each phrase/column combination. If the phrase is present in
the column at least once (i.e. if the corresponding integer output of 'y' would
be ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... Array of boolean - true for PK cols */
int *pnCol /* OUT: Number of entries in output array */
);
For each modified table, a changeset includes the following:
The number of columns in the table, and
Which of those columns make up the ...
|
|
Database File Format
(fileformat.html)
1.3.10. Schema format number
... Format 4 causes SQLite to respect the
DESC keyword on
index declarations. (The DESC keyword is ignored in indexes for
formats 1, 2, and 3.)
Format 4 also adds two new boolean record type values (serial types
8 and 9 ...
|
|
SQLite Older News
(oldnews.html)
... The file format for version 3.3.0 has changed slightly to support
descending indices and
a more efficient encoding of boolean values. SQLite 3.3.0 will read and
write legacy databases created with any prior version of SQLite ...
|
Page generated by FTS5 in about 82.92 ms.