/ Check-in [6537b571]
Login

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

Overview
Comment:Documentation updates in preparation for the release of 3.3.3 stable. (CVS 3038)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:6537b5713a9541ec5712ae2564a801a07f93f4c8
User & Date: drh 2006-01-30 16:20:30
Context
2006-01-30
22:12
Clarify that the nBytes parameter to sqlite3_prepare is always the number of bytes and never the number of characters. Ticket #1646. (CVS 3039) check-in: 8efc8c57 user: drh tags: trunk
16:20
Documentation updates in preparation for the release of 3.3.3 stable. (CVS 3038) check-in: 6537b571 user: drh tags: trunk
15:41
Add a couple of extra test cases for #1644. (CVS 3037) check-in: e10d229f user: danielk1977 tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to VERSION.

     1         -3.3.2
            1  +3.3.3

Changes to www/changes.tcl.

    20     20     if {[regexp {\(([0-9.]+)\)} $date all vers]} {
    21     21       set label [string map {. _} $vers]
    22     22       puts "<A NAME=\"version_$label\">"
    23     23     }
    24     24     puts "<DT><B>$date</B></DT>"
    25     25     puts "<DD><P><UL>$desc</UL></P></DD>"
    26     26   }
           27  +
           28  +chng {2006 January 30 (3.3.3 beta)} {
           29  +<li>Minor bug fixes only.</li>
           30  +}
    27     31   
    28     32   chng {2006 January 24 (3.3.2 beta)} {
    29     33   <li>Bug fixes and speed improvements.  Improved test coverage.</li>
    30     34   <li>Changes to the OS-layer interface: mutexes must now be recursive.</li>
    31     35   <li>Discontinue the use of thread-specific data for out-of-memory
    32     36   exception handling</li>
    33     37   }

Changes to www/docs.tcl.

     1      1   # This script generates the "docs.html" page that describes various
     2      2   # sources of documentation available for SQLite.
     3      3   #
     4         -set rcsid {$Id: docs.tcl,v 1.13 2005/09/08 11:04:57 drh Exp $}
            4  +set rcsid {$Id: docs.tcl,v 1.14 2006/01/30 16:20:30 drh Exp $}
     5      5   source common.tcl
     6      6   header {SQLite Documentation}
     7      7   puts {
     8      8   <h2>Available Documentation</h2>
     9      9   <table width="100%" cellpadding="5">
    10     10   }
    11     11   
