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
