CRUD Generator Suggestions

geekondemand has asked for the wisdom of the Perl Monks concerning the following question:

I'm in a situation where I need to create a fairly large number of web applications to do basic CRUD web applications for a large number of database tables. The tables involved don't have similar schemas. This is basically to generate the first cut at an admin area for a web application.

I'm thinking of writing something to generate the applications in code that uses CGI::Prototype as I like it's "feel", but I'm not tied to it.

The database is well designed in Postgres. I'm primarily looking at just considering single table applications which don't worry about master-detail relationships. I only mention this because I think that databases that allow definitions of foreign key constraints might allow upgrades of the application of describing to master-detail and other complex relationships.

While I think this is something useful to play with, I'm wondering if there are applications out there that will generate CRUD appliations as Perl CGI scripts? Of course, it'd be nice if it could do master-detail and other more complex things as well.

Have any of you learned monks come across such a beast? Any advice on building one?

Comment on CRUD Generator Suggestions

Replies are listed 'Best First'.
Re: CRUD Generator Suggestions by ghenry (Vicar) on Jan 07, 2006 at 11:26 UTC
See the Catalyst Scaffolding Movie or CRUD Transcript Very easy. Walking the road to enlightenment... I found a penguin and a camel on the way..... Fancy a yourname@perl.me.uk? Just ask!!!	[reply]
Re^2: CRUD Generator Suggestions by Aristotle (Chancellor) on Jan 07, 2006 at 13:53 UTC
See also Catalyst::Enzyme and build_enzyme_app. Makeshifts last the longest.	[reply]
Re: CRUD Generator Suggestions by b10m (Vicar) on Jan 07, 2006 at 13:06 UTC
I've looked at CGI::Application::Plugin::BREAD a while back and although (back then) it was very experimental, I was rather impressed with its ease. Might be something you want to look into. -- b10m All code is usually tested, but rarely trusted.	[reply]
Re: CRUD Generator Suggestions by perrin (Chancellor) on Jan 07, 2006 at 17:40 UTC
The perl apps with the best support for auto-generated CRUD that I've seen are Maypole and OpenInteract2. Maypole has beautiful HTML, and OpenInteract2 has very flexible code. Both may be overkill for what you're doing though.	[reply]
Re^2: CRUD Generator Suggestions by fmerges (Chaplain) on Jan 07, 2006 at 19:19 UTC
Hi, I use both, Catalyst and Maypole, and for CRUD I think is better to use Maypole if you don't think into doing more than this (CRUD), but if you want to only have a CRUD to have something "on the way" to finally do a Webapps that envolves more things, or don't work standalone, instead merged with your site/app go for Catalyst. I use both things, I have some webapps like a inventory for our department where I use Maypole, looks great, feels well, and don't spent time to add fancy things or other stuff because I only want a good looking CRUD. On the other hand, when I need to do a standalone webapps I go for Catalyst, because is more active development there and is cleaner when you want something not-by-default-crud. For websites I use Mason, I'll like it, have many components written, and is very straighforward to create homogenous sites and a nice inheritance model component-based. And you can also combine Cayalyst with Mason. Regards, fmerges at irc.freenode.net	[reply]