Documentation Source Text

Check-in [4643d06dfe]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the "changes" log for the next release. Fix all hyperlinks.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 4643d06dfeace16508d26f5c87696b284bc3c9c3
User & Date: drh 2011-11-17 18:03:57
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

45
46
47
48
49
50
51
















52
53
54
55
56
57
58
...
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
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 "&#94;" 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]
................................................................................
<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_methods | 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>







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







 







|







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
...
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
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 "&#94;" 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]
................................................................................
<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
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
  [sqlite3_pcache_methods | 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.







|







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
188
189
190
191
192
193
194
195
...
735
736
737
738
739
740
741









742
743
744
745
746
747
748

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_methods | 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>
................................................................................
    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.)^







|







 







>
>
>
>
>
>
>
>
>







181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
...
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757

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>
................................................................................
    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.)^