Documentation Source Text

Check-in [e3715164fb]
Login

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

Overview
Comment:Website updates in preparation for the 3.6.14 release.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e3715164fb70b8632ee860d9a1f6d50b6e3d3db7
User & Date: drh 2009-05-05 18:23:08
Context
2009-05-06
17:24
Add the asyncvfs.html documentation file. Prepare for the 3.6.14 release. check-in: 81cdc75444 user: drh tags: trunk
2009-05-05
18:23
Website updates in preparation for the 3.6.14 release. check-in: e3715164fb user: drh tags: trunk
2009-05-01
10:45
Add text describing file locking and the database header cookies (file and schema versions) to fileformat.html. check-in: ca6db0c14f user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    37     37         <a href="http://www.sqlite.org/cvstrac/timeline">
    38     38         http://www.sqlite.org/cvstrac/timeline</a>.</p>
    39     39       }
    40     40       hd_close_aux
    41     41       hd_enable_main 1
    42     42     }
    43     43   }
           44  +
           45  +chng {2009 May 8 (3.6.14)} {
           46  +<li>Added an optional asynchronous I/O VFS.</li>
           47  +<li>Enhanced the query optimizer so that [virtual tables] are able to
           48  +    make use of OR and IN operators in the WHERE clause.</li>
           49  +<li>Speed improvements in the btree and pager layers.</li>
           50  +<li>Added the [SQLITE_HAVE_ISNAN] compile-time option which will cause
           51  +    the isnan() function from the standard math library to be used instead
           52  +    of SQLite's own home-brew NaN checker.</li>
           53  +<li>Countless minor bug fixes, documentation improvements, new and
           54  +    improved test cases, and code simplifications and cleanups.</p>
           55  +}
    44     56   
    45     57   chng {2009 April 13 (3.6.13)} {
    46     58   <li>Fix a bug in [version 3.6.12] that causes a segfault when running
    47     59       a count(*) on the sqlite_master table of an empty database. Ticket #3774.
    48     60   <li>Fix a bug in [version 3.6.12] that causes a segfault that when 
    49     61       inserting into a table using a DEFAULT value where there is a 
    50     62       function as part of the DEFAULT value expression.  Ticket #3791.

Changes to pages/fileformat.in.

    85     85   
    86     86   proc sort_by_length {lhs rhs} {
    87     87     return [expr [string length $lhs] - [string length $rhs]]
    88     88   }
    89     89   
    90     90   proc FixReferences {body} {
    91     91     foreach E [lsort -decr -index 1 -command sort_by_length $::Glossary] {
    92         -  puts $E
           92  +    # puts $E
    93     93       foreach {term anchor} $E {}
    94     94       set re [string map {" " [-[:space:]]+} $term]
    95     95       set re "${re}s?"
    96     96       set body [regsub -all -nocase $re $body "<a class=defnlink href=\"#$anchor\">\\0</a>"]
    97     97       # set body [regsub -all -nocase {(defnlink[^<]*) } $body "\\1&20;"]
    98     98     }
    99     99   

Changes to pages/index.in.

    76     76   
    77     77   </td>
    78     78   <td width="20"></td><td bgcolor="#80a796" width="1"></td><td width="20"></td>
    79     79   <td valign="top">
    80     80   <h3>Current Status</h3>
    81     81   
    82     82   <p><ul>
    83         -<li><a href="releaselog/3_6_13.html">Version 3.6.13</a>
           83  +<li><a href="releaselog/3_6_14.html">Version 3.6.14</a>
    84     84   of SQLite is recommended for all new development.  Upgrading from
    85         -version 3.6.12 is optional.  Upgrading from versions 3.6.11 and
           85  +version 3.6.12 or 3.6.13 is optional.  Upgrading from versions 3.6.11 and
    86     86   earlier is recommended.</li>
    87     87   </ul></p>
    88     88   
    89     89   <h3>Common Links</h3>
    90     90   
    91     91   <p><ul>
    92     92   <li> <a href="features.html">Features</a> </li>

Changes to pages/news.in.

    14     14     hd_puts "<h3>$date - $title</h3>"
    15     15     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    16     16     regsub -all {[Tt]icket #(\d+)} $txt \
    17     17         {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
    18     18     hd_resolve "<p>$txt</p>"
    19     19     hd_puts "<hr width=\"50%\">"
    20     20   }
           21  +
           22  +newsitem {2009-Apr-14} {Version 3.6.14} {
           23  +  SQLite [version 3.6.14] provides new performance enhancements in
           24  +  the btree and pager layers and in the query optimizer.  Certain
           25  +  workloads can be as much as twice as fast as the previous release,
           26  +  though 10% faster is a more typical result.
           27  +
           28  +  Queries against [virtual tables] that contain OR and IN operators
           29  +  in the WHERE clause are no able to use indexing.
           30  +
           31  +  A new optional asychronous I/O [sqlite3_vfs | VFS] is available for
           32  +  unix and windows.  The asynchronous VFS gives the illusion of faster
           33  +  response time by pushing slow write operations into a background thread.
           34  +  The tradeoff for faster response time is that more memory is required
           35  +  (to hold the content of the pending writes) and if a power failure or
           36  +  program crash occurs, some transactions that appeared to have committed
           37  +  might end up being rolled back upon restart.
           38  +
           39  +  This release also contains many minor bug fixes, documentation enhancements,
           40  +  new test cases, and cleanups and simplifications to the source code.
           41  +
           42  +  There is no compelling reason to upgrade from versions 3.6.12 or
           43  +  3.6.13 if those prior versions are working.  Though many users may
           44  +  benefit from the improved performance.
           45  +}
    21     46   
    22     47   newsitem {2009-Apr-14} {Version 3.6.13} {
    23     48     SQLite [version 3.6.13] fixes several minor issues that appeared
    24     49     in previous version, including Ticket #3774, #3791, and #3777.
    25     50     This is a bug-fix release only.   There are no new features or
    26     51     enhancements.  
    27     52   }