/ Check-in [0a0576e2]
Login

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

Overview
Comment::-) (CVS 135)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:0a0576e2f9e5404dff68683ef6fdf04d3a350b1a
User & Date: drh 2000-08-18 09:58:52
Context
2000-08-18
10:00
Version 1.0.1 (CVS 498) check-in: e8521fc1 user: drh tags: trunk
09:58
:-) (CVS 135) check-in: 0a0576e2 user: drh tags: trunk
09:34
configure script bug (CVS 134) check-in: 862b6492 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/changes.tcl.

    15     15   proc chng {date desc} {
    16     16     puts "<DT><B>$date</B></DT>"
    17     17     puts "<DD><P><UL>$desc</UL></P></DD>"
    18     18   }
    19     19   
    20     20   chng {2000 Aug 18 (Version 1.0.1)} {
    21     21   <li>Fix a bug in the configure script.</li>
           22  +<li>Minor revisions to the website.</li>
    22     23   }
    23     24   
    24     25   chng {2000 Aug 17 (Version 1.0)} {
    25     26   <li>Change the <b>sqlite</b> program so that it can read
    26     27       databases for which it lacks write permission.  (It used to
    27     28       refuse all access if it could not write.)</li>
    28     29   }

Changes to www/index.tcl.

     1      1   #
     2      2   # Run this TCL script to generate HTML for the index.html file.
     3      3   #
     4         -set rcsid {$Id: index.tcl,v 1.27 2000/08/17 10:22:34 drh Exp $}
            4  +set rcsid {$Id: index.tcl,v 1.28 2000/08/18 09:58:52 drh Exp $}
     5      5   
     6      6   puts {<html>
     7         -<head><title>SQLite: An SQL Database Engine Built Atop GDBM</title></head>
            7  +<head><title>SQLite: An SQL Database Library Built Atop GDBM</title></head>
     8      8   <body bgcolor=white>
     9         -<h1 align=center>SQLite: An SQL Database Engine Built Atop
            9  +<h1 align=center>SQLite: An SQL Database Library Built Atop
    10     10   <a href="http://www.gnu.org/software/gdbm/gdbm.html">GDBM</a></h1>
    11     11   <p align=center>}
    12     12   puts "This page was last modified on [lrange $rcsid 3 4] GMT<br>"
    13     13   set vers [lindex $argv 0]
    14     14   puts "The latest SQLite version is <b>$vers</b>"
    15     15   puts " created on [exec cat last_change] GMT"
    16     16   puts {</p>}
    17     17   
    18     18   puts {<h2>Introduction</h2>
    19     19   
    20         -<p>SQLite is an SQL database engine built on top of the
    21         -<a href="http://www.gnu.org/software/gdbm/gdbm.html">GDBM library</a>.
    22         -SQLite includes a standalone command-line
    23         -access program (<a href="sqlite.html">sqlite</a>)
    24         -and a C library (<a href="c_interface.html">libsqlite.a</a>)
    25         -that can be linked
    26         -with a C/C++ program to provide SQL database access without
    27         -a separate RDBMS.</p>
           20  +<p>SQLite is an SQL database library
           21  +(<a href="c_interface.html">libsqlite.a</a>) that uses
           22  +<a href="http://www.gnu.org/software/gdbm/gdbm.html">GDBM</a>
           23  +as its underlying file storage mechanism.
           24  +Programs that link the SQLite library can have SQL database
           25  +access without running a separate RDBMS process.
           26  +The distribution comes with a standalone command-line
           27  +access program (<a href="sqlite.html">sqlite</a>) that can
           28  +be used to administer an SQLite database and which serves as
           29  +an example of how to use the SQLite library.</p>
    28     30   
    29         -<h2>Important News Flash!</h2>
    30         -<p>
    31         -The SQLite file format was changed in an incompatible way on
    32         -Aug 2, 2000.  If you are updated the library and have databases
    33         -built using the old version of the library, you should save your
    34         -old databases into an ASCII file then reimport those
    35         -database using the new library.  For example, if you change the
    36         -name of the old <b>sqlite</b> utility to "old-sqlite" and
    37         -change the name of the old database directory to "old-db", then
    38         -you can reconstruct the database as follows:</p>
    39         -
    40         -<blockquote><pre>
    41         -echo .dump | old-sqlite old-db | sqlite db
    42         -</pre></blockquote>
    43         -
    44         -<p>This file format change was made to work around a potential 
    45         -inefficiency in GDBM that comes up when large indices are created 
    46         -on tables where many entries in the table have the same index key.</p>
    47     31   
    48     32   <h2>Features</h2>
    49     33   
    50     34   <p><ul>
    51     35   <li>Implements most of SQL92.</li>
    52     36   <li>A database is just a directory of GDBM files.</li>
    53     37   <li>Unlimited length records.</li>
................................................................................
    84     68   <ul>
    85     69   <li>outer joins</li>
    86     70   <li>constraints are parsed but are not enforced</li>
    87     71   <li>no support for transactions or rollback</li>
    88     72   </ul>
    89     73   </p>
    90     74   
           75  +<h2>Important News Flash!</h2>
           76  +<p>
           77  +The SQLite file format was changed in an incompatible way on
           78  +Aug 2, 2000.  If you are updated the library and have databases
           79  +built using the old version of the library, you should save your
           80  +old databases into an ASCII file then reimport the
           81  +database using the new library.  For example, if you change the
           82  +name of the old <b>sqlite</b> utility to "old-sqlite" and
           83  +change the name of the old database directory to "old-db", then
           84  +you can reconstruct the database as follows:</p>
           85  +
           86  +<blockquote><pre>
           87  +echo .dump | old-sqlite old-db | sqlite db
           88  +</pre></blockquote>
           89  +
           90  +<p>This file format change was made to work around a potential 
           91  +inefficiency in GDBM that comes up when large indices are created 
           92  +on tables where many entries in the table have the same index key.</p>
           93  +
    91     94   <h2>Documentation</h2>
    92     95   
    93     96   <p>The following documentation is currently available:</p>
    94     97   
    95     98   <p><ul>
    96     99   <li>Information on the <a href="sqlite.html">sqlite</a>
    97    100       command-line utility.</li>