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