[Cialug] mysql database design

[Matthew Nuzum]

On 8/9/07, Nathan C. Smith <nathan.smith at ipmvs.com> wrote:
> Does MySQL have triggers now?
>

I guess so: http://dev.mysql.com/doc/refman/5.0/en/triggers.html

I haven't used them. Anytime someone brings up that point I'm quick to
say, "Postgres does - and has had them for many years." I try hard not
to use MySQL too much, so I don't get into its more advanced features.

I saw the release announcement for Storm 0.10 today
<http://mail.python.org/pipermail/python-announce-list/2007-August/006048.html>
and was intrigued by something I saw. Storm is a python ORM tool
(created here at Canonical). They've added a new hook,
__storm_pre_flush__, which lets you implement a method on your model
that gets called before an object is "flushed to the database."

Maybe this is common among some of the more mature ORM
implementations, but I'll tell you, if I had my choice of writing
triggers in pl/sql or etc and python, I'd choose Python any day of the
week.

I'm really in love with ORM. It feels so natural to do
comment.save()

-- 
Matthew Nuzum
newz2000 on freenode