Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Recent SQLite News
(news.html)
... One bug of note is
ticket 9936b2fa443fec
which describes a hard-to-reach condition where the ORDER BY LIMIT
optimization might cause an infinite loop during query evaluation.
This ticket raised a lot of
concern on
HackerNews and
Reddit,
probably ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... But an SQLite database is not limited to a simple key/value structure
like a pile-of-files database. An SQLite database can have dozens
or hundreds or thousands of different tables, with dozens or
hundreds or thousands of fields ...
|
|
Vulnerabilities
(cves.html)
3. Status Of Recent SQLite CVEs
... This might enable a denial-of-service, if the
application has not taken appropriate and prudent steps
to limit the run-time of SQL statements. This is not a vulnerability, as there
are countless perfectly valid SQL queries, especially queries ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... 1 FROM tagxref WHERE tagid=5 AND tagtype>0 AND rid=blob.rid)
ORDER BY event.mtime DESC LIMIT 50;
-- SELECT value FROM config WHERE name='timeline-utc';
SELECT count(*) FROM timeline WHERE etype!='div';
SELECT min(timestamp) FROM ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... OffsetLimit
This opcode performs a commonly used computation associated with
LIMIT and OFFSET processing. r[P1] holds the limit counter. r[P3]
holds the offset counter. The opcode computes the combined value
of the LIMIT and ...
|
|
Command Line Shell For SQLite
(cli.html)
2. Special commands to sqlite3 (dot-commands)
... Show names of indexes
.intck ?STEPS_PER_UNLOCK? Run an incremental integrity check on the db
.limit ?LIMIT? ?VAL? Display or change the value of an SQLITE_LIMIT
.lint OPTIONS Report potential schema issues.
.load FILE ?ENTRY? Load an extension library
.log FILE ...
|
|
Query Planning
(queryplanner.html)
3.3. Partial Sorting Using An Index (a.k.a. Block Sorting)
... If a LIMIT clause is present, it might be possible to avoid scanning
the entire table.
Because of these advantages, SQLite always tries to do a partial sort using an
index even if a complete sort by index is not ...
|
|
Write-Ahead Logging
(wal.html)
2.3. Performance Considerations
... By default, the checkpoint will be
run automatically by the same thread that does the COMMIT that pushes
the WAL over its size limit. This has the effect of causing most
COMMIT operations to be very fast but an occasional ...
|
|
Database File Format
(fileformat.html)
1.2. Pages
... Usually SQLite will
hit the maximum file size limit of the underlying filesystem or disk
hardware long before it hits its own internal size limit.
In common use, SQLite databases tend to range in size from a few kilobytes
to ...
|
|
Datatypes In SQLite
(datatype3.html)
3.1.1. Affinity Name Examples
... Note that numeric arguments
in parentheses that following the type name (ex: "VARCHAR(255)") are
ignored by SQLite - SQLite does not impose any length restrictions
(other than the large global SQLITE_MAX_LENGTH limit) on the length of
strings, BLOBs or numeric ...
|
Page generated by FTS5 in about 129.24 ms.