Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Otherwise, the
** system may become deadlocked.
*/
int sqlite3_blocking_prepare_v2(
sqlite3 *db, /* Database handle. */
const char *zSql, /* UTF-8 encoded SQL statement. */
int nSql, /* Length of zSql in bytes. */
sqlite3_stmt **ppStmt, /* OUT: A pointer to the prepared statement */
const char **pz /* OUT ...
|
|
Implementation Limits For SQLite
(limits.html)
... During part of SQLite's INSERT and SELECT processing, the complete
content of each row in the database is encoded as a single BLOB.
So the SQLITE_MAX_LENGTH parameter also determines the maximum
number of bytes in a row.
The maximum ...
|
Page generated by FTS5 in about 44.56 ms.