................................................................................
    37     37   doc {SQL Syntax} {lang.html} {
    38     38     This document describes the SQL language that is understood by
    39     39     SQLite.  
    40     40   }
    41     41   doc {Version 3 C/C++ API<br>Reference} {capi3ref.html} {
    42     42     This document describes each API function separately.
    43     43   }
           44  +doc {Sharing Cache Mode} {sharedcache.html} {
           45  +  Version 3.3.0 and later supports the ability for two or more
           46  +  database connections to share the same page and schema cache.
           47  +  This feature is useful for certain specialized applications.
           48  +}
    44     49   doc {Tcl API} {tclsqlite.html} {
    45     50     A description of the TCL interface bindings for SQLite.
    46     51   }
    47     52   
    48     53   doc {Pragma commands} {pragma.html} {
    49     54     This document describes SQLite performance tuning options and other 
    50     55     special purpose database commands.

Changes to www/index.tcl.

    61     61   
    62     62   proc newsitem {date title text} {
    63     63     puts "<h3>$date - $title</h3>"
    64     64     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    65     65     puts "<p>$txt</p>"
    66     66     puts "<hr width=\"50%\">"
    67     67   }
           68  +
           69  +newsitem {2006-Jan-30} {Version 3.3.3 stable} {
           70  +  There have been no major problems discovered in version 3.3.2, so
           71  +  we hereby declare the new APIs and language features to be stable
           72  +  and supported.
           73  +}
    68     74   
    69     75   newsitem {2006-Jan-24} {Version 3.3.2 beta} {
    70     76     More bug fixes and performance improvements as we move closer to
    71     77     a production-ready version 3.3.x.
    72     78   }
    73     79   
    74     80   newsitem {2006-Jan-16} {Version 3.3.1 alpha} {
................................................................................
   104    110     These versions contain one-line changes to 3.2.7 and 2.8.16 to fix a bug
   105    111     that has been present since March of 2002 and version 2.4.0.
   106    112     That bug might possibly cause database corruption if a large INSERT or
   107    113     UPDATE statement within a multi-statement transaction fails due to a
   108    114     uniqueness constraint but the containing transaction commits.
   109    115   }
   110    116   
   111         -newsitem {2005-Sep-24} {Version 3.2.7} {
   112         -  This version fixes several minor and obscure bugs.
   113         -  Upgrade only if you are having problems.
   114         -}
   115         -
   116         -newsitem {2005-Sep-16} {Version 3.2.6 - Critical Bug Fix} {
   117         -  This version fixes a bug that can result in database
   118         -  corruption if a VACUUM of a 1 gibibyte or larger database fails
   119         -  (perhaps do to running out of disk space or an unexpected power loss)
   120         -  and is later rolled back.
   121         -  <p>
   122         -  Also in this release:
   123         -  The ORDER BY and GROUP BY processing was rewritten to use less memory.
   124         -  Support for COUNT(DISTINCT) was added.  The LIKE operator can now be
   125         -  used by the optimizer on columns with COLLATE NOCASE.
   126         -}
   127         -
   128         -newsitem {2005-Aug-27} {Version 3.2.5} {
   129         -  This release fixes a few more lingering bugs in the new code.
   130         -  We expect that this release will be stable and ready for production use.
   131         -}
   132         -
   133         -newsitem {2005-Aug-24} {Version 3.2.4} {
   134         -  This release fixes a bug in the new optimizer that can lead to segfaults
   135         -  when parsing very complex WHERE clauses.
   136         -}
   137         -
   138         -newsitem {2005-Aug-21} {Version 3.2.3} {
   139         -  This release adds the <a href="lang_analyze.html">ANALYZE</a> command,
   140         -  the <a href="lang_expr.html">CAST</a> operator, and many
   141         -  very substantial improvements to the query optimizer.  See the
   142         -  <a href="changes.html#version_3_2_3">change log</a> for additional
   143         -  information.
   144         -}
   145         -
   146         -newsitem {2005-Aug-2} {2005 Open Source Award for SQLite} {
   147         -  SQLite and its primary author D. Richard Hipp have been honored with
   148         -  a <a href="http://osdir.com/Article6677.phtml">2005 Open Source
   149         -  Award</a> from Google and O'Reilly.<br clear="right">
   150         -}
   151         -
   152    117   
   153    118   puts {
   154    119   <p align="right"><a href="oldnews.html">Old news...</a></p>
   155    120   </td></tr></table>
   156    121   }
   157         -footer {$Id: index.tcl,v 1.132 2006/01/23 23:53:17 drh Exp $}
          122  +footer {$Id: index.tcl,v 1.133 2006/01/30 16:20:30 drh Exp $}

Changes to www/oldnews.tcl.

     4      4   
     5      5   proc newsitem {date title text} {
     6      6     puts "<h3>$date - $title</h3>"
     7      7     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
     8      8     puts "<p>$txt</p>"
     9      9     puts "<hr width=\"50%\">"
    10     10   }
           11  +
           12  +newsitem {2005-Sep-24} {Version 3.2.7} {
           13  +  This version fixes several minor and obscure bugs.
           14  +  Upgrade only if you are having problems.
           15  +}
           16  +
           17  +newsitem {2005-Sep-16} {Version 3.2.6 - Critical Bug Fix} {
           18  +  This version fixes a bug that can result in database
           19  +  corruption if a VACUUM of a 1 gibibyte or larger database fails
           20  +  (perhaps do to running out of disk space or an unexpected power loss)
           21  +  and is later rolled back.
           22  +  <p>
           23  +  Also in this release:
           24  +  The ORDER BY and GROUP BY processing was rewritten to use less memory.
           25  +  Support for COUNT(DISTINCT) was added.  The LIKE operator can now be
           26  +  used by the optimizer on columns with COLLATE NOCASE.
           27  +}
           28  +
           29  +newsitem {2005-Aug-27} {Version 3.2.5} {
           30  +  This release fixes a few more lingering bugs in the new code.
           31  +  We expect that this release will be stable and ready for production use.
           32  +}
           33  +
           34  +newsitem {2005-Aug-24} {Version 3.2.4} {
           35  +  This release fixes a bug in the new optimizer that can lead to segfaults
           36  +  when parsing very complex WHERE clauses.
           37  +}
           38  +
           39  +newsitem {2005-Aug-21} {Version 3.2.3} {
           40  +  This release adds the <a href="lang_analyze.html">ANALYZE</a> command,
           41  +  the <a href="lang_expr.html">CAST</a> operator, and many
           42  +  very substantial improvements to the query optimizer.  See the
           43  +  <a href="changes.html#version_3_2_3">change log</a> for additional
           44  +  information.
           45  +}
           46  +
           47  +newsitem {2005-Aug-2} {2005 Open Source Award for SQLite} {
           48  +  SQLite and its primary author D. Richard Hipp have been honored with
           49  +  a <a href="http://osdir.com/Article6677.phtml">2005 Open Source
           50  +  Award</a> from Google and O'Reilly.<br clear="right">
           51  +}
           52  +
    11     53   
    12     54   newsitem {2005-Jun-13} {Version 3.2.2} {
    13     55     This release includes numerous minor bug fixes, speed improvements,
    14     56     and code size reductions.  There is no reason to upgrade unless you
    15     57     are having problems or unless you just want to.
    16     58   }
    17     59   
................................................................................
   245    287     changes to both the C-language API and the underlying file format
   246    288     that will enable SQLite to better support internationalization.
   247    289     The first beta is schedule for release on 2004-July-01.
   248    290   
   249    291     Plans are to continue to support SQLite version 2.8 with
   250    292     bug fixes.  But all new development will occur in version 3.0.
   251    293   }
   252         -footer {$Id: oldnews.tcl,v 1.13 2005/08/27 17:06:16 drh Exp $}
          294  +footer {$Id: oldnews.tcl,v 1.14 2006/01/30 16:20:30 drh Exp $}

