Small. Fast. Reliable.
Choose any three.
Choose any three.
|
What If OpenDocument Used SQLite?
(affcase1.html)
... It is clearly superior to a custom binary file format.
But using an SQLite database as the
container, instead of ZIP, would be more elegant still.
A ZIP archive is basically a key/value database, optimized for
the case of ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... Both the Windows
and Linux precompiled binaries in the distribution are compiled this way.
If you are unsure if the SQLite library you are linking against is compiled
to be threadsafe you can call the sqlite3_threadsafe()
interface to find out ...
|
|
Database File Format
(fileformat.html)
2.2. Record Sort Order
... BINARY
The built-in BINARY collation compares strings byte by byte
using the memcmp() function
from the standard C library.
NOCASE
The NOCASE collation is like BINARY except that uppercase
ASCII characters ('A' through 'Z')
are folded into their lowercase ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... The data can be a complex mix of large binary blobs, text, and small
numeric or boolean values. The data format can be easily extended
by adding new tables and/or columns, without breaking legacy receivers.
The SQL query language ...
|
|
TH3
(th3.html)
5. Mutation Testing
... The "th3" binary is run and the output checked for errors.
The script shows progress for each cycle of the previous step then
displays a summary of "survivors" at the end. A "survivor" is a
mutation that was not detected ...
|
|
SQLite Older News
(oldnews.html)
... The prebuilt binaries and the amalgamation found on the
download page include the FTS3 fulltext
search extension module. We are doing this on an experimental
basis and are not promising to provide prebuilt binaries with
FTS3 in the future.
2007 ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.7. Materializations Of Views And Subqueries
... a temporary
index) that allows one to determine whether or not a value ex2.b
exists using a simple binary search. Once this table is constructed,
the outer query is run and for each prospective result row a check
is ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... The SQL-standard compliant syntax is disabled by default because (A)
it requires about 1,200 bytes of extra code in the compiled SQLite binary
and (B) because it makes your SQL code more difficult to read, write,
and understand ...
|
|
The SQLite R*Tree Module
(rtree.html)
4. Using R*Trees Effectively
... CREATE TABLE demo_data(
id INTEGER PRIMARY KEY, -- primary key
objname TEXT, -- name of the object
objtype TEXT, -- object type
boundary BLOB -- detailed boundary of object
);
In this example, the demo_data.boundary field is intended to hold some
kind of binary ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
4.1. Composite Foreign Key Constraints
... CREATE TABLE album(
albumartist TEXT,
albumname TEXT,
albumcover BINARY,
PRIMARY KEY(albumartist, albumname)
);
CREATE TABLE song(
songid INTEGER,
songartist TEXT,
songalbum TEXT,
songname TEXT,
FOREIGN KEY(songartist, songalbum) REFERENCES album(albumartist, albumname)
);
In this system, each entry in the song ...
|
Page generated by FTS5 in about 46.35 ms.