C API: Virtual Table Configuration Options
(c3ref/c_vtab_constraint_support.html)
SQLITE_VTAB_CONSTRAINT_SUPPORT, SQLITE_VTAB_INNOCUOUS, SQLITE_VTAB_DIRECTONLY, SQLITE_VTAB_USES_ALL_SCHEMAS
... If the ON CONFLICT mode is ABORT, FAIL, IGNORE or ROLLBACK, SQLite
is able to roll back a statement or database transaction, and abandon
or continue processing the current SQL statement as appropriate.
If the ON CONFLICT mode is REPLACE ...
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... It exists, and
Its size is greater than 512 bytes, and
The journal header is non-zero and well-formed, and
Its super-journal exists or the super-journal name is an
empty string, and
There is no RESERVED lock ...
|
How SQLite Works
(howitworks.html)
2.2. Compiling SQLite Programs
... A language keyword like "SELECT" or "UPDATE".
An identifier for a table or column or variable.
Punctuation characters like "," or "==" or ";".
Literal values: numeric or string constants.
Whitespace or comments.
Whitespace and comment tokens are discarded. All other tokens
are ...
|
Appropriate Uses For SQLite
(whentouse.html)
... An SQLite database facilitates data transfer between systems even
when the endpoints have different word sizes and/or byte orders.
The data can be a complex mix of large binary blobs, text, and small
numeric or boolean values. The data ...
|
C API: Checkpoint a database
(c3ref/wal_checkpoint_v2.html)
sqlite3_wal_checkpoint_v2()
... If database zDb is the name of an attached database that is not in WAL
mode, SQLITE_OK is returned and both *pnLog and *pnCkpt set to -1. If
zDb is not NULL (or a zero length string) and is not ...
|
Date And Time Functions
(lang_datefunc.html)
... The main reasons for providing functions other than strftime() are
for convenience and for efficiency. The julianday() and unixepoch()
functions return real and integer values respectively, and do not
incur the format conversion costs or inexactitude resulting from use
of ...
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... SQLite will use the xCurrentTimeInt64() method to get the current
date and time if that method is available (if iVersion is 2 or
greater and the function pointer is not NULL) and will fall back
to xCurrentTime() if xCurrentTimeInt64() is ...
|
JSON Functions And Operators
(json1.html)
4.9. The -> and ->> operators
... The SQLite implementation of -> and ->> strives to be
compatible with both MySQL and PostgreSQL.
The -> and ->> operators take a JSON string or JSONB blob
as their left operand and a PATH expression or object field
label or array index as ...
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
This option is used to enable or disable the sqlite3_load_extension()
interface independently of the load_extension() SQL function.
The sqlite3_enable_load_extension() API enables or disables both the
C-API sqlite3_load_extension() and the SQL function load_extension().
There should be two additional arguments ...
|
Defense Against The Dark Arts
(security.html)
1.2. Untrusted SQLite Database Files
... Disable the surreptitious use of custom SQL functions and virtual tables
by setting the SQLITE_DIRECTONLY flag on all custom SQL functions and
the SQLITE_VTAB_DIRECTONLY flag on all custom virtual tables.
If the application does not use triggers or views, consider ...
|
Page generated by FTS5 in about 281.23 ms.