| drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 1 | # |
| 2 | # Run this script to generated a changes.html output file |
| 3 | # |
| 4 | puts {<html> |
| 5 | <head> |
| 6 | <title>SQLite Change Log</title> |
| 7 | </head> |
| 8 | <body bgcolor="white"> |
| 9 | <h1 align="center">Recent Changes To SQLite</h1> |
| 10 | |
| 11 | <DL> |
| 12 | } |
| 13 | |
| 14 | |
| 15 | proc chng {date desc} { |
| 16 | puts "<DT><B>$date</B></DT>" |
| 17 | puts "<DD><P><UL>$desc</UL></P></DD>" |
| 18 | } |
| 19 | |
| drh | 7203e28 | 2000-05-31 15:35:42 +0000 | [diff] [blame] | 20 | chng {2000 May 31} { |
| drh | bf66fff | 2000-05-31 15:43:25 +0000 | [diff] [blame] | 21 | <li>Added support for aggregate functions (Ex: <b>COUNT(*)</b>, <b>MIN(...)</b>) |
| drh | cce7d17 | 2000-05-31 15:34:51 +0000 | [diff] [blame] | 22 | to the SELECT statement.</li> |
| drh | 56d48ad | 2000-05-31 21:06:30 +0000 | [diff] [blame] | 23 | <li>Added support for <B>SELECT DISTINCT ...</B></li> |
| drh | cce7d17 | 2000-05-31 15:34:51 +0000 | [diff] [blame] | 24 | } |
| 25 | |
| drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 26 | chng {2000 May 30} { |
| 27 | <li>Added the <b>LIKE</b> operator.</li> |
| 28 | <li>Added a <b>GLOB</b> operator: similar to <B>LIKE</B> |
| 29 | but it uses Unix shell globbing wildcards instead of the '%' |
| 30 | and '_' wildcards of SQL.</li> |
| 31 | <li>Added the <B>COPY</b> command patterned after |
| 32 | <a href="http://www.postgresql.org/">PostgreSQL</a> so that SQLite |
| 33 | can now read the output of the <b>pg_dump</b> database dump utility |
| 34 | of PostgreSQL.</li> |
| 35 | <li>Added a <B>VACUUM</B> command that that calls the |
| 36 | <b>gdbm_reorganize()</b> function on the underlying database |
| 37 | files.</li> |
| 38 | <li>And many, many bug fixes...</li> |
| 39 | } |
| 40 | |
| 41 | chng {2000 May 29} { |
| 42 | <li>Initial Public Release of Alpha code</li> |
| 43 | } |
| 44 | |
| 45 | puts { |
| 46 | </DL> |
| 47 | <p><hr /></p> |
| 48 | <p><a href="index.html"><img src="/goback.jpg" border=0 /> |
| 49 | Back to the SQLite Home Page</a> |
| 50 | </p> |
| 51 | |
| 52 | </body></html>} |