UNIX scripting - database interface library?
Is there a database interface library available for UNIX scripting? (such as Perl has oraperl and sybperl)
probably dependent on what shell you're using and what flavor of unix you've got.
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:
Originally Posted by wallg
Unfortunately, I know nothing about posix.
mysql -u user -ppassword commands....
Posix shell? Never heard of it. It can be Posix compliant but is there a Posix shell?
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.
Originally Posted by chazzy
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.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)