Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^3: Differences in SQL syntax when using DBI (are there any)? And help on publishing module on CPAN.

by techcode (Hermit)
on Jul 15, 2005 at 19:23 UTC ( [id://475337]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Differences in SQL syntax when using DBI (are there any)? And help on publishing module on CPAN.
in thread Differences in SQL syntax when using DBI (are there any)? And help on publishing module on CPAN.

Well Class::DBI folows different logic and IMHO somehow it feels strange - as the trs80 said : Class::DBI Intro
Class::DBI can be a powerful way of interacting with your databases, but it really requires a large scale project to reap the benefits and be worth the performance hit you take vs. doing traditional SQL queries. When using Class::DBI you are adding dynamic accessors for much of the data and the overhead of the method calls for all your operations. The benefit is less code, referral integrity (cascading delete), rollbacks in non transaction databases, reduction in lines of code, and increased portability since Class::DBI handles the abstraction across multiple database sources. If you are working on a large scale database centric application or you want to learn more about OO Perl Class::DBI is a good place to start.
I intended this for simple projects ...
  • Comment on Re^3: Differences in SQL syntax when using DBI (are there any)? And help on publishing module on CPAN.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2024-04-19 18:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found