Small. Fast. Reliable.
Choose any three.
Choose any three.
|
pressrelease-20071212.html
(pressrelease-20071212.html)
... have joined the SQLite Consortium as charter members.
SQLite is a compact, high efficiency, high reliability, embeddable SQL database
engine. The source code to SQLite is in the public domain and is available with
no associated fees. SQLite is the ...
|
|
SQLite Older News
(oldnews.html)
... The bug is obscure - it changes
a LEFT JOIN into an INNER JOIN in some cases when there is a 3-way join
and OR terms in the WHERE clause. But it was considered serious enough to
rush out a ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.7. Materializations Of Views And Subqueries
... SELECT * FROM ex1 JOIN (SELECT b FROM ex2) AS t ON t.b=ex1.a;
Depending on the query, SQLite might need to materialize the
"(SELECT b FROM ex2)" subquery into a temporary table, then
perform the join between ex1 ...
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1.1. Table and Index Scans
... sqlite> CREATE INDEX i2 ON t1(a, b);
sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1;
QUERY PLAN
`--SEARCH t1 USING COVERING INDEX i2 (a=?)
All joins in SQLite are implemented using nested scans ...
|
|
UPSERT
(lang_upsert.html)
... The parser might not be able to tell if the
"ON" keyword is introducing the UPSERT or if it is the ON clause
of a join. To work around this, the SELECT statement should always
include a WHERE clause, even ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... FROM event CROSS JOIN blob WHERE blob.rid=event.objid AND mtime<=2457647.121412037);
SELECT max(timestamp) FROM timeline;
SELECT julianday('2016-09-24 17:42:43',fromLocal());
SELECT EXISTS (SELECT 1 FROM event CROSS JOIN blob WHERE blob ...
|
|
SQL Language Expressions
(lang_expr.html)
... The || operator is "concatenate" - it joins together
the two strings of its operands.
The -> and ->> operators are "extract";
they extract the RHS component from the LHS.
For an example, see
JSON subcomponent extraction.
The % operator casts both ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... is often easier and quicker to load the data into
an in-memory SQLite database and use queries with joins and ORDER BY
clauses to extract the data in the form and order needed rather than
to try to code ...
|
|
The SQLite R*Tree Module
(rtree.html)
4.1. Auxiliary Columns
... For example, the earlier
join between demo_index and demo_data can now
be written as a simple query, like this:
SELECT objname FROM demo_index2
WHERE contained_in(boundary, 35.37785, -80.77470)
AND minX<=-80.77470 AND maxX>=-80.77470 ...
|
|
SQLite Database Speed Comparison
(speed.html)
... These tests did not attempt to measure multi-user performance or
optimization of complex queries involving multiple joins and subqueries.
These tests are on a relatively small (approximately 14 megabyte) database.
They do not measure how well the database engines ...
|
Page generated by FTS5 in about 41.33 ms.