Documentation Source Text

      <a href="http://www.sqlite.org/src/timeline">
      http://www.sqlite.org/src/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2010 August 4 (3.7.0.1)} {
<li> Fix a potential database corruption problem that can result if
     the same database file is alternately written by version 3.7.0
     and 3.6.23.1.  See <a href="http://www.sqlite.org/src/info/51ae9cad31">
     ticket &#91;51ae9cad31&#93;</a> for details.
<li> Fix a possible performance regression caused by the introduction
     of [automatic indexing].
}

chng {2010 July 22 (3.7.0)} {
<li> Added support for [WAL | write-ahead logging].
<li> Query planner enhancement - automatic transient indices are created
     when doing so reduces the estimated query time.
<li> Query planner enhancement - the ORDER BY becomes a no-op if the query
     also contains a GROUP BY clause that forces the correct output order.

</td>
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>

<p><ul>
<li><a href="releaselog/3_7_0_1.html">Version 3.7.0.1</a>
of SQLite is recommended for all new development.  Upgrading from
versions 3.6.12, 3.6.13, 3.6.22, 3.6.23, and 3.6.23.1 is optional.
Upgrading from all other SQLite versions and especially
version 3.7.0 is recommended.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>

  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<p>$txt</p>"
  hd_puts "<hr width=\"50%\">"
}

newsitem {2010-August-03} {Version 3.7.0.1} {
  SQLite [version 3.7.0.1] is a patch release to fix a bug in version 3.7.0
  that can lead to database corruption if the same database file is alternately
  written by version 3.7.0 and version 3.6.23.1 or earlier.
  Details can be seen at <a href="http://www.sqlite.org/src/info/51ae9cad317a1">
  ticket &#91;51ae9cad317a1&#93;</a>.

  Two other less serious problems are fixed:  a possible performance regression
  due to the introduction of [automatic indexing] and a typo that prevented
  SQLite from compiling on OS/2.  The changes in this release from version
  3.7.0 are minimal.
}

newsitem {2010-July-22} {Version 3.7.0} {
  SQLite [version 3.7.0] is a major new release of SQLite that features
  a new transaction control mechanism usingn a [write-ahead log] or [WAL].
  The traditional rollback-journal is still used as the default so there
  should be no visible change for legacy programs.  But newer programs
  can take advantage of improved performance and concurrency by enabling