[Shacs] base line Hello World of rdbms examples for learning

[Bronius Motekaitis]

The buzzy phrase that escaped me was "design patterns."  Has anyone any
experience with design patterns to test the meddle of a development
framework with regard specifically to data integrity?  A simple
"quickbrownfoxjumpsoverthelazydogs" for testing triggers, cascades, etc.

bg: My director, a db purist, is not ready to let me loose on a simple
application to be built in Ruby on Rails.  He is not convinced (and I've
presented a lot of info confirming his conviction) that RoR will help and
enforce the data model in the database engine.  My contention is that RoR
does as fine a job enforcing data integrity as any mvc/orm framework, and
that at least in this case, it needn't be enforced by the db engine...
However, if it is decided that absolutely must move or duplicate logic down
to the db, then I want to demonstrate that putting the rules on mysql innodb
won't hamper development.

-bronius



On Thu, Jan 15, 2009 at 2:22 PM, Pilling, Drew <AAP006 at shsu.edu> wrote:

>  Good question! I've wondered this myself from time to time as a matter of
> general curiosity but I've never had the freedom/control to make use of this
> question in the decision making process of the organization I work for
> (SHSU). Thanks for posting it out there; I'm looking forward to seeing the
> replies if there are any.
>
>
>
> -Drew
>
>
>
> *From:* shacs-bounces at shsu.edu [mailto:shacs-bounces at shsu.edu] *On Behalf
> Of *Bronius Motekaitis
> *Sent:* Thursday, January 15, 2009 2:16 PM
> *To:* shacs
> *Subject:* [Shacs] base line Hello World of rdbms examples for learning
>
>
>
> Help?
>
> Is there a list of build or model (?) patterns I can apply to build a
> simple throw-away database driven application to test a given development
> framework for its ability to enforce, respect, and not be hindered by data
> integrity enforced at the database level?
>
> -bronius
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.shsu.edu/pipermail/shacs/attachments/20090116/3fbb8f54/attachment.html