Documentation Source Text

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.

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.

    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.

    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.

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

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

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

<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} {

<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} {

    .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>
  }
}

    .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>
  }
}