Problems? Is your data what you think it is? | |
PerlMonks |
(pmas) DBI or Win32::ODBC: which way to go?by pmas (Hermit) |
on Jul 26, 2001 at 19:41 UTC ( [id://100018]=note: print w/replies, xml ) | Need Help?? |
Your goal (database independence) is right, but I am not so sure about your way to achieve it. DBI.pm is the way to database independent data access, and was designed along ODBC guidelines - early adopter. DBI allows you to move your code from Win PC with some ODBC-compliant database to i.e. Linux and database which may or may not be ODBC-compliant, just DBI-compliant driver will be enough. You are using two layers of interfaces: (1) from your program to local database access client, and (2) from PC to database server (which might be on the same PC, LAN, or internet). I might be wrong here with performance issue (you did not mentioned how important it is for you), so you may want to impement both, and benchmark. Or maybe somebody here can advise on performance issue - or ask in dbi-users mail list.
I myself prefer DBI and am happy with it. pmas
In Section
Seekers of Perl Wisdom
|
|