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 ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... One cannot easily view, change, or extract the content of an
OpenDocument presentation using generic tools.
The only reasonable way to view or edit an OpenDocument document is to open
it up using an application that is specifically designed to ...
|
|
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 ...
|
|
The RBU Extension
(rbu.html)
2.2.3. Using RBU with FTS3/4 Tables
... In order to avoid duplicating data within the
RBU database, an SQL view may be used in place of one of the data_% tables.
For example, for the target database schema:
CREATE TABLE ccc(addr, text);
CREATE VIRTUAL TABLE ccc_fts ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... When files opened with the asynchronous VFS are read from
(using the vfs xRead() method), the data is read from the file on
disk and the write-queue, so that from the point of view of
the vfs reader the ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: sql-stmt
References: delete-stmt expr insert-stmt select-stmt update-stmt
See also: lang_createtrigger.html
create-view-stmt:
Used by: sql ...
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... Accessibility
SQLite database content can be viewed using a wide variety
third-party tools.
Content stored in an SQLite database is more likely to be
recoverable decades in the future, long after all traces of
the original application have been ...
|
|
SQLite Keywords
(lang_keywords.html)
... 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-11-26 14:56:19 UTC
|
|
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 ...
|
|
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 ...
|
Page generated by FTS5 in about 118.70 ms.