Perl-Sensitive Sunglasses PerlMonks

### Re: OO concepts and relational databases

by water (Deacon)
 on Aug 09, 2004 at 00:30 UTC ( #381133=note: print w/replies, xml ) Need Help??

in reply to OO concepts and relational databases

A table is not a class, a row is not an instance, and a column is not an attribute.

True.

We've begun using Class::DBI as a layer over the database, but clearly the CDBI is a "storage object", not an "idealized object" (just made up those labels).

Say we have a Zoo, full of Exhibits and Animals and Vets and so forth. We tend to divvy up our tables into logical groups across multiple databases (ease of backup, replication, etc), vs. having every table in the same database. So we might have tables of

Animal.animal, Animal.Medical, Animal.Feeds, Animal.MammalDetail
[download]
And in CDBI, the objects corresponding to the tables would be  Animal::Animal, Animal::Medical, Animal::Feeds, Animal::MammalDetail, etc.

So we might have a class Animal (subclassed into Mammal, Reptile whatever), which represents the OO concept of an animal, with corresponding data and methods

$a=Animal->new(%attribs);$a->feed(%feedinfo);
\$a->medical_checkup(%careinfo);
[download]
And there's also the "storage object" class  Animal::Animal, which is just a nice CDBI wrapper around the table Animal.Animal.

We don't force methods onto the "storage objects" (except database-esque methods), and we allow the "idealized objects" to create, hold, and use "store objects" internally to manage their persistence and interaction with the greater system.

So yes, an class isn't a table and a row isn't an instance, but in CDBI-world they are, which is useful and fine. Just don't then try to cram your application-logic into that tiny space, for it is too small and won't fit. Let CDBI or whatever encapsulate the database (highly recommended), then use that encapsulation within a higher "idealized object" that models something meaningful.

Perhaps this ramble makes sense to someone else besides myself... Great thread, dragonchild. Thanks.

Create A New User
Node Status?
node history
Node Type: note [id://381133]
help
Chatterbox?
 [Corion]: thezip: If you want to open vim and can live with opening a second console window, use start "The results" vim.exe c:\path\to\logfile .log [thezip]: Ooops... I lied. I guess Cygwin is back. I'll just do a tail -f instead. Better. Sorry for the noise. [Corion]: Once more, I'm looking for a sane client-side framework, but I guess these don't exist. Everything I look at either uses a weirdo home-grown templating language (like Angular in all its incarnations) or uses weirdo Javascript incarnations (like ... [Corion]: ... Inferno.js, which uses ES2015) or uses some horrible amount of Javascript infrastructure before you can even render a single file.

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (13)
As of 2017-03-27 18:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
Should Pluto Get Its Planethood Back?

Results (321 votes). Check out past polls.