Added www/shared.gif.

cannot compute difference between binary files

Changes to www/sharedcache.tcl.

    53     53   or more database connections using a shared-cache appear as a single 
    54     54   connection. The locking protocol used to arbitrate between multiple 
    55     55   shared-caches or regular database users is described elsewhere.
    56     56   </p>
    57     57   
    58     58   <table style="margin:auto">
    59     59   <tr><td>
    60         -<pre>
           60  +<img src="shared.gif">
           61  +<!-- <pre>
    61     62               +--------------+      +--------------+
    62     63               | Connection 2 |      | Connection 3 |
    63     64               +--------------+      +--------------+
    64     65                            |          |
    65     66                            V          V
    66     67   +--------------+       +--------------+
    67     68   | Connection 1 |       | Shared cache |
    68     69   +--------------+       +--------------+
    69     70               |            |
    70     71               V            V
    71     72             +----------------+
    72     73             |    Database    |
    73     74             +----------------+
    74         -</pre>
           75  +</pre> -->
    75     76   </table>
    76     77   <p style="font-style:italic;text-align:center">Figure 1</p>
    77     78   
    78     79   <p>Figure 1 depicts an example runtime configuration where three 
    79     80   database connections have been established. Connection 1 is a normal
    80     81   SQLite database connection. Connections 2 and 3 share a cache (and so must
    81     82   have been established by the same process thread). The normal locking