Small. Fast. Reliable.
Choose any three.

Search results 71..76 of 76 for: blob

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 ... 
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.
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 ... 

12345678

Page generated by FTS5 in about 58.93 ms.