Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Floating Point Numbers
(floatingpoint.html)
1. How SQLite Stores Numbers
... This is not an SQLite limitation.
It is a mathematical limitation inherent in the design of floating-point numbers.
—¹
Exception: The R-Tree extension stores information as 32-bit floating
point or integer values.
|
|
RETURNING
(lang_returning.html)
... This limitation might be removed in future versions of SQLite.
The RETURNING clause is only available in top-level DELETE, INSERT,
and UPDATE statements. The RETURNING clause cannot be used by
statements within triggers.
Even though a DML statement with ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.5. Other Example VFSes
... test_quota.c -
This file implements a shim called "quota" that enforces cumulative
file size limits on a collection of database files. An auxiliary
interface is used to define "quota groups". A quota group is a
set of files (database files ...
|
|
Measuring and Reducing CPU Usage in SQLite
(cpu.html)
4. Limitations
... However, it is important to recognize the limitations of this approach:
Performance measurements are done with a single compiler (gcc 5.4.0),
optimization setting (-Os), and
on a single platform (Ubuntu 16.04 LTS on x64). The performance of ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
11. Subquery Flattening
... The subquery does not use LIMIT or the outer query is
not a join.
The subquery does not use LIMIT or the outer query
does not use aggregates.
(Obsolete)
The subquery and the outer query do not both have ORDER ...
|
|
CREATE TABLE
(lang_createtable.html)
... The number of columns in a table is limited by the SQLITE_MAX_COLUMN
compile-time parameter. A single row of a table cannot store more than
SQLITE_MAX_LENGTH bytes of data. Both of these limits can be lowered at
runtime using the ...
|
|
INSERT
(lang_insert.html)
... Any SELECT statement, including
compound SELECTs and SELECT statements with ORDER BY and/or LIMIT clauses,
may be used in an INSERT statement of this form.
To avoid a parsing ambiguity, the SELECT statement should always
contain a WHERE clause ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... For spinning magnetic media,
transfers await platter rotation and head movement, then
are limited by spin velocity.
When the File I/O channel includes a network connection,
(in addition to some genuine File I/O at its far end),
additional ...
|
|
SQLite Keywords
(lang_keywords.html)
... IF
IGNORE
IMMEDIATE
IN
INDEX
INDEXED
INITIALLY
INNER
INSERT
INSTEAD
INTERSECT
INTO
IS
ISNULL
JOIN
KEY
LAST
LEFT
LIKE
LIMIT
MATCH
MATERIALIZED
NATURAL
NO
NOT
NOTHING
NOTNULL
NULL
NULLS
OF
OFFSET
ON
OR
ORDER
OTHERS
OUTER
OVER
PARTITION
PLAN
PRAGMA ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... The ORDER BY and LIMIT clauses on UPDATE and DELETE statements are not
supported. ORDER BY and LIMIT are not normally supported for UPDATE or
DELETE in any context but can be enabled for top-level statements
using the SQLITE_ENABLE_UPDATE_DELETE_LIMIT ...
|
Page generated by FTS5 in about 132.93 ms.