Documentation Source Text

Check-in [b202aab6a1]
Login

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

Overview
Comment:Fix up the news section, the download page, and the menu bar. Break up changes into individual files. All links are now resolved, we think.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b202aab6a1552d9dfeda2fa6108c66b296612bd7
User & Date: drh 2007-11-13 20:23:24
Context
2007-11-13
20:53
Add the onefile.html page and a link from the about.html page. check-in: 61a0a369be user: drh tags: trunk
20:23
Fix up the news section, the download page, and the menu bar. Break up changes into individual files. All links are now resolved, we think. check-in: b202aab6a1 user: drh tags: trunk
19:10
Fix a relative path problem in wrap.tcl. Use the multi-file C API reference by default. check-in: c67fecef8e user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

8
9
10
11
12
13
14
15
16
17
18
19
20
21






















22
23
24
25
26
27
28
http://www.sqlite.org/cvstrac/timeline</a>.
</p>

<tcl>
proc chng {date desc} {
  if {[regexp {\(([0-9.]+)\)} $date all vers]} {
    set label [string map {. _} $vers]
    puts "<A NAME=\"version_$label\">"
  }
  puts "<DT><B>$date</B></DT>"
  regsub -all {[Tt]icket #(\d+)} $desc \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} desc
  puts "<DD><P><UL>$desc</UL></P>"
  puts "</DD>"






















}

chng {2007 Nov 05 (3.5.2)} {
<li>Dropped support for the SQLITE_OMIT_MEMORY_ALLOCATION compile-time
option.
<li>Always open files using FILE_FLAG_RANDOM_ACCESS under windows.
<li>The 3rd parameter of the built-in SUBSTR() function is now optional.







|






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







8
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
38
39
40
41
42
43
44
45
46
47
48
49
50
http://www.sqlite.org/cvstrac/timeline</a>.
</p>

<tcl>
proc chng {date desc} {
  if {[regexp {\(([0-9.]+)\)} $date all vers]} {
    set label [string map {. _} $vers]
    puts "<A NAME=\"version_$label\"></a>"
  }
  puts "<DT><B>$date</B></DT>"
  regsub -all {[Tt]icket #(\d+)} $desc \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} desc
  puts "<DD><P><UL>$desc</UL></P>"
  puts "</DD>"
  if {[regexp {\(3\.\d+\.\d+\)} $date tag]} {
    set tag [string map {. _} [string range $tag 1 end-1]]
    global OUT DEST DOC
    set saved_OUT $OUT
    file mkdir $DEST/releaselog
    set filename $DEST/releaselog/$tag.html
    set OUT [open $filename w]
    PutsHeader "SQLite Release $date" ../
    puts "<h2>SQLite Release of $date</h2>"
    puts "<p>Changes associated with this release include the following:</p>"
    puts "<p><ul>$desc</ul></p>"
    putsin4 {
      <p>A <a href="../changes.html">complete list of SQLite releases</a>
      in a single pages is also available.  A detailed history of every
      check-in is available at
      <a href="http://www.sqlite.org/cvstrac/timeline">
      http://www.sqlite.org/cvstrac/timeline</a>.</p>
    }
    PutsFooter $DOC/pages/changes.in
    close $OUT
    set OUT $saved_OUT
  }
}

chng {2007 Nov 05 (3.5.2)} {
<li>Dropped support for the SQLITE_OMIT_MEMORY_ALLOCATION compile-time
option.
<li>Always open files using FILE_FLAG_RANDOM_ACCESS under windows.
<li>The 3rd parameter of the built-in SUBSTR() function is now optional.

Changes to pages/download.in.

18
19
20
21
22
23
24





25
26
27
28
29
30
31
32
33
34
35

36
37
38
39
40
41
42
43
    if {$size>1024*1024} {
      set size [format %.2f [expr {$size/(1024.0*1024.0)}]]
      set units MiB
    } elseif {$size>1024} {
      set size [format %.2f [expr {$size/(1024.0)}]]
      set units KiB
    }





    puts "<tr><td width=\"10\"></td>"
    puts "<td valign=\"top\" align=\"right\">"
    puts "<a href=\"$file\">$file</a><br>($size $units)</td>"
    puts "<td width=\"5\"></td>"
    regsub -all VERSION $desc $version d2
    puts "<td valign=\"top\">[string trim $d2]</td></tr>"
  }
}
cd $::DEST

proc Heading {title} {

  puts "<tr><td colspan=4><big><b>$title</b></big></td></tr>"
}

Heading {Precompiled Binaries for Linux}

Product sqlite3-V3.bin.gz {
  A command-line program for accessing and modifying
  SQLite version 3.* databases.







>
>
>
>
>











>
|







18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    if {$size>1024*1024} {
      set size [format %.2f [expr {$size/(1024.0*1024.0)}]]
      set units MiB
    } elseif {$size>1024} {
      set size [format %.2f [expr {$size/(1024.0)}]]
      set units KiB
    }
    global pending_heading
    if {$pending_heading!=""} {
      puts "<tr><td colspan=\"4\"><h3>$pending_heading</h3></td></tr>"
      set pending_heading {}
    }
    puts "<tr><td width=\"10\"></td>"
    puts "<td valign=\"top\" align=\"right\">"
    puts "<a href=\"$file\">$file</a><br>($size $units)</td>"
    puts "<td width=\"5\"></td>"
    regsub -all VERSION $desc $version d2
    puts "<td valign=\"top\">[string trim $d2]</td></tr>"
  }
}
cd $::DEST

proc Heading {title} {
  set ::pending_heading $title
  # puts "<tr><td colspan=4><big><b>$title</b></big></td></tr>"
}

Heading {Precompiled Binaries for Linux}

Product sqlite3-V3.bin.gz {
  A command-line program for accessing and modifying
  SQLite version 3.* databases.

Changes to pages/index.in.

1
2
3
4
5
6
7
8
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
38
39
40
<title>SQLite Home Page</title>

<table border="0" cellspacing="20">
<tr><td valign="top">
<b>About&nbsp;Sqlite</b>
</td><td valign="top">
<li>SQLite is a C-library that implements a high-efficiency,
   transactional SQL database engine using databases stored in
   ordinary disk files.
   <a href="about.html">More info...</a></li>
</td></tr>

<tr><td valign="top">
<b>Current&nbsp;Status</b>
</td><td valign="top">
<li><a href="download.html">Version 3.5.2</a>
of SQLite is stable and is recommended for all users.
There are no known issues effecting database integrity or correctness.</li>
</td></tr>


<tr><td valign="top">
<b>Recent&nbsp;News</b>
</td><td valign="top">
<li> 2007-Nov-05: <a href="news.html">Version 3.5.2 released</a>. </li>

<li> 2007-Oct-04: <a href="news.html">Version 3.5.1 released</a>. </li>

<li> 2007-Sep-04: <a href="news.html">Version 3.5.0 released</a>. </li>

</td></tr>

<tr><td valign="top">
<b>Quick&nbsp;Links</b>
</td><td valign="top">
<li> More details <a href="about.html">about SQLite</a> - what it is and what
     it is not.</li>
<li> <a href="faq.html">Frequently Asked Questions</a> about SQLite. </li>
<li> <a href="famous.html">Well-known users</a> of SQLite.</li>


<li> <a href="http://www.sqlite.org/cvstrac/timeline">Timeline</a> of recent
     development activity. </li>
</td></tr>
</table>




|










|








|
>
|
>
|
>









>
>




1
2
3
4
5
6
7
8
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
38
39
40
41
42
43
44
45
<title>SQLite Home Page</title>

<table border="0" cellspacing="20">
<tr><td valign="top">
<a href="about.html"><b>About&nbsp;Sqlite</b></a>
</td><td valign="top">
<li>SQLite is a C-library that implements a high-efficiency,
   transactional SQL database engine using databases stored in
   ordinary disk files.
   <a href="about.html">More info...</a></li>
</td></tr>

<tr><td valign="top">
<b>Current&nbsp;Status</b>
</td><td valign="top">
<li><a href="releaselog/3_5_2.html">Version 3.5.2</a>
of SQLite is stable and is recommended for all users.
There are no known issues effecting database integrity or correctness.</li>
</td></tr>


<tr><td valign="top">
<b>Recent&nbsp;News</b>
</td><td valign="top">
<li> 2007-Nov-05: <a href="news.html#2007_nov_05">Version 3.5.2 released</a>. 
     </li>
<li> 2007-Oct-04: <a href="news.html#2007_oct_04">Version 3.5.1 released</a>. 
     </li>
<li> 2007-Sep-04: <a href="news.html#2007_sep_04">Version 3.5.0 released</a>. 
     </li>
</td></tr>

<tr><td valign="top">
<b>Quick&nbsp;Links</b>
</td><td valign="top">
<li> More details <a href="about.html">about SQLite</a> - what it is and what
     it is not.</li>
<li> <a href="faq.html">Frequently Asked Questions</a> about SQLite. </li>
<li> <a href="famous.html">Well-known users</a> of SQLite.</li>
<li> <a href="lang.html">SQL Understood By SQLite</a>. </li>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>. </li>
<li> <a href="http://www.sqlite.org/cvstrac/timeline">Timeline</a> of recent
     development activity. </li>
</td></tr>
</table>

Added pages/news.in.











































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
1
2
3
4
5
6
7
8
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<title>Recent SQLite News</title>

<h2>Recent News</h2>

<tcl>
proc newsitem {date title text} {
  regsub -all {[^a-z0-9]} [string tolower $date] _ tag
  puts "<a name=\"$tag\"></a>"
  puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  puts "<p>$txt</p>"
  puts "<hr width=\"50%\">"
}

newsitem {2007-Nov-05} {Version 3.5.2} {
  This is an incremental release that fixes several minor problems,
  adds some obscure features, and provides some performance tweaks.  
  Upgrading is optional.

  The experimental compile-time option
  SQLITE_OMIT_MEMORY_ALLOCATION is no longer supported.  On the other
  hand, it is now possible to compile SQLite so that it uses a static
  array for all its dynamic memory allocation needs and never calls
  malloc.  Expect to see additional radical changes to the memory 
  allocation subsystem in future releases.
}

newsitem {2007-Oct-04} {Version 3.5.1} {
  Fix a long-standing bug that might cause database corruption if a
  disk-full error occurs in the middle of a transaction and that
  transaction is not rolled back.
  <a href="http://www.sqlite.org/cvstrac/tktview?tn=2686">Ticket #2686.</a>

  The new VFS layer is stable.  However, we still reserve the right to
  make tweaks to the interface definition of the VFS if necessary.
}

newsitem {2007-Sep-04} {Version 3.5.0 alpha} {
  The OS interface layer and the memory allocation subsystems in
  SQLite have been reimplemented.  The published API is largely unchanged
  but the (unpublished) OS interface has been modified extensively.  
  Applications that implement their own OS interface will require
  modification.  See
  <a href="34to35.html">34to35.html</a> for details.<p>

  This is a large change.  Approximately 10% of the source code was
  modified.  We are calling this first release "alpha" in order to give
  the user community time to test and evaluate the changes before we
  freeze the new design.
}
</tcl>

<a href="oldnews.html">Old news...</a>

Changes to pages/oldnews.in.

1
2
3
4


5
6
7
8
9
10
11
<title>SQLite Older News</title>

<tcl>
proc newsitem {date title text} {


  puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  puts "<p>$txt</p>"
  puts "<hr width=\"50%\">"
}

newsitem {2007-Aug-13} {Version 3.4.2} {




>
>







1
2
3
4
5
6
7
8
9
10
11
12
13
<title>SQLite Older News</title>

<tcl>
proc newsitem {date title text} {
  regsub -all {[^a-z0-9]} $date _ tag
  puts "<a name=\"$tag\"></a>"
  puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  puts "<p>$txt</p>"
  puts "<hr width=\"50%\">"
}

newsitem {2007-Aug-13} {Version 3.4.2} {

Changes to wrap.tcl.

75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
...
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
    .toolbar {
      font-variant: small-caps;
      text-align: center;
      line-height: 1.6em;
      margin: 0;
      padding:1px 8px;
    }
    .toolbar a { color: white; text-decoration: none; padding: 6px 4px; }
    .toolbar a:visited { color: white; }
    .toolbar a:hover { color: #80a796; background: white; }
    
    .content    { margin: 5%; }
    .content dt { font-weight:bold; }
    .content dd { margin-bottom: 25px; margin-left:20%; }
    .content ul { padding:0px; padding-left: 15px; margin:0px; }
................................................................................
      <div class="se"><div class="sw"><div class="ne"><div class="nw">
      <div class="toolbar">
        <a href="${path}index.html">Home</a>
        <a href="${path}about.html">About</a>
        <a href="${path}docs.html">Documentation</a>
        <a href="${path}download.html">Download</a>
        <a href="${path}copyright.html">License</a>
        <a href="${path}press.html">Advocacy</a>
        <a href="${path}devhome.html">Developers</a>
        <a href="${path}news.html">News</a>
        <a href="${path}support.html">Support</a>
      </div></div></div></div></div>
    </td></tr></table>
  }
}








|







 







<
<







75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
...
109
110
111
112
113
114
115


116
117
118
119
120
121
122
    .toolbar {
      font-variant: small-caps;
      text-align: center;
      line-height: 1.6em;
      margin: 0;
      padding:1px 8px;
    }
    .toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
    .toolbar a:visited { color: white; }
    .toolbar a:hover { color: #80a796; background: white; }
    
    .content    { margin: 5%; }
    .content dt { font-weight:bold; }
    .content dd { margin-bottom: 25px; margin-left:20%; }
    .content ul { padding:0px; padding-left: 15px; margin:0px; }
................................................................................
      <div class="se"><div class="sw"><div class="ne"><div class="nw">
      <div class="toolbar">
        <a href="${path}index.html">Home</a>
        <a href="${path}about.html">About</a>
        <a href="${path}docs.html">Documentation</a>
        <a href="${path}download.html">Download</a>
        <a href="${path}copyright.html">License</a>


        <a href="${path}news.html">News</a>
        <a href="${path}support.html">Support</a>
      </div></div></div></div></div>
    </td></tr></table>
  }
}