Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 Next-Generation Query Planner
(queryplanner-ng.html)
5.1. Case Study: Upgrading Fossil to the NGQP
... CREATE TABLE plink(
pid INTEGER REFERENCES blob,
cid INTEGER REFERENCES blob
);
CREATE UNIQUE INDEX plink_i1 ON plink(pid,cid);
CREATE TABLE tagxref(
tagid INTEGER REFERENCES tag,
mtime TIMESTAMP,
rid INTEGER REFERENCE blob,
UNIQUE(rid, tagid)
);
CREATE INDEX tagxref_i1 ON tagxref ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1.1. Limitations
... Or it might change from an integer into
a string or blob. A value that was NULL might become an integer.
A string value might become a BLOB. And so forth.
Constraints may not be valid after recovery. CHECK constraints ...
|
|
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 ...
|
|
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 ...
|
|
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 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 ...
|
|
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 ...
|
|
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 ...
|
Page generated by FTS5 in about 103.47 ms.