Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Version 3 Overview
(version3.html)
... SQLite 3.0 comes with a single built-in collating sequence named "BINARY"
which is implemented using the memcmp() routine from the standard C library.
The BINARY collating sequence works well for English text. For other
languages or locales, alternative ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... Hence, two
separate binary searches are required to fulfill the request.
A WITHOUT ROWID table uses a different data design for the equivalent
table.
CREATE TABLE IF NOT EXISTS wordcount(
word TEXT PRIMARY KEY,
cnt INTEGER
) WITHOUT ROWID;
In this ...
|
|
C API: Extract Metadata About A Column Of A Table
(c3ref/table_column_metadata.html)
sqlite3_table_column_metadata()
... data type: "INTEGER"
collation sequence: "BINARY"
not null: 0
primary key: 1
auto increment: 0
This function causes all database schemas to be read from disk and
parsed, if that has not already been done, and returns an error if ...
|
|
The Amalgamation Versus Canonical Sources
(amalg-v-canon.html)
1. Which Code Base Should I Use To Build SQLite?
... To compile SQLite, you use a C-compiler to
convert the C-language source code into binary machine code.
Except it is not quite that simple. The SQLite project makes a
distinction between "canonical source code" and the "amalgamation".
Here ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... If the argument X in "hex(X)" is an
integer or floating point number, then "interprets its argument as a BLOB" means
that the binary number is first converted into a UTF8 text representation, then
that text is interpreted as ...
|
|
JSON Functions And Operators
(json1.html)
3.2. JSONB
... By storing SQLite's internal
binary representation of JSON directly in the database, applications
can bypass the overhead of parsing and rendering JSON when reading and
updating JSON values. The internal JSONB format also uses slightly
less disk space then ...
|
|
Version Numbers in SQLite
(versionnumbers.html)
1.2. The Historical Numbering System (Before 2015-10-14)
... All modern versions of SQLite (3.0.0 to present) use a b-tree storage
engine that has full support for binary data and Unicode.
This major version number X was historically incremented only for
large and important changes to ...
|
|
SQLite Copyright Release Template
(copyright-release.html)
... Precompiled binaries are excluded from
the definition of "SQLite software" in this document because the
process of compiling the software may introduce information from
outside sources which is not properly a part of SQLite.
The header comments on the SQLite ...
|
|
CREATE INDEX
(lang_createindex.html)
... Or if no collating sequence is otherwise defined,
the built-in BINARY collating sequence is used.
This page last modified on 2022-04-18 02:55:50 UTC
|
|
SQLite In 5 Minutes Or Less
(quickstart.html)
... Download The Code
Get a copy of the prebuilt binaries for your machine, or get a copy
of the sources and compile them yourself. Visit
the download page for more information.
Create A New Database Using The Command Line Interface ...
|
Page generated by FTS5 in about 47.49 ms.