Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the "changes" log for the next release. Fix all hyperlinks. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
4643d06dfeace16508d26f5c87696b28 |
User & Date: | drh 2011-11-17 18:03:57.084 |
Context
2011-11-24
| ||
19:40 | Fix typos and a mixup over BLOB and text serial types in the file format document. (check-in: 3b3c197a19 user: drh tags: trunk) | |
2011-11-17
| ||
18:03 | Update the "changes" log for the next release. Fix all hyperlinks. (check-in: 4643d06dfe user: drh tags: trunk) | |
14:59 | Fix a documentation error pointed out by Richard Godbee on the mailing list. (check-in: 2112591627 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
45 46 47 48 49 50 51 52 53 54 55 56 57 58 | chng {2012 February 1 (3.7.10)} { <li>The default [schema format number] is changed from 1 to 4. This means that, unless the [PRAGMA legacy_file_format | PRAGMA legacy_file_format=ON] statement is run, newly created database files will be unreadable by version of SQLite prior to 3.3.0 (2006-01-10). It also means that the [descending indices] are enabled by default. } chng {2011 November 1 (3.7.9)} { <li>If a search token (on the right-hand side of the MATCH operator) in [FTS4] begins with "^" then that token must be the first in its field of the document. <b>** Potentially Incompatible Change **</b> <li>Added options [SQLITE_DBSTATUS_CACHE_HIT] and [SQLITE_DBSTATUS_CACHE_MISS] | > > > > > > > > > > > > > > > > | 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 | chng {2012 February 1 (3.7.10)} { <li>The default [schema format number] is changed from 1 to 4. This means that, unless the [PRAGMA legacy_file_format | PRAGMA legacy_file_format=ON] statement is run, newly created database files will be unreadable by version of SQLite prior to 3.3.0 (2006-01-10). It also means that the [descending indices] are enabled by default. <li>The sqlite3_pcache_methods structure and the [SQLITE_CONFIG_PCACHE] and [SQLITE_CONFIG_GETPCACHE] configuration parameters are deprecated. They are replaced by a new [sqlite3_pcache_methods2] structure and [SQLITE_CONFIG_PCACHE2] and [SQLITE_CONFIG_GETPCACHE2] configuration parameters. <li>Added the [sqlite3_db_release_memory()] interface and the [shrink_memory pragma]. <li>Added the [sqlite3_db_filename()] interface. <li>Enhance the query planner to support index queries with range constraints on the rowid. <li>Enhanced the windows [VFS] so that all system calls can be overridden using the xSetSystemCall interface. <li>Updated the "unix-dotfile" [VFS] to use locking directories with mkdir() and rmdir() instead of locking files with open() and unlink(). <li>Fix the unix [VFS] to be tolerate of read() system calls that return less then the full number of requested bytes. } chng {2011 November 1 (3.7.9)} { <li>If a search token (on the right-hand side of the MATCH operator) in [FTS4] begins with "^" then that token must be the first in its field of the document. <b>** Potentially Incompatible Change **</b> <li>Added options [SQLITE_DBSTATUS_CACHE_HIT] and [SQLITE_DBSTATUS_CACHE_MISS] |
︙ | ︙ | |||
573 574 575 576 577 578 579 | <li>Two other very minor bug fixes</li> } chng {2008 Nov 19 (3.6.6)} { <li>Fix a #define that prevented [memsys5] from compiling</li> <li>Fix a problem in the virtual table commit mechanism that was causing a crash in FTS3. [Ticket #3497].</li> | | | 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 | <li>Two other very minor bug fixes</li> } chng {2008 Nov 19 (3.6.6)} { <li>Fix a #define that prevented [memsys5] from compiling</li> <li>Fix a problem in the virtual table commit mechanism that was causing a crash in FTS3. [Ticket #3497].</li> <li>Add the [sqlite3_pcache_methods2 | application-defined page cache]</li> <li>Added built-in support for VxWorks</li> } chng {2008 Nov 12 (3.6.5)} { <li>Add the MEMORY option to the [journal_mode pragma].</li> <li>Added the [sqlite3_db_mutex()] interface.</li> <li>Added the [SQLITE_OMIT_TRUNCATE_OPTIMIZATION] compile-time option.</li> |
︙ | ︙ |
Changes to pages/oldnews.in.
︙ | ︙ | |||
258 259 260 261 262 263 264 | } newsitem {2008-Nov-19} {Version 3.6.6} { SQLite [version 3.6.5] is released. This is a quick turn-around release that fixes a bug in virtual tables and FTS3 that snuck into [version 3.6.5]. This release also adds the new | | | 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 | } newsitem {2008-Nov-19} {Version 3.6.6} { SQLite [version 3.6.5] is released. This is a quick turn-around release that fixes a bug in virtual tables and FTS3 that snuck into [version 3.6.5]. This release also adds the new application-defined page cache mechanism. } newsitem {2008-Nov-12} {Version 3.6.5} { SQLite [version 3.6.5] is released. There are various minor feature enhancements and numerous obscure bug fixes. The [version 3.6.5|change log] contains the details. Upgrading is optional. |
︙ | ︙ |
Changes to pages/pragma.in.
︙ | ︙ | |||
181 182 183 184 185 186 187 | Pragma cache_size { <p>^(<b>PRAGMA cache_size; <br>PRAGMA cache_size = </b><i>Number-of-pages</i><b>;</b></p> <p>Query or change the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file.)^ Whether or not this suggestion is honored is at the discretion of the | | | 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 | Pragma cache_size { <p>^(<b>PRAGMA cache_size; <br>PRAGMA cache_size = </b><i>Number-of-pages</i><b>;</b></p> <p>Query or change the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file.)^ Whether or not this suggestion is honored is at the discretion of the [sqlite3_pcache_methods2 | Application Defined Page Cache]. Alternative application-defined page cache implementations may choose to interpret the suggested cache size in different ways or to ignore it all together. ^The default suggested cache size is 2000.</p> <p>^The suggested cache size is set to the absolute value of the <i>Number-of-pages</i> argument given to this pragma.</p> |
︙ | ︙ | |||
735 736 737 738 739 740 741 742 743 744 745 746 747 748 | DISCLAIMER <p>Query or change the short-column-names flag. This flag affects the way SQLite names columns of data returned by [SELECT] statements. See the [full_column_names] pragma for full details. </p> } Pragma synchronous { <p>^(<b>PRAGMA synchronous; <br>PRAGMA synchronous = </b> <i>0 | OFF | 1 | NORMAL | 2 | FULL</i><b>;</b></p> <p>Query or change the setting of the "synchronous" flag.)^ | > > > > > > > > > | 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 | DISCLAIMER <p>Query or change the short-column-names flag. This flag affects the way SQLite names columns of data returned by [SELECT] statements. See the [full_column_names] pragma for full details. </p> } Pragma shrink_memory { <p><b>PRAGMA shrink_memory</b></p> <p>^This pragma causes the database connection on which it is invoked to free up as much memory as it can, by calling [sqlite3_db_release_memory()]. </p> } Pragma synchronous { <p>^(<b>PRAGMA synchronous; <br>PRAGMA synchronous = </b> <i>0 | OFF | 1 | NORMAL | 2 | FULL</i><b>;</b></p> <p>Query or change the setting of the "synchronous" flag.)^ |
︙ | ︙ |