Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Imposter Tables
(imposter.html)
2. Details
... Index b-trees contain
an arbitrary binary key and no data. So table b-trees and index
b-trees are not directly compatible.
However, the b-tree for a WITHOUT ROWID table is in the same format
as an index ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
2. The "path" column of the dbstat virtual table
... page in overflow chain
'/1c2/000+000002' // Third page in overflow chain
If the paths are sorted using the BINARY collation sequence, then
the overflow pages associated with a cell will appear earlier in the
sort-order than its child ...
|
|
STRICT Tables
(stricttables.html)
3. The ANY datatype
... When the datatype of a column is "ANY", that means that any kind of data -
integers, floating point values, strings, or binary blobs, can be inserted
into that table and its value and datatype will be preserved exactly as
it ...
|
|
CREATE TABLE
(lang_createtable.html)
... The default
collation sequence for each column of the new table is BINARY.
Tables created using CREATE TABLE AS are initially populated with the
rows of data returned by the SELECT statement. Rows are assigned contiguously
ascending rowid values, starting ...
|
|
SQL Language Expressions
(lang_expr.html)
... The result of any binary operator is either a numeric value or
NULL, except for the || concatenation operator,
and the -> and ->> extract operators
which can return values of any type.
All operators generally evaluate to NULL when ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
1.1. Use of shared-cache is discouraged
... Applications that build their own copy of SQLite from source code
are encouraged to use the -DSQLITE_OMIT_SHARED_CACHE compile-time option,
as the resulting binary will be both smaller and faster.
The shared-cache interfaces described here will continue to be ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... They are also usually binary, though the DWG format is a notable exception.
Custom file formats require specialized application code
to read and write and are not normally accessible from commonly
available tools such as unix command-line programs and ...
|
|
Floating Point Numbers
(floatingpoint.html)
1. How SQLite Stores Numbers
... So-called "REAL" or floating point values are stored in the
IEEE 754
Binary-64
format¹.
This gives a range of positive values between approximately
1.7976931348623157e+308 and 4.9406564584124654e-324 with an equivalent
range of negative values ...
|
|
How SQLite Is Tested
(testing.html)
8.2. Valgrind
... Valgrind is a simulator - it simulates
an x86 running a Linux binary. (Ports of Valgrind for platforms other
than Linux are in development, but as of this writing, Valgrind only
works reliably on Linux, which in the opinion of the ...
|
|
The RBU Extension
(rbu.html)
2.2.1. The RBU Database Schema
... Tables within the RBU database are processed in order by
name (from smallest to largest according to the BINARY collation sequence),
so the order in which target tables are updated is influenced by the selection
of the <integer> ...
|
Page generated by FTS5 in about 46.47 ms.