Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: Maybe database tables aren't such great "objects," after all ...

by BrowserUk (Patriarch)
on Mar 25, 2011 at 20:31 UTC ( [id://895588] : note . print w/replies, xml ) Need Help??


in reply to Re: Maybe database tables aren't such great "objects," after all ...
in thread Maybe database tables aren't such great "objects," after all ...

I've seen the following design a few times, and it's my favourite:

I could not agree more. SQL has no place in application code.

And with Postgres' PL/Perl, you can move most of the heavy lifting into the database, close to the data, often avoiding huge comms overhead, whilst sticking with the powerful, intuative (procedural) language we know and love, for performing the manipulations.


Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
  • Comment on Re^2: Maybe database tables aren't such great "objects," after all ...