Documentation Source Text

Check-in [25417e1303]
Login

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

Overview
Comment:Update the index, changes, and news pages for the 3.7.0.1 patch release.
Timelines: family | ancestors | branch-3.7.0
Files: files | file ages | folders
SHA1: 25417e1303b3d11f4ebefb8a0d3a8c3dbfc64a74
User & Date: drh 2010-08-04 16:19:07
Context
2010-08-04
16:19
Update the index, changes, and news pages for the 3.7.0.1 patch release. Leaf check-in: 25417e1303 user: drh tags: branch-3.7.0
2010-07-26
11:58
Remove <dl> marks from requirements text prior to insertion into the matrix. check-in: 9b8e4462b6 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

37
38
39
40
41
42
43









44
45
46
47
48
49
50
      <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 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.







>
>
>
>
>
>
>
>
>







37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
      <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.

Changes to pages/index.in.

83
84
85
86
87
88
89
90
91
92
93

94
95
96
97
98
99
100

</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.html">Version 3.7.0</a>
of SQLite is recommended for all new development.  Upgrading from
version 3.6.12, 3.6.13, 3.6.22, and 3.6.23 is optional.
Upgrading from all other SQLite versions 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>







|

|
|
>







83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101

</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>

Changes to pages/news.in.

14
15
16
17
18
19
20













21
22
23
24
25
26
27
  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-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







>
>
>
>
>
>
>
>
>
>
>
>
>







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
  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