Index: pages/affcase1.in ================================================================== --- pages/affcase1.in +++ pages/affcase1.in @@ -7,11 +7,11 @@
Suppose the [http://en.wikipedia.org/wiki/OpenDocument|OpenDocument] file format, -and specifically the "ODP" OpenDocument Presentation format, where +and specifically the "ODP" OpenDocument Presentation format, were built around SQLite. Benefits would include:
The following are examples of disabling the built-in protection mechanisms of SQLite:
Setting [PRAGMA synchronous=OFF] can cause the database to -go corrupt if there is an operating-system crass or power failure, +go corrupt if there is an operating-system crash or power failure, though this setting is safe from damage due to application crashes.
Changing the [PRAGMA schema_version] while other database connections are open. Index: pages/inmemorydb.in ================================================================== --- pages/inmemorydb.in +++ pages/inmemorydb.in @@ -116,13 +116,14 @@ databases each have their own private database. Temporary databases are automatically deleted when the connection that created them closes.
Even though a disk file is allocated for each temporary database, in practice the temporary database usually resides in the in-memory pager -cache and hence is very little difference between a pure in-memory database +cache and hence there is very little difference between a pure in-memory +database created by ":memory:" and a temporary database created by an empty filename. -The sole difference is that a ":memory:" database must remain in memory +The only difference is that a ":memory:" database must remain in memory at all times whereas parts of a temporary database might be flushed to disk if database becomes large or if SQLite comes under memory pressure.
The previous paragraphs describe the behavior of temporary databases under the default SQLite configuration. An application can use the Index: pages/json1.in ================================================================== --- pages/json1.in +++ pages/json1.in @@ -21,11 +21,11 @@ set fx [string trim $fx] set hlink "" regsub -all {^json\(} $fx "${hlink}json(" fx regsub -all {(json_[a-z_]+)} $fx "$hlink\\1" fx regsub -all {(value[1-9]?|path|label[1-9]?)} $fx "\\1" fx - regsub -all {\((json)} $fx "(\\1" fx + regsub -all {(json[1-9]?|name)} $fx "\\1" fx hd_puts "$fx\n" # hd_puts "[string trim $desc]\n" hd_puts "
Paid support options and products are provided by Index: pages/vfs.in ================================================================== --- pages/vfs.in +++ pages/vfs.in @@ -191,11 +191,11 @@
[http://www.sqlite.org/src/doc/trunk/src/test_quota.c | test_quota.c] - This file implements a shim called "quota" that enforces cumulative file size limits on a collection of database files. An auxiliary -interface is used to define "quote groups". A quota group is a +interface is used to define "quota groups". A quota group is a set of files (database files, journals, and temporary files) whose names all match a [GLOB] pattern. The sum of the sizes of all files in each quota group is tracked, and if that sum exceeds a threshold defined for the quota group, a callback function is invoked. That callback can either increase the threshold or cause the operation Index: search/search.tcl ================================================================== --- search/search.tcl +++ search/search.tcl @@ -402,10 +402,11 @@ return $ret } proc main {} { global A + set A(s) d cgi_parse_args # If "env=1" is specified, dump the environment variables instead # of running any search. if {[info exists ::A(env)]} { return [cgi_env_dump] }