Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^3: Sybase DB Library vs Client Library API

by roboticus (Canon)
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
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 taking refuge in the Monastery: (8)
As of 2014-09-16 18:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (40 votes), past polls