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

Re: Object Oriented Pattern help

by bjelli (Pilgrim)
on May 12, 2001 at 13:57 UTC ( [id://79931]=note: print w/replies, xml ) Need Help??


in reply to Object Oriented Pattern help

I know you want to program the stuff for yourself, but you might get some ideas by reading code:

There is a module Class::DBI that helps you create a Class that is closly linked to one Table in a Database.

It reuses the DB connection, and there is a function set_sql to generate reusable sql-statements (and statement handles).

--
Brigitte    'I never met a chocolate I didnt like'    Jellinek
http://www.horus.com/~bjelli/         http://perlwelt.horus.at

Replies are listed 'Best First'.
Re: Re: Object Oriented Pattern help
by thefid (Friar) on May 12, 2001 at 19:09 UTC
    The module Class::DBI was exactly what I was looking for... thanks!

    Like koolade suggested, it may not be a good idea to open a database connection for every object, since I may have the case where a query for guests may return up to 100 objects. It looks like this module is efficient in that respects using the module Ima::DBI where it states:

    Holds off opening a database connection until necessary. While Ima::DBI is informed of all your database connections and SQL statements at compile-time, it will not connect to the database until you actually prepare a statement on that connection. This is obviously very good for programs that sometimes never touch the database. It's also good for code that has lots of possible connections and statements, but which typically only use a few. Kinda like an autoloader.

Log In?
Username:
Password:

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

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

    No recent polls found