Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Older News
(oldnews.html)
... That bug might possibly cause database corruption if a large INSERT or
UPDATE statement within a multi-statement transaction fails due to a
uniqueness constraint but the containing transaction commits.
2005-09-24 - Version 3.2.7
This version fixes ...
|
|
The SQLite R*Tree Module
(rtree.html)
... This means, for example, that if you try to give a column a
type affinity or add a constraint such as UNIQUE or NOT NULL or DEFAULT to
a column, those extra tokens are accepted as valid, but they do ...
|
|
Compile-time Options
(compile.html)
4. Options To Set Default Parameter Values
... SQLITE_DEFAULT_FOREIGN_KEYS=<0 or 1>
This macro determines whether enforcement of
foreign key constraints is enabled or disabled by default for
new database connections. Each database connection can always turn
enforcement of foreign key constraints on and off and ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... database file is locked */
#define SQLITE_LOCKED 6 /* A table in the database is locked */
#define SQLITE_NOMEM 7 /* A malloc() failed */
#define SQLITE_READONLY 8 /* Attempt to write a readonly database */
#define SQLITE_INTERRUPT 9 /* Operation terminated by sqlite_interrupt() */
#define SQLITE_IOERR 10 /* Some ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.5. Statement Journal Files
... UPDATE OR FAIL ...
UPDATE OR IGNORE ...
UPDATE OR REPLACE ...
UPDATE OR ROLLBACK ...
INSERT OR FAIL ...
INSERT OR IGNORE ...
INSERT OR REPLACE ...
INSERT OR ROLLBACK ...
REPLACE INTO ....
The statement journal is given a randomized name, not necessarily
in the same directory ...
|
|
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_FKEY
This option is used to enable or disable the enforcement of
foreign key constraints. This is the same setting that is
enabled or disabled by the PRAGMA foreign_keys statement.
The first argument is an integer which is 0 to ...
|
|
Implementation Limits For SQLite
(limits.html)
... And
some built-in functions such as hex() might fail well before that
point. In security-sensitive applications it is best not to
try to increase the maximum string and blob length. In fact,
you might do well to lower ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
... Rigid type enforcement prevents data pollution
Some people contend that if you have rigorous constraints on the
schema, and especially strict enforcement of column datatypes, this
will help prevent incorrect data from being added to the database.
This is not ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... NULL is returned if the open fails. If the open fails,
the xDlError method can be used to obtain a text error message.
The message is written into the zErrMsg buffer of the third parameter
which is at least nByte ...
|
|
Window Functions
(windowfunctions.html)
... show
join-constraint:
show
join-operator:
show
ordering-term:
show
result-column:
show
table-or-subquery:
show
type-name:
show
signed-number:
show
filter-clause:
hide
window-defn:
hide
frame-spec:
hide
ordering-term:
show
Unlike ordinary functions, window functions ...
|
Page generated by FTS5 in about 89.54 ms.