Small. Fast. Reliable.
Choose any three.
Choose any three.
|
What If OpenDocument Used SQLite?
(affcase1.html)
... Incremental update is hard.
It is difficult to update individual entries in a ZIP archive.
It is especially difficult to update individual entries in a ZIP
archive in a way that does not destroy
the entire document if the computer ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.27. The preupdate method
This method either registers a callback routine that is invoked just
before each row is modified by an UPDATE, INSERT, or DELETE statement,
or may perform certain operations related to the impending update.
To register or remove a preupdate callback ...
|
|
Internal Versus External BLOBs
(intern-v-extern-blob.html)
... 10000 BLOBs for the 10K size and
so forth.) SQLite version 3.7.8 (2011-09-19) was used.
Update: New measurements for SQLite version 3.19.0
(2017-05-22) show that SQLite is about
35% faster than direct ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... And an SQLite archive features incremental and atomic updating
and the ability to store much richer metadata.
Fossil version 2.5 and later offers
SQLite Archive files as a download format, in addition
to traditional tarball and ZIP archive.
The ...
|
|
NULL Handling in SQLite
(nulls.html)
... Since this document was originally written some of the database engines
tested have been updated and users have been kind enough to send in
corrections to the chart below. The original data showed a wide variety
of behaviors, but over ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... How INDEXED BY Works
The INDEXED BY phrase forces the SQLite query planner to use a
particular named index on a DELETE, SELECT, or UPDATE statement.
The INDEXED BY phrase is an SQLite extension and
is not portable to other ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... Pure pile-of-files formats can also
do incremental updates to some extent, though the granularity of writes is
usually larger with pile-of-file formats (a single file) than with SQLite
(a single page).
SQLite also supports continuous update ...
|
|
Memory-Mapped I/O
(mmap.html)
Memory-Mapped I/O
The default mechanism by which SQLite accesses and updates database disk
files is the xRead() and xWrite() methods of the
sqlite3_io_methods VFS object. These methods are typically implemented as
"read()" and "write()" system calls which cause ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The R-Tree extension returns this result code when an attempt is made
to update the R-Tree while another prepared statement is actively reading
the R-Tree. The update cannot proceed because any change to an R-Tree
might ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.13. The xUpdate Method
... argc > 1 argv[0] ≠ NULL argv[0] = argv[1]
UPDATE:
The row with rowid or PRIMARY KEY argv[0] is updated with new values
in argv[2] and following parameters.
argc > 1 argv[0] ≠ NULL argv ...
|
Page generated by FTS5 in about 138.82 ms.