Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
2. Differences From Ordinary Rowid Tables
... The incremental blob I/O mechanism does not work
for WITHOUT ROWID tables.
Incremental BLOB I/O uses the rowid to create an sqlite3_blob object for
doing the direct I/O. However, WITHOUT ROWID tables do not have a rowid ...
|
|
C API: Run-Time Limit Categories
(c3ref/c_limit_attached.html)
SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN, SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT, SQLITE_LIMIT_VDBE_OP ...
... SQLITE_LIMIT_LENGTH
The maximum size of any string or BLOB or table row, in bytes.
SQLITE_LIMIT_SQL_LENGTH
The maximum length of an SQL statement, in bytes.
SQLITE_LIMIT_COLUMN
The maximum number of columns in a table definition or in the
result set of ...
|
|
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 ...
|
|
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 ...
|
|
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 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 ...
|
Page generated by FTS5 in about 104.66 ms.