Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... New threads are launched
to help with sort operations when multithreaded sorting
is enabled (using the PRAGMA threads command) and the amount of content
to be sorted exceeds the page size times the minimum of the
PRAGMA cache_size setting and ...
|
|
CREATE INDEX
(lang_createindex.html)
... The legacy_file_format pragma can be used to change set the specific
behavior for any version of SQLite.
1.4. NULLS FIRST and NULLS LAST
The NULLS FIRST and NULLS LAST predicates are not supported
for indexes. For sorting purposes, SQLite ...
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... The application_id pragma can be used to set an "Application ID"
integer in the database file so that tools like
file(1) can determine that the file
is associated with your application and is not just a generic
SQL database ...
|
|
Recent SQLite News
(news.html)
... This release features an initial implementation the
"PRAGMA optimize" command. This command can now be used to cause
ANALYZE to be run on an as-needed basis. Applications should invoke
"PRAGMA optimize" just before closing the database connection.
The "PRAGMA ...
|
|
SQLite Keywords
(lang_keywords.html)
... MATCH
MATERIALIZED
NATURAL
NO
NOT
NOTHING
NOTNULL
NULL
NULLS
OF
OFFSET
ON
OR
ORDER
OTHERS
OUTER
OVER
PARTITION
PLAN
PRAGMA
PRECEDING
PRIMARY
QUERY
RAISE
RANGE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RELEASE
RENAME
REPLACE
RESTRICT
RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT ...
|
|
In-Memory Databases
(inmemorydb.html)
... An application can use the
temp_store pragma and the SQLITE_TEMP_STORE compile-time parameter to
force temporary databases to behave as pure in-memory databases, if desired.
This page last modified on 2022-04-18 02:55:50 UTC
|
|
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 ...
|
|
C API: Function Flags
(c3ref/c_deterministic.html)
SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_SUBTYPE, SQLITE_INNOCUOUS, SQLITE_RESULT_SUBTYPE, SQLITE_SELFORDER1
... Some heightened security settings
(SQLITE_DBCONFIG_TRUSTED_SCHEMA and PRAGMA trusted_schema=OFF)
disable the use of SQL functions inside views and triggers and in
schema structures such as CHECK constraints, DEFAULT clauses,
expression indexes, partial indexes, and generated columns unless
the function is ...
|
|
Implementation Limits For SQLite
(limits.html)
... Beginning with version 3.6.18, recursive triggers
were supported but had to be explicitly enabled using the
PRAGMA recursive_triggers statement.
Beginning with version 3.7.0 (2009-09-11),
recursive triggers are enabled by default but can be manually ...
|
|
Hints for Debugging SQLite
(debugging.html)
... Then run the "PRAGMA vdbe_addoptrace=ON;" followed by the
SQL statement in question. Each opcode will be displayed as it is
appended to the VDBE program, and the breakpoint will fire immediately
thereafter. Step until reaching the opcode then look ...
|
Page generated by FTS5 in about 131.42 ms.