sqlite3/www/oldnews.tcl

   1 #!/usr/bin/tclsh
   2 source common.tcl
   3 header {SQLite Older News}
   4
   5 proc newsitem {date title text} {
   6   puts "<h3>$date - $title</h3>"
   7   regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
   8   puts "<p>$txt</p>"
   9   puts "<hr width=\"50%\">"
  10 }
  11
  12 newsitem {2005-Feb-15} {Versions 2.8.16 and 3.1.2 Released} {
  13   A critical bug in the VACUUM command that can lead to database
  14   corruption has been fixed in both the 2.x branch and the main
  15   3.x line.  This bug has existed in all prior versions of SQLite.
  16   Even though it is unlikely you will ever encounter this bug,
  17   it is suggested that all users upgrade.  See
  18   <a href="http://www.sqlite.org/cvstrac/tktview?tn=1116">
  19   ticket #1116</a>. for additional information.
  20
  21   Version 3.1.2 is also the first stable release of the 3.1
  22   series.  SQLite 3.1 features added support for correlated
  23   subqueries, autovacuum, autoincrement, ALTER TABLE, and
  24   other enhancements.  See the
  25   <a href="http://www.sqlite.org/releasenotes310.html">release notes
  26   for version 3.1.0</a> for a detailed description of the
  27   changes available in the 3.1 series.
  28 }
  29
  30 newsitem {2005-Feb-01} {Version 3.1.1 (beta) Released} {
  31   Version 3.1.1 (beta) is now available on the
  32   website.  Verison 3.1.1 is fully backwards compatible with the 3.0 series
  33   and features many new features including Autovacuum and correlated
  34   subqueries.  The
  35   <a href="http://www.sqlite.org/releasenotes310.html">release notes</a>
  36   From version 3.1.0 apply equally to this release beta.  A stable release
  37   is expected within a couple of weeks.
  38 }
  39
  40 newsitem {2005-Jan-21} {Version 3.1.0 (alpha) Released} {
  41   Version 3.1.0 (alpha) is now available on the
  42   website.  Verison 3.1.0 is fully backwards compatible with the 3.0 series
  43   and features many new features including Autovacuum and correlated
  44   subqueries.  See the
  45   <a href="http://www.sqlite.org/releasenotes310.html">release notes</a>
  46   for details.
  47
  48   This is an alpha release.  A beta release is expected in about a week
  49   with the first stable release to follow after two more weeks.
  50 }
  51
  52 newsitem {2004-Nov-09} {SQLite at the 2004 International PHP Conference} {
  53   There was a talk on the architecture of SQLite and how to optimize
  54   SQLite queries at the 2004 International PHP Conference in Frankfurt,
  55   Germany.
  56   <a href="http://www.sqlite.org/php2004/page-001.html">
  57   Slides</a> from that talk are available.
  58 }
  59
  60 newsitem {2004-Oct-11} {Version 3.0.8} {
  61   Version 3.0.8 of SQLite contains several code optimizations and minor
  62   bug fixes and adds support for DEFERRED, IMMEDIATE, and EXCLUSIVE
  63   transactions.  This is an incremental release.  There is no reason
  64   to upgrade from version 3.0.7 if that version is working for you.
  65 }
  66
  67
  68 newsitem {2004-Oct-10} {SQLite at the 11<sup><small>th</small></sup>
  69 Annual Tcl/Tk Conference} {
  70   There will be a talk on the use of SQLite in Tcl/Tk at the
  71   11<sup><small>th</small></sup> Tcl/Tk Conference this week in
  72   New Orleans.  Visit <a href="http://www.tcl.tk/community/tcl2004/">
  73   http://www.tcl.tk/</a> for details.
  74   <a href="http://www.sqlite.org/tclconf2004/page-001.html">
  75   Slides</a> from the talk are available.
  76 }
  77
  78 newsitem {2004-Sep-18} {Version 3.0.7} {
  79   Version 3.0 has now been in use by multiple projects for several
  80   months with no major difficulties.   We consider it stable and
  81   ready for production use.
  82 }
  83
  84 newsitem {2004-Sep-02} {Version 3.0.6 (beta)} {
  85   Because of some important changes to sqlite3_step(),
  86   we have decided to
  87   do an additional beta release prior to the first "stable" release.
  88   If no serious problems are discovered in this version, we will
  89   release version 3.0 "stable" in about a week.
  90 }
  91
  92
  93 newsitem {2004-Aug-29} {Version 3.0.5 (beta)} {
  94   The fourth beta release of SQLite version 3.0 is now available.
  95   The next release is expected to be called "stable".
  96 }
  97
  98
  99 newsitem {2004-Aug-08} {Version 3.0.4 (beta)} {
 100   The third beta release of SQLite version 3.0 is now available.
 101   This new beta fixes several bugs including a database corruption
 102   problem that can occur when doing a DELETE while a SELECT is pending.
 103   Expect at least one more beta before version 3.0 goes final.
 104 }
 105
 106 newsitem {2004-July-22} {Version 3.0.3 (beta)} {
 107   The second beta release of SQLite version 3.0 is now available.
 108   This new beta fixes many bugs and adds support for databases with
 109   varying page sizes.  The next 3.0 release will probably be called
 110   a final or stable release.
 111
 112   Version 3.0 adds support for internationalization and a new
 113   more compact file format.
 114   <a href="version3.html">Details.</a>
 115   The API and file format have been fixed since 3.0.2.  All
 116   regression tests pass (over 100000 tests) and the test suite
 117   exercises over 95% of the code.
 118
 119   SQLite version 3.0 is made possible in part by AOL
 120   developers supporting and embracing great Open-Source Software.
 121 }
 122
 123 newsitem {2004-Jly-22} {Version 2.8.15} {
 124   SQLite version 2.8.15 is a maintenance release for the version 2.8
 125   series.  Version 2.8 continues to be maintained with bug fixes, but
 126   no new features will be added to version 2.8.  All the changes in
 127   this release are minor.  If you are not having problems, there is
 128   there is no reason to upgrade.
 129 }
 130
 131 newsitem {2004-Jun-30} {Version 3.0.2 (beta) Released} {
 132   The first beta release of SQLite version 3.0 is now available.
 133   Version 3.0 adds support for internationalization and a new
 134   more compact file format.
 135   <a href="version3.html">Details.</a>
 136   As of this release, the API and file format are frozen.  All
 137   regression tests pass (over 100000 tests) and the test suite
 138   exercises over 95% of the code.
 139
 140   SQLite version 3.0 is made possible in part by AOL
 141   developers supporting and embracing great Open-Source Software.
 142 }
 143
 144
 145 newsitem {2004-Jun-25} {Website hacked} {
 146   The www.sqlite.org website was hacked sometime around 2004-Jun-22
 147   because the lead SQLite developer failed to properly patch CVS.
 148   Evidence suggests that the attacker was unable to elevate privileges
 149   above user "cvs".  Nevertheless, as a precaution the entire website
 150   has been reconstructed from scratch on a fresh machine.  All services
 151   should be back to normal as of 2004-Jun-28.
 152 }
 153
 154
 155 newsitem {2004-Jun-18} {Version 3.0.0 (alpha) Released} {
 156   The first alpha release of SQLite version 3.0 is available for
 157   public review and comment.  Version 3.0 enhances internationalization support
 158   through the use of UTF-16 and user-defined text collating sequences.
 159   BLOBs can now be stored directly, without encoding.
 160   A new file format results in databases that are 25% smaller (depending
 161   on content).  The code is also a little faster.  In spite of the many
 162   new features, the library footprint is still less than 240KB
 163   (x86, gcc -O1).
 164   <a href="version3.html">Additional information</a>.
 165
 166   Our intent is to freeze the file format and API on 2004-Jul-01.
 167   Users are encouraged to review and evaluate this alpha release carefully
 168   and submit any feedback prior to that date.
 169
 170   The 2.8 series of SQLite will continue to be supported with bug
 171   fixes for the foreseeable future.
 172 }
 173
 174 newsitem {2004-Jun-09} {Version 2.8.14 Released} {
 175   SQLite version 2.8.14 is a patch release to the stable 2.8 series.
 176   There is no reason to upgrade if 2.8.13 is working ok for you.
 177   This is only a bug-fix release.  Most development effort is
 178   going into version 3.0.0 which is due out soon.
 179 }
 180
 181 newsitem {2004-May-31} {CVS Access Temporarily Disabled} {
 182   Anonymous access to the CVS repository will be suspended
 183   for 2 weeks beginning on 2004-June-04.  Everyone will still
 184   be able to download
 185   prepackaged source bundles, create or modify trouble tickets, or view
 186   change logs during the CVS service interruption. Full open access to the
 187   CVS repository will be restored on 2004-June-18.
 188 }
 189
 190 newsitem {2004-Apr-23} {Work Begins On SQLite Version 3} {
 191   Work has begun on version 3 of SQLite.  Version 3 is a major
 192   changes to both the C-language API and the underlying file format
 193   that will enable SQLite to better support internationalization.
 194   The first beta is schedule for release on 2004-July-01.
 195
 196   Plans are to continue to support SQLite version 2.8 with
 197   bug fixes.  But all new development will occur in version 3.0.
 198 }
 199 footer {$Id: oldnews.tcl,v 1.11 2005/03/17 03:33:17 drh Exp $}