LocalSQL

  Copyright (C) 2002 Dave Berton
  Copyright (C) 2001 Trolltech AS

  Contact:
	 Dave Berton (dberton @ gmail.com)
	 Jasmin Blanchette (jasmin@trolltech.com)

  This library is free software; you can redistribute it and/or
  modify it under the terms of the GNU Lesser General Public
  License as published by the Free Software Foundation; either
  version 2.1 of the License, or (at your option) any later version.

  This library is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  Lesser General Public License for more details.

  You should have received a copy of the GNU Lesser General Public
  License along with this library; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

LocalSQL
--------

LocalSQL provides a library and command line tool for direct
invocation and processing of SQL statements on local databases.  A
subset of SQL92 is implemented, notably:

INSERT
UPDATE
DELETE
SELECT (including joins, WHERE, HAVING, and GROUP BY clauses)
CREATE TABLE
CREATE INDEX
DROP TABLE

Sub-selects are not currently supported.  See README.SQL for more
information on exactly what is and is not supported.

LocalSQL requires Qt 3.0-snapshot or higher:

   http://www.trolltech.com/qt

Installation
------------

1. Ensure that Qt 3.x is installed and compiled.

2. To compile LocalSQL, from the top level of the LocalSQL directory,

	./configure
	make
	make install (note: hard coded to /usr/local at the moment)

If Qt headers/libs cannot be found, check your Qt installation. 

Ensure that liblsql.so is in your LD_LIBRARY_PATH.

Usage
-----

LocalSQL can be used as a database driver for Qt (compiled with SQL
support).  Just drop the library into $QTDIR/plugins/sqldrivers and Qt
will automatically load it.  See the Qt documentation for details on
the SQL module and SQL plugin drivers.

LocalSQL also has a command line tool called 'lsql' for manipulating
data.  For more information, type:

	lsql --help

For example, to run the example SQL script in the 'tests' subdirectory:

        cd tests/
        ../bin/lsql -v -f sample.sql



Comments and suggestions are welcome.

db