Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite Query Optimizer Overview
(optoverview.html)
12.1. Using Co-routines to Defer Work until after the Sorting
... SELECT expensive_function(a) FROM tab ORDER BY date DESC LIMIT 5;
The goal of this query is to compute some value for the five most
recent entries in the table. In the query above, the
"expensive_function()" is invoked prior to ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... If indices are added, then all application
code that changes the corresponding tables must be located and modified to
keep those indices up-to-date. If columns are added, then all application
code that accesses the corresponding table must be ...
|
|
Vulnerabilities
(cves.html)
2.2. Defense Against Dark Arts
... It is good to keep up-to-date with the latest patches
in this case. The separate defense against dark arts document
contains additional suggestions that can help prevent zero-day
attacks in cases where SQLite is given inputs that ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... timeline-max-comment';
SELECT value FROM global_config WHERE name='timeline-max-comment';
SELECT value FROM config WHERE name='timeline-date-format';
SELECT value FROM config WHERE name='timeline-truncate-at-blank';
SELECT value FROM global_config WHERE name='timeline-truncate-at ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
5. Fts4aux - Direct Access to the Full-Text Index
... INSERT INTO ft(x, y) VALUES('Apple banana', 'Cherry');
INSERT INTO ft(x, y) VALUES('Banana Date Date', 'cherry');
INSERT INTO ft(x, y) VALUES('Cherry Elderberry', 'Elderberry');
-- The following query returns this data:
--
-- apple | * | 1 | 1
-- apple | 0 | 1 ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... You can put arbitrary length
strings into integer columns, floating point numbers in boolean columns,
or dates in character columns. The datatype you assign to a column in the
CREATE TABLE command does not restrict what data can be put ...
|
|
SQL Language Expressions
(lang_expr.html)
... For presentation purposes, simple functions are further
subdivided into core functions, date-time functions,
math functions, and JSON functions.
Applications can add new functions, written in C/C++, using the
sqlite3_create_function() interface.
The main expression bubble diagram above shows a ...
|
|
The SQLite Bytecode Engine
(opcode.html)
2.1. VDBE Source Code
... This document is derived from SQLite
version 3.49.1 check-in
873d4e274b498 dated 2025-02-18.
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... Modern programmers should refer to
more up-to-date documentation on SQLite is available elsewhere
on this website.
The C language interface to SQLite Version 2
The SQLite library is designed to be very easy to use from
a C ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
5.3. Update 2017: A Better Fix
... The fact that ANALYZE
is run periodically to keep the sqlite_stat1 table up-to-date means
that hand-tuning of queries is no longer required. We have not had
to tweak a query in Fossil in ages.
Therefore, the current ...
|
Page generated by FTS5 in about 71.72 ms.