Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 FTS3 and FTS4 Extensions
(fts3.html)
9.2. Variable Length Integer (varint) Format
Integer values stored as part of segment b-tree nodes are encoded using the
FTS varint format. This encoding is similar, but not identical, to
the SQLite varint format.
An encoded FTS varint consumes between one and ten bytes of ...
|
|
Pointer Passing Interfaces
(bindptr.html)
5. Summary
... Pointers should never be exchanged by encoding them as some other
SQL datatype, such as integers or BLOBs. Instead, use the interfaces
designed to facilitate secure pointer passing:
sqlite3_bind_pointer(), sqlite3_result_pointer(), and
sqlite3_value_pointer().
The use of pointer-passing is an advanced ...
|
|
The Session Extension
(sessionintro.html)
2.1. Changesets and Patchsets
... A changeset is a blob of data that encodes a series of
changes to a database. Each change in a changeset is one of the
following:
An INSERT. An INSERT change contains a single row to add to
a database ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
4.1. Binary Encoding of Polygons
Geopoly stores all polygons internally using a binary format. A binary
polygon consists of a 4-byte header following by an array of coordinate
pairs in which each dimension of each coordinate is a 32-bit floating point
number.
The ...
|
|
Datatypes In SQLite
(datatype3.html)
7. Collating Sequences
... BINARY - Compares string data using memcmp(), regardless
of text encoding.
NOCASE - Similar to binary, except that it uses
sqlite3_strnicmp() for the comparison. Hence the 26 upper case
characters of ASCII are folded to their lower case equivalents before
the comparison ...
|
|
Books About SQLite
(books.html)
... It shows how
records are encoded, how to decode them manually and how to decode
records that are partially overwritten. It also describe how the
workings of SQLite, and in particular the journal and WAL, can be used
to ascertain ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... The first line of the file is just:
<?xml version="1.0" encoding="UTF-8"?>
The second line of the file contains 211792 characters of
impenetrable XML. Yes, 211792 characters all on one line.
This file is a ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... The pager is unconcerned
with the details of B-Trees, text encodings, indices, and so forth.
From the point of view of the pager the database consists of
a single file of uniform-sized blocks. Each block is called a ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... But unless you are looking at the low-level byte encoding
of the database file, that fact is unimportant.) Because there is only
a single B-Tree, the text of the "word" column is only stored once in the
database ...
|
Page generated by FTS5 in about 47.21 ms.