Need testers for MySQL/PostgreSQL interface

William Park opengeometry-FFYn/CNdgSA at public.gmane.org
Thu Nov 25 06:06:04 UTC 2004


To: TLUGers with MySQL/PostgreSQL,

If you have reasonably complex MySQL and/or PostgreSQL database and do
reasonably complex search, then I would appreciate if you could try out
my shell wrapper around the database API.  I need to test them out on
wide variety of situations, but most of my own databases are simple
stuff.  

The wrappers are described in
    http://home.eol.ca/~parkw/index.html
    http://home.eol.ca/~parkw/index.html#postgresql
    http://home.eol.ca/~parkw/index.html#mysql
which is part of my patch to Bash shell,
    http://freshmeat.net/projects/bashdiff/

Short tutorial can be found at the bottom of
    http://home.eol.ca/~parkw/park-january.html
which is my article for LinuxGazette.net (Jan issue).  Essentially,
'Msql' and 'Psql' builtin commands send SQL statement to the server, and
save the output (if any) to shell array variable or print to stdout.

You need to patch and compile Bash shell,
    $ patch -p1 < ../bashdiff-core-1.11.diff
    $ patch -p1 < ../bashdiff-william-1.11.diff
    $ autoconf
    $ ./configure
    $ make bash
    $ make bash+william
After compile,
    $ ./bash+william		# newly compiled shell
    $ help Psql
    $ Psql [-...] "select ..."
    $ Psql -a var [-...] "select ..."
    $ ...
    $ exit			# back to your old shell


If there is any segfault, let me know. :-)

-- 
William Park <opengeometry-FFYn/CNdgSA at public.gmane.org>
Linux solution for data management and processing. 
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml





More information about the Legacy mailing list