UNIX scripting - database interface library?

[wallg]

Is there a database interface library available for UNIX scripting? (such as Perl has oraperl and sybperl)

Thanks.

[chazzy]

probably dependent on what shell you're using and what flavor of unix you've got.

[wallg]

It is Korn shell or Posix shell on HP-UX 11i. Database will probably be MySQL or Sybase. (Unless you have another recommended DB)

[chazzy]

It is Korn shell or Posix shell on HP-UX 11i. Database will probably be MySQL or Sybase. (Unless you have another recommended DB)

Well with kshell I'm fairly certain you're limited to executing everything via a secondary command line app (such as the mysql command, or sqlplus). So you'd be stuck just sending everything via command line like this:

mysql -u user -ppassword commands....

Unfortunately, I know nothing about posix.

[drhowarddrfine]

Posix shell? Never heard of it. It can be Posix compliant but is there a Posix shell?

[NogDog]

Well with kshell I'm fairly certain you're limited to executing everything via a secondary command line app (such as the mysql command, or sqlplus). So you'd be stuck just sending everything via command line like this:

mysql -u user -ppassword commands....

Unfortunately, I know nothing about posix.
That's what I used to do, using SQL*Plus commands within a Korn shell to connect to an Oracle DB. Been quite a few years since I did that, though. :)

In any case, note that Perl (or PHP for that matter, too) scripts can be run as command line scripts, allowing you to use available/built-in DB libraries; and most *nix hosts these days have both installed.