a more efficient encoding of boolean values.  SQLite 3.3.0 will read and  write legacy databases created with any prior version of SQLite 3.  But  databases created by version 3.3.0 will not be readable or writable  by earlier versions of the SQLite.  The older file format can be  specified at compile-time for those rare cases where it is needed.</p><hr width="50%"><a name="2005__ec_19"></a><h3>2005-Dec-19 - Versions 3.2.8 and 2.8.17</h3><p>  These versions contain one-line changes to 3.2.7 and 2.8.16 to fix a bug  that has been present since March of 2002 and version 2.4.0.  That bug might possibly cause database corruption if a large INSERT or  UPDATE statement within a multi-statement transaction fails due to a  uniqueness constraint but the containing transaction commits.</p><hr width="50%"><a name="2005__ep_24"></a><h3>2005-Sep-24 - Version 3.2.7</h3><p>  This version fixes several minor and obscure bugs.  Upgrade only if you are having problems.</p><hr width="50%"><a name="2005__ep_16"></a><h3>2005-Sep-16 - Version 3.2.6 - Critical Bug Fix</h3><p>  This version fixes a bug that can result in database  corruption if a VACUUM of a 1 gibibyte or larger database fails  (perhaps do to running out of disk space or an unexpected power loss)  and is later rolled back.  <p>  Also in this release:  The ORDER BY and GROUP BY processing was rewritten to use less memory.  Support for COUNT(DISTINCT) was added.  The LIKE operator can now be  used by the optimizer on columns with COLLATE NOCASE.</p><hr width="50%"><a name="2005__ug_27"></a><h3>2005-Aug-27 - Version 3.2.5</h3><p>  This release fixes a few more lingering bugs in the new code.  We expect that this release will be stable and ready for production use.</p><hr width="50%"><a name="2005__ug_24"></a><h3>2005-Aug-24 - Version 3.2.4</h3><p>  This release fixes a bug in the new optimizer that can lead to segfaults  when parsing very complex WHERE clauses.</p><hr width="50%"><a name="2005__ug_21"></a><h3>2005-Aug-21 - Version 3.2.3</h3><p>  This release adds the <a href="lang_analyze.html">ANALYZE</a> command,  the <a href="lang_expr.html">CAST</a> operator, and many  very substantial improvements to the query optimizer.  See the  <a href="changes.html#version_3_2_3">change log</a> for additional  information.</p><hr width="50%"><a name="2005__ug_2"></a><h3>2005-Aug-2 - 2005 Open Source Award for SQLite</h3><p>  SQLite and its primary author D. Richard Hipp have been honored with  a <a href="http://osdir.com/Article6677.phtml">2005 Open Source  Award</a> from Google and O'Reilly.<br clear="right"></p><hr width="50%"><a name="2005__un_13"></a><h3>2005-Jun-13 - Version 3.2.2</h3><p>  This release includes numerous minor bug fixes, speed improvements,  and code size reductions.  There is no reason to upgrade unless you  are having problems or unless you just want to.</p><hr width="50%"><a name="2005__ar_29"></a><h3>2005-Mar-29 - Version 3.2.1</h3><p>  This release fixes a memory allocation problem in the new  <a href="lang_altertable.html">ALTER TABLE ADD COLUMN</a>  command.</p><hr width="50%"><a name="2005__ar_21"></a><h3>2005-Mar-21 - Version 3.2.0</h3><p>  The primary purpose for version 3.2.0 is to add support for  <a href="lang_altertable.html">ALTER TABLE ADD COLUMN</a>.  The new ADD COLUMN capability is made  possible by AOL developers supporting and embracing great  open-source software.  Thanks, AOL!</p><p>  Version 3.2.0 also fixes an obscure but serious bug that was discovered  just prior to release.  If you have a multi-statement transaction and  within that transaction an UPDATE or INSERT statement fails due to a  constraint, then you try to rollback the whole transaction, the rollback  might not work correctly.  See  <a href="http://www.sqlite.org/cvstrac/tktview?tn=1171">Ticket #1171</a>  for details.  Upgrading is recommended for all users.</p><hr width="50%"><a name="2005__ar_16"></a><h3>2005-Mar-16 - Version 3.1.6</h3><p>  Version 3.1.6 fixes a critical bug that can cause database corruption  when inserting rows into tables with around 125 columns. This bug was  introduced in version 3.0.0.  See  <a href="http://www.sqlite.org/cvstrac/tktview?tn=1163">Ticket #1163</a>  for additional information.</p><hr width="50%"><a name="2005__ar_11"></a><h3>2005-Mar-11 - Versions 3.1.4 and 3.1.5 Released</h3><p>  Version 3.1.4 fixes a critical bug that could cause database corruption  if the autovacuum mode of version 3.1.0 is turned on (it is off by  default) and a CREATE UNIQUE INDEX is executed within a transaction but  fails because the indexed columns are not unique.  Anyone using the  autovacuum feature and unique indices should upgrade.</p><p>  Version 3.1.5 adds the ability to disable  the F_FULLFSYNC ioctl() in OS-X by setting "PRAGMA synchronous=on" instead  of the default "PRAGMA synchronous=full".  There was an attempt to add  this capability in 3.1.4 but it did not work due to a spelling error.</p><hr width="50%"><a name="2005__eb_19"></a><h3>2005-Feb-19 - Version 3.1.3 Released</h3><p>  Version 3.1.3 cleans up some minor issues discovered in version 3.1.2.</p><hr width="50%"><a name="2005__eb_15"></a><h3>2005-Feb-15 - Versions 2.8.16 and 3.1.2 Released</h3><p>  A critical bug in the VACUUM command that can lead to database  corruption has been fixed in both the 2.x branch and the main  3.x line.  This bug has existed in all prior versions of SQLite.  Even though it is unlikely you will ever encounter this bug,  it is suggested that all users upgrade.  See  <a href="http://www.sqlite.org/cvstrac/tktview?tn=1116">  ticket #1116</a>. for additional information.</p><p>  Version 3.1.2 is also the first stable release of the 3.1  series.  SQLite 3.1 features added support for correlated  subqueries, autovacuum, autoincrement, ALTER TABLE, and  other enhancements.  See the   <a href="http://www.sqlite.org/releasenotes310.html">release notes  for version 3.1.0</a> for a detailed description of the  changes available in the 3.1 series.</p><hr width="50%"><a name="2005__eb_01"></a><h3>2005-Feb-01 - Version 3.1.1 (beta) Released</h3><p>  Version 3.1.1 (beta) is now available on the  website.  Verison 3.1.1 is fully backwards compatible with the 3.0 series  and features many new features including Autovacuum and correlated  subqueries.  The  <a href="http://www.sqlite.org/releasenotes310.html">release notes</a>  From version 3.1.0 apply equally to this release beta.  A stable release  is expected within a couple of weeks.</p><hr width="50%"><a name="2005__an_21"></a><h3>2005-Jan-21 - Version 3.1.0 (alpha) Released</h3><p>  Version 3.1.0 (alpha) is now available on the  website.  Verison 3.1.0 is fully backwards compatible with the 3.0 series  and features many new features including Autovacuum and correlated  subqueries.  See the  <a href="http://www.sqlite.org/releasenotes310.html">release notes</a>  for details.</p><p>  This is an alpha release.  A beta release is expected in about a week  with the first stable release to follow after two more weeks.</p><hr width="50%"><a name="2004__ov_09"></a><h3>2004-Nov-09 - SQLite at the 2004 International PHP Conference</h3><p>  There was a talk on the architecture of SQLite and how to optimize  SQLite queries at the 2004 International PHP Conference in Frankfurt,  Germany.  <a href="http://www.sqlite.org/php2004/page-001.html">  Slides</a> from that talk are available.</p><hr width="50%"><a name="2004__ct_11"></a><h3>2004-Oct-11 - Version 3.0.8</h3><p>  Version 3.0.8 of SQLite contains several code optimizations and minor  bug fixes and adds support for DEFERRED, IMMEDIATE, and EXCLUSIVE  transactions.  This is an incremental release.  There is no reason  to upgrade from version 3.0.7 if that version is working for you.</p><hr width="50%"><a name="2004__ct_10"></a><h3>2004-Oct-10 - SQLite at the 11<sup><small>th</small></sup>Annual Tcl/Tk Conference</h3><p>  There will be a talk on the use of SQLite in Tcl/Tk at the  11<sup><small>th</small></sup> Tcl/Tk Conference this week in  New Orleans.  Visit <a href="http://www.tcl.tk/community/tcl2004/">  http://www.tcl.tk/</a> for details.  <a href="http://www.sqlite.org/tclconf2004/page-001.html">  Slides</a> from the talk are available.</p><hr width="50%"><a name="2004__ep_18"></a><h3>2004-Sep-18 - Version 3.0.7</h3><p>  Version 3.0 has now been in use by multiple projects for several  months with no major difficulties.   We consider it stable and  ready for production use. </p><hr width="50%"><a name="2004__ep_02"></a><h3>2004-Sep-02 - Version 3.0.6 (beta)</h3><p>  Because of some important changes to sqlite3_step(),  we have decided to  do an additional beta release prior to the first "stable" release.  If no serious problems are discovered in this version, we will  release version 3.0 "stable" in about a week.</p><hr width="50%"><a name="2004__ug_29"></a><h3>2004-Aug-29 - Version 3.0.5 (beta)</h3><p>  The fourth beta release of SQLite version 3.0 is now available.  The next release is expected to be called "stable".</p><hr width="50%"><a name="2004__ug_08"></a><h3>2004-Aug-08 - Version 3.0.4 (beta)</h3><p>  The third beta release of SQLite version 3.0 is now available.  This new beta fixes several bugs including a database corruption  problem that can occur when doing a DELETE while a SELECT is pending.  Expect at least one more beta before version 3.0 goes final.</p><hr width="50%"><a name="2004__uly_22"></a><h3>2004-July-22 - Version 3.0.3 (beta)</h3><p>  The second beta release of SQLite version 3.0 is now available.  This new beta fixes many bugs and adds support for databases with  varying page sizes.  The next 3.0 release will probably be called  a final or stable release.</p><p>  Version 3.0 adds support for internationalization and a new  more compact file format.   <a href="version3.html">Details.</a>  The API and file format have been fixed since 3.0.2.  All  regression tests pass (over 100000 tests) and the test suite  exercises over 95% of the code.</p><p>  SQLite version 3.0 is made possible in part by AOL  developers supporting and embracing great Open-Source Software.</p><hr width="50%"><a name="2004__ly_22"></a><h3>2004-Jly-22 - Version 2.8.15</h3><p>  SQLite version 2.8.15 is a maintenance release for the version 2.8  series.  Version 2.8 continues to be maintained with bug fixes, but  no new features will be added to version 2.8.  All the changes in  this release are minor.  If you are not having problems, there is  there is no reason to upgrade.</p><hr width="50%"><a name="2004__un_30"></a><h3>2004-Jun-30 - Version 3.0.2 (beta) Released</h3><p>  The first beta release of SQLite version 3.0 is now available.  Version 3.0 adds support for internationalization and a new  more compact file format.   <a href="version3.html">Details.</a>  As of this release, the API and file format are frozen.  All  regression tests pass (over 100000 tests) and the test suite  exercises over 95% of the code.</p><p>  SQLite version 3.0 is made possible in part by AOL  developers supporting and embracing great Open-Source Software.</p><hr width="50%"><a name="2004__un_25"></a><h3>2004-Jun-25 - Website hacked</h3><p>  The www.sqlite.org website was hacked sometime around 2004-Jun-22  because the lead SQLite developer failed to properly patch CVS.  Evidence suggests that the attacker was unable to elevate privileges  above user "cvs".  Nevertheless, as a precaution the entire website  has been reconstructed from scratch on a fresh machine.  All services  should be back to normal as of 2004-Jun-28.</p><hr width="50%"><a name="2004__un_18"></a><h3>2004-Jun-18 - Version 3.0.0 (alpha) Released</h3><p>  The first alpha release of SQLite version 3.0 is available for  public review and comment.  Version 3.0 enhances internationalization support  through the use of UTF-16 and user-defined text collating sequences.  BLOBs can now be stored directly, without encoding.  A new file format results in databases that are 25% smaller (depending  on content).  The code is also a little faster.  In spite of the many  new features, the library footprint is still less than 240KB  (x86, gcc -O1).  <a href="version3.html">Additional information</a>.</p><p>  Our intent is to freeze the file format and API on 2004-Jul-01.  Users are encouraged to review and evaluate this alpha release carefully   and submit any feedback prior to that date.</p><p>  The 2.8 series of SQLite will continue to be supported with bug  fixes for the foreseeable future.</p><hr width="50%"><a name="2004__un_09"></a><h3>2004-Jun-09 - Version 2.8.14 Released</h3><p>  SQLite version 2.8.14 is a patch release to the stable 2.8 series.  There is no reason to upgrade if 2.8.13 is working ok for you.  This is only a bug-fix release.  Most development effort is  going into version 3.0.0 which is due out soon.</p><hr width="50%"><a name="2004__ay_31"></a><h3>2004-May-31 - CVS Access Temporarily Disabled</h3><p>  Anonymous access to the CVS repository will be suspended  for 2 weeks beginning on 2004-June-04.  Everyone will still  be able to download  prepackaged source bundles, create or modify trouble tickets, or view  change logs during the CVS service interruption. Full open access to the  CVS repository will be restored on 2004-June-18.</p><hr width="50%"><a name="2004__pr_23"></a><h3>2004-Apr-23 - Work Begins On SQLite Version 3</h3><p>  Work has begun on version 3 of SQLite.  Version 3 is a major  changes to both the C-language API and the underlying file format  that will enable SQLite to better support internationalization.  The first beta is schedule for release on 2004-July-01.</p><p>  Plans are to continue to support SQLite version 2.8 with  bug fixes.  But all new development will occur in version 3.0.</p><hr width="50%"><hr><small><i>This page last modified 2007/12/20 02:17:51 UTC</i></small></div></body></html>