Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: delete-stmt delete-stmt-limited update-stmt update-stmt-limited
See also: lang_createtrigger.html lang_delete.html lang_indexedby.html lang_update.html
raise-function ...
|
|
SELECT
(lang_select.html)
... The LIMIT clause
The LIMIT clause is used to place an upper bound on the number of rows
returned by the entire SELECT statement.
In a compound SELECT, only the
last or right-most simple SELECT may contain a LIMIT ...
|
|
The WITH Clause
(lang_with.html)
... The LIMIT clause, if present, determines the maximum number of rows that
will ever be added to the recursive table in step 2b.
Once the limit is reached, the recursion stops.
A limit of zero means that no rows are ...
|
|
CREATE INDEX
(lang_createindex.html)
... There are no arbitrary limits on the number of indices that can be
attached to a single table. The number of columns in an index is
limited to the value set by
sqlite3_limit(SQLITE_LIMIT_COLUMN,...).
Indexes are removed with the DROP ...
|
|
C API: Compile-Time Authorization Callbacks
(c3ref/set_authorizer.html)
sqlite3_set_authorizer()
... Applications that need to process SQL from untrusted sources
might also consider lowering resource limits using sqlite3_limit()
and limiting database size using the max_page_count PRAGMA
in addition to using an authorizer.
Only a single authorizer can be in place on ...
|
|
ATTACH DATABASE
(lang_attach.html)
... There is a limit, set using sqlite3_limit() and
SQLITE_LIMIT_ATTACHED, to the number of databases that can be
simultaneously attached to a single database connection.
This page last modified on 2025-02-06 23:19:09 UTC
|
|
C API: Create Or Redefine SQL Functions
(c3ref/create_function.html)
sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()
... The length of the name is limited to 255 bytes in a UTF-8
representation, exclusive of the zero-terminator. Note that the name
length limit is in UTF-8 bytes, not characters nor UTF-16 bytes.
Any attempt to ...
|
|
C API: Finding The Subtype Of SQL Values
(c3ref/value_subtype.html)
sqlite3_value_subtype()
... The subtype
information can be used to pass a limited amount of context from
one SQL function to another. Use the sqlite3_result_subtype()
routine to set the subtype for the return value of an SQL function.
Every application-defined SQL function ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA threads
PRAGMA threads;
PRAGMA threads = N;
Query or change the value of the
sqlite3_limit(db,SQLITE_LIMIT_WORKER_THREADS,...) limit for
the current database connection. This limit sets an upper bound
on the number of auxiliary threads that a prepared statement is
allowed to ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
3.5. Setting memory usage limits
... The soft heap limit is "soft" in this sense: If SQLite is not able
to free up enough auxiliary memory to stay below the limit, it goes
ahead and allocates the extra memory and exceeds its limit. This occurs
under ...
|
Page generated by FTS5 in about 125.57 ms.