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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 4643d06dfeace16508d26f5c87696b284bc3c9c3
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
Unified Diff Ignore Whitespace Patch
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 "&#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]







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







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 "&#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]
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
<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>







|







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
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

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>







|







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