Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Temporary Files Used By SQLite
(tempfiles.html)
2.5. Statement Journal Files
... are no other active statements on the same database connection then
no statement journal is created since the ordinary
rollback journal can be used instead.
The statement journal is also omitted if an alternative
conflict resolution algorithm is
used. For ...
|
|
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 tbl_ai AFTER INSERT ON tbl BEGIN
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
CREATE TRIGGER tbl_ad AFTER DELETE ON tbl BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old ...
|
Page generated by FTS5 in about 27.68 ms.