Appropriate Uses For SQLite
(whentouse.html)
... 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 58.93 ms.