SQLite Archive Files
(sqlar.html)
5. Managing SQLite Archives From Application Code
... sqlar_compress(X)
The sqlar_compress(X) function attempts to compress a copy of the
blob X using the Default algorithm and returns the
result as a blob. If the input X is not a compressible blob, then
a copy of X ...
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... sqlite3_column_bytes() returns
the number of bytes in a column that has type BLOB or the number of bytes
in a TEXT string with UTF-8 encoding. sqlite3_column_bytes16() returns
the same value for BLOBs but for TEXT strings returns the number ...
|
Built-In Mathematical SQL Functions
(lang_mathfunc.html)
... The arguments to math functions can be integers, floating-point numbers,
or strings or blobs that look like integers or real numbers. If any argument
is NULL or is a string or blob that is not readily converted into a ...
|
Transaction
(lang_transaction.html)
... An open sqlite3_blob used for
incremental BLOB I/O also counts as an unfinished statement.
The sqlite3_blob finishes when it is closed.
The explicit COMMIT command runs immediately, even if there are
pending SELECT statements. However, if there are pending ...
|
C API: Dynamically Typed Value Object
(c3ref/value.html)
struct sqlite3_value
... Values stored in sqlite3_value objects
can be integers, floating point values, strings, BLOBs, or NULL.
An sqlite3_value object may be either "protected" or "unprotected".
Some interfaces require a protected sqlite3_value. Other interfaces
will accept either a protected or an unprotected ...
|
CREATE TABLE
(lang_createtable.html)
... Integer primary key or rowid
columns are not able to hold floating point values, strings, BLOBs, or NULLs.
If an UPDATE statement attempts to set an integer primary key or rowid column
to a NULL or blob value, or to ...
|
The Next-Generation Query Planner
(queryplanner-ng.html)
4.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 ...
|
The SQLite Zipfile Module
(zipfile.html)
3.1. Table-Valued Function (read-only access)
... Or, if the argument is an SQL blob, then it is the zip
archive data itself.
For example, to inspect the contents of zip archive "test.zip" from
the current directory:
SELECT * FROM zipfile('test.zip');
Or, from the SQLite ...
|
Features Of SQLite
(features.html)
... Supports terabyte-sized databases and gigabyte-sized strings
and blobs. (See limits.html.)
Small code footprint:
less than 750KiB fully configured or much less
with optional features omitted.
Simple, easy to use API.
Fast: In some cases, SQLite is
faster ...
|
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 ...
|
Page generated by FTS5 in about 63.43 ms.