Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
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 ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... 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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
10. Future Directions And Conclusion
... The current VFS implementations
for Unix (Linux and Mac OS X) and Windows make pessimistic assumptions about
the behavior of those systems. After consultation with experts
on how these systems work, we might be able to relax some of the ...
|
Page generated by FTS5 in about 73.34 ms.