Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Percentile Extension
(percentile.html)
3.2. The percentile(Y,P) aggregate function
The percentile(Y,P) aggregate function computes an answer X which is
a value that is greater than or equal to P percent of the non-NULL inputs
and which is less than or equal to 100-P percent of ...
|
|
Pointer Passing Interfaces
(bindptr.html)
2.3. Pointer Leaks
... SELECT snippet(x'6092310100000000') FROM t1 WHERE cx MATCH $pattern;
The BLOB argument to snippet() does not have the correct subtype, so the
snippet function ignores it, makes no changes to any data structures,
and harmlessly returns NULL.
But the ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... SQLITE_ENABLE_OFFSET_SQL_FUNC
This option enables support for the sqlite_offset(X) SQL function.
The sqlite_offset(X) SQL function requires a new interface on the
B-tree storage engine, a new opcode in the virtual machine that
runs SQL statements, and a new ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.1. Creating An R*Tree Index
... CREATE VIRTUAL TABLE demo_index USING rtree(
id, -- Integer primary key
minX, maxX, -- Minimum and maximum X coordinate
minY, maxY -- Minimum and maximum Y coordinate
);
|
|
Books About SQLite
(books.html)
... SQLite runs on Linux, Windows, Mac OS X, and a few other operating systems. It has been widely used in low-to-medium tier database applications.
This Short Cut discusses design principles, engineering trade-offs,
implementation issues, and operations of ...
|
|
SQLite Older News
(oldnews.html)
... Ticket 31338dca7e
describes a
problem with queries that have a WHERE clause of the form (x AND y) OR z
where x and z come from one table of a join and y comes from a different
table.
Ticket eb5548a849 ...
|
|
Custom Builds Of SQLite
(custombuild.html)
... Or, if SQLite is used on an operating system other than
Unix (Linux or Mac OS X), Windows (Win32 or WinCE), or OS/2 then none
of the interface subsystems that come built into SQLite will work
and the application ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... However, if the application calls sqlite3changeset_new(),
sqlite3changeset_old() or sqlite3changeset_conflict on a changeset
iterator directly (including on a changeset iterator passed to a
conflict-handler callback) then the X'' value is returned. The application
must translate X'' to NULL itself if ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.1. The eval method
... db1 eval {INSERT INTO t1 VALUES(1,'hello')}
db1 eval {INSERT INTO t1 VALUES(2,'goodbye')}
db1 eval {INSERT INTO t1 VALUES(3,'howdy!')}
set x [db1 eval {SELECT * FROM t1 ORDER BY a}]
The variable $x is ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2.1. Read Performance Measurements
... With these optimizations, SQLite is twice as fast as Android
or MacOS-X and over 10 times faster than Windows.
Chart 3: SQLite read latency relative to direct filesystem reads.
100K blobs, avg size 10KB, random order
using sqlite3_blob_read() from ...
|
Page generated by FTS5 in about 147.21 ms.