/ Artifact Content

Artifact f6d75118ac266313ebcdafa79b779b82dde44cc0:

# Run this script to generated a changes.html output file
puts {<html>
  <title>SQLite Change Log</title>
<body bgcolor="white">
<h1 align="center">Recent Changes To SQLite</h1>


proc chng {date desc} {
  puts "<DT><B>$date</B></DT>"
  puts "<DD><P><UL>$desc</UL></P></DD>"

chan {2000 May 31} {
<li>Added support for aggregate functions (Ex: <b>COUNT(*)<b>, <b>MIN(...)</b>)
to the SELECT statement.</li>

chng {2000 May 30} {
<li>Added the <b>LIKE</b> operator.</li>
<li>Added a <b>GLOB</b> operator: similar to <B>LIKE</B> 
but it uses Unix shell globbing wildcards instead of the '%' 
and '_' wildcards of SQL.</li>
<li>Added the <B>COPY</b> command patterned after 
<a href="http://www.postgresql.org/">PostgreSQL</a> so that SQLite
can now read the output of the <b>pg_dump</b> database dump utility
of PostgreSQL.</li>
<li>Added a <B>VACUUM</B> command that that calls the 
<b>gdbm_reorganize()</b> function on the underlying database
<li>And many, many bug fixes...</li>

chng {2000 May 29} {
<li>Initial Public Release of Alpha code</li>

puts {
<p><hr /></p>
<p><a href="index.html"><img src="/goback.jpg" border=0 />
Back to the SQLite Home Page</a>