Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The UINT Collating Sequence
(uintcseq.html)
1. Overview
The UINT collating sequences is a loadable extension for
SQLite that implements a new collating sequence that compares text
containing unsigned integers in numeric order.
The UINT collating sequence is not a standard part of SQLite.
It must be loaded ...
|
|
The Base64() SQL Function
(base64.html)
1. Overview
The base64() function is an SQL function implemented as
a loadable extension for SQLite. The function converts a binary
BLOB into equivalent RFC 4648
text or converts RFC 4648 text into the equivalent BLOB.
The base64() function is not a ...
|
|
LoC Recommended Storage Format
(locrsf.html)
1. Overview
SQLite is a
Recommended Storage Format
for datasets according to the
US Library of Congress.
Further information:
https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml#local
https://www.loc.gov/preservation/resources/rfs/data.html
As of this ...
|
|
The dbhash.exe Utility Program
(dbhash.html)
1. Overview
The dbhash (or dbhash.exe on Windows) utility is a
command-line program that computes the SHA1 hash of the schema and content
for an SQLite database.
Dbhash ignores extraneous formatting details and hashes only the database
schema and content ...
|
|
The generate_series Table-Valued Function
(series.html)
1. Overview
The generate_series(START,STOP,STEP) table-valued function is a
loadable extension included in the SQLite source tree, and compiled into
the command-line shell. The generate_series() table has one visible
result column named "value" holding integer values
and a ...
|
|
The SQLITE_MEMSTAT Virtual Table
(memstat.html)
1. Overview
The SQLITE_MEMSTAT extension implements an eponymous-only virtual table that
provides SQL access to the sqlite3_status64() and
sqlite3_db_status() interfaces.
The SQLITE_STMT extension can also be loaded at run-time
by compiling the extension into a shared library or DLL using ...
|
|
ATTACH DATABASE
(lang_attach.html)
1. Overview
The ATTACH DATABASE statement adds another database
file to the current database connection.
Database files that were previously attached can be removed using
the DETACH DATABASE command.
2. Details
The filename for the database to be attached is ...
|
|
The COMPLETION() Table-Valued Function
(completion.html)
1. Overview
The COMPLETION extension implements a table-valued function named
"completion" that can be used to suggest completions of partially entered
words during interactive SQL input. The completion table can be
used to help implement tab-completion, for example.
|
|
The Base85() SQL Function
(base85.html)
1. Overview
The base85() function is an SQL function implemented as
a loadable extension for SQLite. The function converts a binary
BLOB into an equivalent base-85 text encoding
or converts that same base-85 text encoding back into a BLOB.
The ...
|
|
The Bytecode() And Tables_Used() Table-Valued Functions
(bytecodevtab.html)
1. Overview
Bytecode and tables_used are virtual tables built into SQLite that
access information about prepared statements.
Both bytecode and tables_used operate as table-valued functions.
They take a single required argument which is either the text of
an SQL statement, or ...
|
Page generated by FTS5 in about 57.60 ms.