Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^3: Sybase DB Library vs Client Library API

by roboticus (Chancellor)
on Aug 02, 2012 at 11:35 UTC ( #985009=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Sybase DB Library vs Client Library API
in thread Sybase DB Library vs Client Library API

perl@1983:

The reason I prefer the DBI/DBD route is that you use the same interface for *any* database. Here at $work, I work with Oracle, MSSQL, SQLite and occasionally PostgreSQL. When I have to interact with a particular database, I don't have to ask myself questions like:

  • OK, how do I read a result set with *this* database?
  • Can I use placeholders in my query? If so, how do I do that?
  • What data structure get I get my results in?

Since DBI provides a standardized interface, I can be immediately productive when I switch back to a database I use rarely, without having to reacquaint myself with a module I haven't used in a year.

Sure, there are some occasional differences between the databases, but DBI / DBD lets me ignore most of them. Occasionally, I'll need a special database-specific feature and have to read DBD::Oracle or some such. But better that than having to read documentation on all the everyday operations for selecting, inserting, updating and deleting.

That's my 1/50 of a dollar.

...roboticus

When your only tool is a hammer, all problems look like your thumb.


Comment on Re^3: Sybase DB Library vs Client Library API
Download Code
Replies are listed 'Best First'.
Re^4: Sybase DB Library vs Client Library API
by perl@1983 (Sexton) on Aug 03, 2012 at 08:30 UTC
    Thank you for the detailed reply roboticus. It is helpful.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://985009]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (20)
As of 2015-07-31 14:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (278 votes), past polls