Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
8.1. Custom (Application Defined) Tokenizers
... Instead, the pointer must
be encoded as an SQL blob value and passed to FTS through the SQL
engine by evaluating a special scalar function, "fts3_tokenizer()".
The fts3_tokenizer() function may be called with one or two arguments,
as follows:
SELECT ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... For example, many enterprise database
engines advise against storing large strings or BLOBs in the database
and instead suggest that large strings and BLOBs be stored as separate
files and the filename stored in the database. But SQLite
is not ...
|
|
The RBU Extension
(rbu.html)
2.2.2. RBU Database Contents
... In the "fossil delta" format - the format used for blob deltas by the
Fossil source-code management system, or
In a custom format defined by the RBU application.
The fossil delta format may only be used to update BLOB values ...
|
|
The SQLite Bytecode Engine
(opcode.html)
2.3. Registers
... A NULL value
A signed 64-bit integer
An IEEE double-precision (64-bit) floating point number
An arbitrary length string
An arbitrary length BLOB
A RowSet object (See the RowSetAdd, RowSetRead, and
RowSetTest opcodes)
A Frame object (Used by ...
|
|
STRICT Tables
(stricttables.html)
3. The ANY datatype
... When the datatype of a column is "ANY", that means that any kind of data -
integers, floating point values, strings, or binary blobs, can be inserted
into that table and its value and datatype will be preserved exactly as
it ...
|
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
2. Usage
... CREATE TABLE sqlite_dbpage(
pgno INTEGER PRIMARY KEY,
data BLOB
);
An SQLite database file is divided into pages.
The first page is 1, the second page is 2, and so forth.
There is no page 0.
Every page is the same ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... If it has only a "bytearray"
representation, then the value is inserted as a BLOB. To force a
value to be inserted as a BLOB even if it also has a text representation,
use a "@" character to in place of ...
|
|
Datatypes In SQLite version 2
(datatypes.html)
... CREATE TABLE ex2(
a VARCHAR(10),
b NVARCHAR(15),
c TEXT,
d INTEGER,
e FLOAT,
f BOOLEAN,
g CLOB,
h BLOB,
i TIMESTAMP,
j NUMERIC(10,5)
k VARYING CHARACTER (24),
l NATIONAL VARYING CHARACTER(16)
);
And so forth. Basically ...
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... See 35% Faster Than The Filesystem
and Internal Versus External BLOBs.
The application only has to load the data it needs, rather
than reading the entire file and holding a complete parse
in memory.
Small edits only overwrite the parts ...
|
|
The UNION Virtual Table
(unionvtab.html)
... not a part of the initial implementation.
Nota bene:
The sqlite3_blob_open() interface does not work for a union-vtab.
BLOB content must be read from the union-vtab using ordinary SQL statements.
This page last modified on 2022-01-08 ...
|
Page generated by FTS5 in about 59.48 ms.