Ancient. Even Class::DBI has tools to automatically generate classes from your database and Rose::DB::Object takes that much further, including constraints.
- Perrin On Mon, Mar 2, 2009 at 6:49 AM, Jonathan Yu <jonathan.i...@gmail.com> wrote: > A quick update- > > I failed to notice that the article is from 2006, and I'm not sure if > things have changed since then. I didn't do my homework, or else I > would have seen that SQL::Translator does have Constraint parsing for > CHECK constraints. Silly me. > > On the other hand, does DBIx::Class make use of this? I don't recall > reading anything in the documentation about it, so perhaps a doc patch > is in order. A cursory search of the Cookbook (ie, Ctrl+F search) for > the word "constraint" doesn't turn up anything. Did I miss something? > > Cheers, > > Jonathan > > On Mon, Mar 2, 2009 at 6:40 AM, Jonathan Yu <jonathan.i...@gmail.com> wrote: >> Hi all: >> >> Just wondering what all of your thoughts are with respect to this >> article: http://dave.org.uk/talks/lpm/2006/orm/ >> >> I think he raises some valid points, so it's worthwhile to see what we >> can do in terms of patching SQL::Translator to provide a better >> interface. >> >> This is cross-posted to two mailing lists (DBIx::Class and >> SQL::Translator), so you may not see all replies unless you are part >> of both lists. >> >> I think the thing about constraints is important. Is it possible to >> implement custom constraints on data? What I mean is, parse the >> constraint from the SQL database, and then use that to validate data >> prior to INSERTs and UPDATEs? Then you could validate data before it >> even enters the database. >> >> Cheers, >> >> Jonathan >> > > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > -- > sqlfairy-developers mailing list > sqlfairy-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers > ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
