Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 fourth parameter may also optionally include the SQLITE_DIRECTONLY
flag, which if present prevents the function from being invoked from
within VIEWs, TRIGGERs, CHECK constraints, generated column expressions,
index expressions, or the WHERE clause of partial indexes.
For best security ...
|
|
Defense Against The Dark Arts
(security.html)
1.2. Untrusted SQLite Database Files
... If the application does not use triggers or views, consider disabling the
unused capabilities with:
sqlite3_db_config(db,SQLITE_DBCONFIG_ENABLE_TRIGGER,0,0);
sqlite3_db_config(db,SQLITE_DBCONFIG_ENABLE_VIEW,0,0);
For reading database files that are unusually high-risk, such as database
files that are ...
|
|
Architecture of SQLite
(arch.html)
... attach.c,
auth.c,
build.c,
delete.c,
expr.c,
insert.c,
pragma.c,
select.c,
trigger.c,
update.c,
vacuum.c,
where.c,
wherecode.c, and
whereexpr.c.
In these files is where most of the serious magic happens ...
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... Applications can leverage the
full-text search and RTREE indexes and use triggers to implement
an automated undo/redo stack.
Performance problems can often be resolved, even late in the
development cycle, using CREATE INDEX, avoiding costly
redesign, rewrite, and ...
|
|
SQLite Keywords
(lang_keywords.html)
... RELEASE
RENAME
REPLACE
RESTRICT
RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER
UNBOUNDED
UNION
UNIQUE
UPDATE
USING
VACUUM
VALUES
VIEW
VIRTUAL
WHEN
WHERE
WINDOW
WITH
WITHOUT
This page last modified on 2022 ...
|
|
About SQLite
(about.html)
... A complete SQL database with multiple tables, indices,
triggers, and views, is contained in a single disk file.
The database file format is cross-platform - you can freely copy a database
between 32-bit and 64-bit systems or between ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... This will be
0 for a direct insert, update, or delete operation;
1 for inserts, updates, or deletes invoked by top-level triggers;
or higher values for changes resulting from trigger-invoked triggers.
The old and new submethods return the ...
|
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
3. Limitations
... The sqldiff.exe utility does not (currently) display differences in
TRIGGERs or VIEWs.
The sqldiff utility is not designed to support schema migrations
and is forgiving with respect to differing column definitions.
Normally, only the column names and their order ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
9. Keywords Can Often Be Used As Identifiers
... CREATE TRIGGER AFTER INSERT ON tableX BEGIN
INSERT INTO tableY(b) VALUES(new.a);
END;
The trigger created by the previous statement is named "AFTER"
and it is a "BEFORE" trigger. The "AFTER" token is used as an identifier
instead ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA recursive_triggers
PRAGMA recursive_triggers;
PRAGMA recursive_triggers = boolean;
Query, set, or clear the recursive trigger capability.
Changing the recursive_triggers setting affects the execution of
all statements prepared
using the database connection, including those prepared before the
setting was changed. Any existing statements prepared ...
|
Page generated by FTS5 in about 84.31 ms.