Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The WITH Clause
(lang_with.html)
... In the diagram above, initial-select means one or more
non-recursive SELECT statements and recursive-select means
one or more recursive SELECT statements. The most common case is for there
to be exactly one initial-select and exactly one ...
|
|
SQLite Older News
(oldnews.html)
... The virtual table interface has been enhanced to
support SAVEPOINT and ON CONFLICT clause processing, and the built-in
RTREE and FTS3/FTS4 have been augmented to take advantage of
the new capability. This means, for example, that it is ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
8.3. I/O error while obtaining a lock leads to corruption
... is already holding a conflicting lock) then no
corruption will ever occur. We are not aware of any operating systems that
will fail with an I/O error while attempting to get a file lock on shared
memory. So this ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... than 100 to avoid conflicts.
The xSectorSize returns the "sector size" of the underlying
non-volatile media. A "sector" is defined as the smallest unit of
storage that can be written without disturbing adjacent storage.
On a disk drive the ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... Partially completed
changes will be rolled back and the database will be restored to its
original state (unless an alternative recovery algorithm is selected using
an ON CONFLICT clause in the SQL being executed.) The effect is the
same as ...
|
|
SQLite FTS5 Extension
(fts5.html)
4.4.3. External Content Tables
... CREATE TRIGGER t1_ai AFTER INSERT ON t1 BEGIN
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
CREATE TRIGGER t1_ad AFTER DELETE ON t1 BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old ...
|
Page generated by FTS5 in about 44.35 ms.