MPSQL - An Interactive Query Tool for PostgresSQL 

This directory contains version 1.5 of MPSQL.

The author can be reached via Email: keidav@whidbey.com

or visit http://www.troubador.com/~keidav/index.html

MPSQL is not public domain software.  It is copyrighted by White
River Software but may be used according to the licensing
terms of the the copyright at the end of this document.

HISTORY:

MPSQL was born out of the need for a usable query tool to help me with
working with PostgresSQL while prototyping a database backed WWW application.

You will have excuse some of the bad coding practices in this release, while 
trying to write a real app and a tool at the same time something gives ;) 
if any interest in this comes up I will clean things up.  So if you do find 
this useful, please drop me a mail message with your comments! (mail address above)

I have only tested this under Linux and Solaris 2.5, but it is generic enough it 
should compile under other UNIX systems as well.

FEATURES:

* execute multiple SQL statements or one of many by highlighting then executing
* work with multiple buffers
* open/save buffers from/to files
* cut/copy/paste between buffers
* spool query output to a file
* spool data in fixed length, comma, tab or space delimited format
* print buffers
* save application options to a startup file ($HOME/.mpsql)

REQUIREMENTS:

PostgresSQL 6.0 - libpq
Motif 2.0 - a statically linked binary is available!
libc.so.5+
libdl.so.1.7+
libXxxx.so.6
libXpm.so.4.3

INSTALLING:

The following should work on most systems:

Check the Imakefile and make any required changes. Then,

xmkmf
make
make install

If this doesn't work the try editing Makefile.std
and modify the include and lib paths as needed and ...

make -f Makefile.std
cp mpsql /usr/bin (or whatever...)
cp Mpsql.ad /usr/X11/lib/X11/app-defaults/Mpsql

RUNNING:

After installing, start the app (mpsql) and select the "Connect to DB" 
option from the "File" menu or the "Connect" button on the tool 
bar to logon, an error dialog will come up if unsuccessful or the 
status bar will verify a successful connection with the name of 
the database.

BUGS:

I am sure you will find some undocumented "features" ;) and if you do
please fill out the bug.template and mail it to me. Thank-you!!

--v.0.9.1

	first beta release

--v.0.9.2

	implemented a more elegent solution to String redef problems with
	<libpq-fe.h> and <X11/Intrinsic.h> , what was I thinking of before %) 
	thanks to Ronald Wahl <Ronald.Wahl@Informatik.TU-Chemnitz.DE> for 
	pointing out the obvious. 

--v.1.0.0
	
	command line arguments now supported for: host, port, database and help.
	
	user is now prompted with a file 'Save As' dialog when selecting 'Save'
	for 'Scratch' buffers.

	application now grabs keys & buttons while processing a query & displays
	watch cursor while processing query.

	support has been added for the postgres 'Copy' commands.

	fixed memory leak that occurred when calling DB_Connect().

	buffer list is now available as a pulldown menu.

--v.1.5.0
	
	basically done to verfiy code works with PostgresSQL v.6.0.

	added tooltips.

	stderr redirected so EXPLAIN results are shown in application.

	Imakefile added.
	
	optional highcolor pixmaps (afterstep-ish appearence).	

	application icon should now display properly under different WM's.


TODO:

I am considering merging the createdb, createuser, and dump apps into this
application as well.  I will be adding a loader utility similar to Sybase's and
Oracle's loader utilities in the near future.

Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement
is hereby granted, provided that the above copyright notice and this
paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL WHITE RIVER SOFTWARE BE LIABLE TO ANY PARTY FOR
DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
DOCUMENTATION, EVEN IF WHITE RIVER SOFTWARE HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGE.

WHITE RIVER SOFTWARE SPECIFICALLY DISCLAIMS ANY WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
AND FITNESS FOR A PARTICULAR PURPOSE.  THE SOFTWARE PROVIDED HEREUNDER IS
ON AN "AS IS" BASIS, AND WHITE RIVER SOFTWARE HAS NO OBLIGATIONS TO
PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.