Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Database File Format
(fileformat.html)
2.6.7. The sqlite_stat4 table
... The sqlite_stat4.sample BLOB for the WITHOUT ROWID table itself
contains just the columns of the primary key.
Let the number of columns encoded by the sqlite_stat4.sample blob be N.
For indexes on an ordinary rowid table, N will ...
|
|
SQLite FTS5 Extension
(fts5.html)
6.10. The 'pgsz' Configuration Option
... The full-text index maintained by FTS5 is stored as a series of fixed-size
blobs in a database table. It is not strictly necessary for all blobs that make
up a full-text index to be the same size ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... The data can be a complex mix of large binary blobs, text, and small
numeric or boolean values. The data format can be easily extended
by adding new tables and/or columns, without breaking legacy receivers.
The SQL query language ...
|
|
The SQLite R*Tree Module
(rtree.html)
4.1. Auxiliary Columns
... CREATE VIRTUAL TABLE demo_index2 USING rtree(
id, -- Integer primary key
minX, maxX, -- Minimum and maximum X coordinate
minY, maxY, -- Minimum and maximum Y coordinate
+objname TEXT, -- name of the object
+objtype TEXT, -- object type
+boundary BLOB -- detailed boundary of object ...
|
|
SQLite Older News
(oldnews.html)
... The new limits might
causes compatibility problems for existing applications that
use excessively large strings, BLOBs, tables, or SQL statements.
The new limits can be increased at compile-time to work around any problems
that arise. Nevertheless, the version number ...
|
|
Recent SQLite News
(news.html)
... The most impactful change is likely enhancements to
the JSON SQL functions such that they are now able to
store their internal JSON parse trees in the database
as BLOB values. This can significantly increase the
performance of applications that ...
|
|
How SQLite Is Tested
(testing.html)
4.1.3. The dbsqlfuzz and jfuzz fuzzers
... Jfuzz generates corrupt JSONB blobs and feeds
them into the JSON SQL functions to verify that the JSON functions
are able to safely and efficiently deal with corrupt binary inputs.
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
5. The LIKE Optimization
... It must not be possible to make the LIKE or GLOB operator true by
having a numeric value (instead of a string or blob) on the
left-hand side. This means that either:
the left-hand side of the LIKE ...
|
Page generated by FTS5 in about 103.23 ms.