Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re^3: Sybase DB Library vs Client Library APIby roboticus (Chancellor) |
on Aug 02, 2012 at 11:35 UTC ( [id://985009]=note: print w/replies, xml ) | Need Help?? |
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:
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.
In Section
Seekers of Perl Wisdom
|
|