[Catalyst] user maintenance

John Goulah jgoulah at gmail.com
Sat Sep 1 03:57:58 GMT 2007


On 8/31/07, Toby Corkindale <tjc at wintrmute.net> wrote:
>
> Michael Higgins wrote:
> > Hello, list --
> >
> > I have a catalyst app about to get a bunch of new users. In
> > anticipation of that, I'd like advice on how to maintain the
> > user/acl tables I set up per the tutorial.
> >
> > Basically, I just want to add the user and have a default role
> > automagically appear in the corresponding acl table. When I delete the
> > user, the user's role(s) go as well.
> >
> > Which of the catalyst options would give me the quickest route to
> > maintaining this list? And what is the best way to ... create
> > related entries and cascade delete? (I'm still new at this.)
>
> Are you using MySQL? If so, stop using it, and start using a relational
> database that supports foreign keys and cascaded deletes - and example
> of an opensource DB with those is PostgreSQL.




MySQL Innodb tables -does- provide foreign key constraints...
DBIx::Class::Schema will create the tables as this type with constraints
defined as well.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070831/44ded=
998/attachment-0001.htm


More information about the Catalyst mailing list