Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The C language interface to SQLite Version 2
(c_interface.html)
... The
entire SQL database is stored in a single file on the disk. But
additional temporary files may be created during the execution of
an SQL command in order to store the database rollback journal or
temporary and intermediate results ...
|
|
Query Planning
(queryplanner.html)
1.3. Lookup By Index
... CREATE INDEX Idx1 ON fruitsforsale(fruit);
An index is another table similar to the original "fruitsforsale" table
but with the content (the fruit column in this case) stored in front of the
rowid and with all rows in content order ...
|
|
Books About SQLite
(books.html)
... There is no separate install or
setup procedure to initialize SQLite before using it.
There is no configuration file.
SQLite is open source, and is available in the public domain
(for more information on open source, visit http://opensource.org ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... Content can be stored as INTEGER,
REAL, TEXT, BLOB, or as NULL.
(3) SQLite lets me insert a string into a database column of type integer!
This is a feature, not a bug. SQLite uses dynamic typing.
It does not ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... If P1 holds
a NULL then store a NULL in P2.
BitOr
Take the bit-wise OR of the values in register P1 and P2 and
store the result in register P3.
If either input is NULL, the result is ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
... Deleting a hot journal
SQLite normally stores all content in a single disk file. However,
while performing a transaction, information necessary to recover the
database following a crash or power failure is stored in auxiliary
journal files. Such journal files ...
|
|
Run-Time Loadable Extensions
(loadext.html)
... memvfs.c —
Implementation of a new VFS that stores all content in-memory.
rot13.c —
Implementation of a rot13()
SQL function. This is a very simple example of an extension function
and is useful as a template for ...
|
|
WAL-mode File Format
(walformat.html)
... u32 aPgno[4096];
u16 aHash[8192];
Collectively, the aPgno entries record the database page number stored
in all frames of the WAL file. The aPgno[0] entry on the first hash table
records the database page number stored in the ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
... So, beginning with version 3.3.14, whenever any page within a
sector is written into the journal file, all pages in that same sector
are stored with it.
It is important to store all pages of a sector in ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
5.1. Case Study: Upgrading Fossil to the NGQP
... The ANALYZE command
gathers statistics on the quality of the various indexes and stores those
statistics in SQLITE_STAT1 table.
Having access to this statistical information,
the NGQP easily chooses algorithm-1 as the best algorithm, by a wide
margin.
Why ...
|
Page generated by FTS5 in about 35.40 ms.