www.webdeveloper.com
Results 1 to 6 of 6

Thread: UNIX scripting - database interface library?

  1. #1
    Join Date
    Nov 2007
    Posts
    13

    UNIX scripting - database interface library?

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

    Thanks.

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    probably dependent on what shell you're using and what flavor of unix you've got.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  3. #3
    Join Date
    Nov 2007
    Posts
    13
    It is Korn shell or Posix shell on HP-UX 11i. Database will probably be MySQL or Sybase. (Unless you have another recommended DB)

  4. #4
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    Quote Originally Posted by 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)
    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:

    Code:
    mysql -u user -ppassword commands....
    Unfortunately, I know nothing about posix.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  5. #5
    Join Date
    May 2005
    Posts
    2,040

  6. #6
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,148
    Quote Originally Posted by chazzy
    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:

    Code:
    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.
    "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

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles