Hello,
  1. I once worked at a company where the policy was: you can select anything you want, but database updates/inserts are always done through stored procedures. I think the point of preventing developers from doing any update/inserts was to insure that only "logical" (and documented) entities and relationships could be committed to the database
  2. Where I work now, I've noticed a tendency for entities and relations to creep into Perl code - you see things like testing where a product_type is a certain subproduct type and then doing a certain set of insert/update operations as opposed to another.
  3. DBIx::Class is a wonderful tool. Powerful, support for many databases. Large user commmunity. That being said, I think it can be tempting for "entity-relation creep" to occur with it and it should be restricting to using entities entirely modelled in the database. Why? What happens if you decide to write some code in a different language? The more that's in the database, the more that each language can share.
Feedback on how you work to have a "fat model and skinny controller" are welcome.

I found one related node but it has not been updated in a long time.



The mantra of every experienced web application developer is the same: thou shalt separate business logic from display. Ironically, almost all template engines allow violation of this separation principle, which is the very impetus for HTML template engine development.

-- Terence Parr, "Enforcing Strict Model View Separation in Template Engines"

In reply to How aggressive is your database leverage in application development? by metaperl

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.