Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Older News
(oldnews.html)
... Do a better job of recognizing when an ORDER BY clause can be
implemented using indices - especially in cases where the ORDER BY clause
contains terms from two or more tables in a join.
2012-10-04 - Release 3.7 ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... The INDEXED BY phrase is an SQLite extension and
is not portable to other SQL database engines.
The "INDEXED BY index-name" phrase specifies
that the named index
must be used in order to look up values on the preceding ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
... 4.2.1 Disclosure Required by Law
In the event any Confidential Information is required to be disclosed
by Hwaci under the terms of a valid and effective subpoena or order
issued by a court of competent jurisdiction, or by ...
|
|
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 ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.5. Other Example VFSes
... test_journal.c -
This file implements a shim used during SQLite testing that verifies that
the database and rollback journal are written in the correct order and
are "synced" at appropriate times in order to guarantee that the database
can recover ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... Usually, when SQLite uses an external sort to order records according
to an ORDER BY clause, all fields required by the caller are present in the
sorted records. However, if SQLite determines based on the declared type
of a table ...
|
|
Using SQLite In Multi-Threaded Applications
(threadsafe.html)
1. Overview
... In this mode, SQLite can be safely used by multiple threads provided that
no single database connection nor any object derived from database connection,
such as a prepared statement,
is used in two or more threads at the same time ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
3. Virtual Table Details
... The virtual table
attempts to find words with the lowest score and
by default (unless overridden by ORDER BY) returns
results in order of increasing score.
matchlen
In a prefix search, the matchlen is the number of characters in
the ...
|
|
STRICT Tables
(stricttables.html)
... Thus, in general, a database file that contains one or more STRICT
tables can only be read and written by SQLite version 3.37.0 or later.
However, a database created by SQLite 3.37.0 or later can still ...
|
|
SQLite Copyright Release Template
(copyright-release.html)
... In order to keep the SQLite software unencumbered by copyright
claims, the principal author asks others who may from time to
time contribute changes and enhancements to likewise disclaim
their own individual copyright interest.
Because the SQLite software found at ...
|
Page generated by FTS5 in about 221.21 ms.