MPSQL - An Interactive Query Tool for PostgresSQL 

This directory contains version 2.1 of MPSQL.

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

or visit http://www.mutinybaysoftware.com

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

ABOUT MPSQL:

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 Redhat Linux 5.1, 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
* cancel running queries
* work with multiple buffers
* color syntax highlighting
* open/save buffers from/to files
* cut/copy/paste between buffers
* find/replace buffer text
* spool query output to a file
* format output as HTML tables
* spool data in fixed length, comma, tab or space delimited format
* print buffers
* supports PostgreSQL username & password authentication
* save application options to a startup file ($HOME/.mpsql_cfg)
* context sensitive help
* online PostgreSQL and SQL references

REQUIREMENTS:

PostgresSQL libpq 6.4+
Motif or LessTif
libXpm.so.4.3+

INSTALLING:

The following should work on most systems:

Modify the config.inc to set the bin and help directories and then:

xmkmf
make Makefiles
make depend
make
make install (make sure you have permissions to install locations)

If this doesn't work the try checking the Imakefiles
and modify the include and lib paths as needed and try
the above steps again.

To make sure the application can find the help files, add
the following environment variable to your profile:

MPSQL_HELP_PATH=<path where you installed the help files>

The default is '/usr/local/mpsql/help'

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!!

HISTORY:

--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.

--v.1.5.1

	added missing defaults file to distribution

--v.1.5.2
	
	recompiled static binaries for use with PostgresSQL v.6.2

--v.1.5.3
	
	recompiled static binaries for use with PostgresSQL v.6.3
	
	fixed a boolean type declaration in mpsql that was conflicting
	with a boolean type in libpq

--v.2.0 beta 1

	added online help (HTML) using libhelp by Thomas Harrer.
	help included:
		1. MPSQL application help
		2. PostgreSQL programs and utilities
		3. SQL reference
	added context sensitive help to the application

--v.2.0 beta 2

	never released

--v.2.0 beta 3

	added color syntax highlighting to the editor - nedit text widget
	added HTML output option
	added PostgreSQL username & password authentication - ( via -U cmd switch )
	added startup code to check for color depth w/ color pixmaps
	modified application option file layout - ( you can read it ! )
	fixed output to align and size dynamically - no more column width settings

--v.2.0	final
	changed libhelp libmbshelp to eliminate conflicts with standard libhelp.

--v.2.0.1
	updated SQL keyword list
	config.inc allows user to set motif lib locations
	fixed bool type problem in db.c
	fixed broken connection reference in PGresult
	added updated html docs from PGSQL distribution

--v.2.0.2
	fixed formatting code that was causing a core dump
	    e.g. using standard output with HTML formatting
	
--v.2.0.3
	changed tab size from 4 to 3
	changed string highlight color to magenta
	more keyword corrections & addtions
	execution of SQL statement with semicolons embedded in single
		quoted string should now work - this was to correct a
		problem with using MPSQL to create PL/PgSQL functions.

--v.2.1
	added query cancellation. (toolbar or Ctrl-Z)
	added text search (menu or Ctrl-F)
	added text search again (Ctrl+G)
	added text replace (Ctrl-R)
	added tab setting to options
	fixed dialogs to set focus to specific widgets
	fixed HTML output core dumps
	changed config file from .mpsql_cfg to .mpsqlrc
	add versioning to the config file to sync with future versions

TODO:

Fix Bugs ;-)

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 MUTINY BAY 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 MUTINY BAY SOFTWARE HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGE.

MUTINY BAY 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 MUTINY BAY SOFTWARE HAS NO OBLIGATIONS TO
PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.