1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
|
MPSQL - An Interactive Query Tool for PostgresSQL
This directory contains version 2.0 beta 3 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 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
* work with multiple buffers
* color syntax highlighting
* open/save buffers from/to files
* cut/copy/paste between buffers
* 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.3+
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
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.
|
