Documentation Source Text

Check-in [744b847818]
Login

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

Overview
Comment:Documentation updates for the 3.5.8 release.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 744b84781863c69df4ad6dd1b80b1ed4f5a7764c
User & Date: drh 2008-04-16 15:11:48
Context
2008-04-16
18:13
Fix typo on download.html page. check-in: 794e2cf389 user: drh tags: trunk
15:11
Documentation updates for the 3.5.8 release. check-in: 744b847818 user: drh tags: trunk
2008-04-15
01:32
Update the keyword list. CVSTrac ticket #3054. check-in: 1b43c0419c user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to numbering.txt.

23
24
25
26
27
28
29

30
31
32
33
34
35
36
  F1227-       sqlite3_interrupt
  F1228-       trace and profile callbacks
  F1234-       busy handler
  F1237-       sqlite3_get_table
  F125--       authorizer
  F126--       load extension
  F127--       sqlite3_open

  F128--       Error handling
  F129--       callback interfaces
  F13---     Prepared statements
  F135--       binding values to prepared statements
  F137--       sqlite3_column_xxx()
  F14---
  F15---     sqlite3_value







>







23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
  F1227-       sqlite3_interrupt
  F1228-       trace and profile callbacks
  F1234-       busy handler
  F1237-       sqlite3_get_table
  F125--       authorizer
  F126--       load extension
  F127--       sqlite3_open
  F1276-       sqlite3_limit
  F128--       Error handling
  F129--       callback interfaces
  F13---     Prepared statements
  F135--       binding values to prepared statements
  F137--       sqlite3_column_xxx()
  F14---
  F15---     sqlite3_value

Changes to pages/changes.in.

36
37
38
39
40
41
42




























43
44
45
46
47
48
49
      <a href="http://www.sqlite.org/cvstrac/timeline">
      http://www.sqlite.org/cvstrac/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}





























chng {2008 Mar 17 (3.5.7)} {
<li>Fix a bug ([ticket #2927]) in the register allocation for
compound selects - introduced by the new VM code in version 3.5.5.</li>
<li>ALTER TABLE uses double-quotes instead of single-quotes for quoting
filenames.</li>
<li>Use the WHERE clause to reduce the size of a materialized VIEW in







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







36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
      <a href="http://www.sqlite.org/cvstrac/timeline">
      http://www.sqlite.org/cvstrac/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2008 Apr 16 (3.5.8)} {
<li>Expose SQLite's internal pseudo-random number generator (PRNG)
    via the [sqlite3_randomness()] interface</li>
<li>New interface [sqlite3_context_db_handle()] that returns the
    [database connection] handle that has invoked an application-defined
    SQL function.</li>
<li>New interface [sqlite3_limit()] allows size and length limits to be
    set on a per-connection basis and at run-time.</li>
<li>Improved crash-robustness: write the database page size into the rollback
    journal header.</li>
<li>Allow the [VACUUM] command to change the page size of a database file.</li>
<li>The xAccess() method of the VFS is allowed to return -1 to signal
    a memory allocation error.</li>
<li>Performance improvement: The OP_IdxDelete opcode uses unpacked records,
    obviating the need for one OP_MakeRecord opcode call for each index
    record deleted.</li>
<li>Performance improvement: Constant subexpressions are factored out of
    loops.</li>
<li>Performance improvement: Results of OP_Column are reused rather than
    issuing multiple OP_Column opcodes.</li>
<li>Fix a bug in the RTRIM collating sequence.</li>
<li>Fix a bug in the SQLITE_SECURE_DELETE option that was causing
    Firefox crashes.  Make arrangements to always test SQLITE_SECURE_DELETE
    prior to each release.</li>
<li>Other miscellaneous performance enhancements.</li>
<li>Other miscellaneous minor bug fixes.</li>
}

chng {2008 Mar 17 (3.5.7)} {
<li>Fix a bug ([ticket #2927]) in the register allocation for
compound selects - introduced by the new VM code in version 3.5.5.</li>
<li>ALTER TABLE uses double-quotes instead of single-quotes for quoting
filenames.</li>
<li>Use the WHERE clause to reduce the size of a materialized VIEW in

Changes to pages/index.in.

58
59
60
61
62
63
64
65
66
67
68
69
70
71
72

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

<p><ul>
<li><a href="releaselog/3_5_7.html">Version 3.5.7</a>
of SQLite is stable and is recommended for all users.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>







|







58
59
60
61
62
63
64
65
66
67
68
69
70
71
72

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

<p><ul>
<li><a href="releaselog/3_5_8.html">Version 3.5.8</a>
of SQLite is stable and is recommended for all users.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>

Changes to pages/news.in.

9
10
11
12
13
14
15















16
17
18
19
20
21
22
  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 {2008-Mar-17} {Version 3.5.7} {
  Version 3.5.7 fixes several minor and obscure bugs, especially 
  in the autoconf-generated makefile.  Upgrading is optional.
  This release of SQLite is considered stable and ready for production use.
}








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







9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
  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 {2008-Apr-16} {Version 3.5.8} {
  Version 3.5.8 includes some important new performance optimizations
  in the virtual machine code generator, including constant subexpression
  factoring and common subexpression elimination.  This release also
  creates new public interfaces:
  [sqlite3_randomness()] provides access to SQLite's internal
  pseudo-random number generator, [sqlite3_limit()] allows size
  limits to be set at run-time on a per-connection basis, and
  [sqlite3_context_db_handle()] is a convenience routine that allows
  an application-defined SQL function implementation to retrieve
  its [database connection] handle.

  This release of SQLite is considered stable and ready for production use.
}

newsitem {2008-Mar-17} {Version 3.5.7} {
  Version 3.5.7 fixes several minor and obscure bugs, especially 
  in the autoconf-generated makefile.  Upgrading is optional.
  This release of SQLite is considered stable and ready for production use.
}