I've always wanted to define variables on the fly from user input, or
output a prompt and get the user's input. Now you can use

:define something=<<

which will define the variable "$something" from the 255 characters read
from whatever the current input descriptor is. Very cool.

For more information visit <http://gagne.homedns.org/~tgagne/is/>

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org

How does your 'is' program compare with 'sqsh'?

--
Ed Avis <ed (AT) membled (DOT) com>

That's a great question, and I wish I could give you a decent answer.

Mine originated in '89 or '90. Certainly it was finished by '91. I've
had little need for another. Perhaps I'll take a look at sqsh...

Ed Avis wrote:

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org

Hmm. A quick review of sqsh and all I can see is a) I've done work to
it in the last 2.5 years ;-) and b) is provides a customizable prompt
that I use to display server and databasename. After than, sqsh is
pretty much more feature-rich.

Ah! I also notice sqsh was rewritten with ctlib, and I haven't bothered
yet. is still uses dblib. I didn't see much compelling in ctlib.

Ed Avis wrote:

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org

Thomas Gagné <tgagne (AT) wide-open-west (DOT) com> wrote in
news:403EC32F.7030601 (AT) wide-open-west (DOT) com:

How about you take over sqsh and put in the features of 'is'?

I like sqsh's use of GNU readline.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

On Thu, 26 Feb 2004 23:05:00 -0500, Thomas Gagné wrote:

Which means that you use dblib, right?

Easier to code to, but unfortunately won't support some of the newer
datatypes (wide varchar, in particular).

Michael

--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

On Fri, 27 Feb 2004 11:21:22 +0000, Pablo Sanchez wrote:

and redirection.

Those are the two things I use most.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote in
newsan.2004.02.27.15.21.47.770373 (AT) peppler (DOT) org:

Oh yes, how could I have forgotten ... I also thought of taking the
s/w and making it work for Oracle but never seem to have the time.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

is does the redirection as well with syntax similar to sqsh. I like
where sqsh puts the redirection--after the "go". I didn't notice if
sqsh supports input redirection--allowing SQL to be read from multiple
places. It probably does.

Michael Peppler wrote:

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org

I wonder how difficult that would be. Of course it would be easier
using ODBC, but setting up ODBC on Linux seems a hassle. I've started
it a couple times but never got all the right components.

Pablo Sanchez wrote:

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org