CRUD!

[dbo]

So, in my never ending brainstorming I've landed on creating some sort of CRUD system. I've not really dealt with any in practice... so question 1 is: are there any lightweight CRUD systems that you suggest? I'd prefer to not sort through a framework that does it, but more of a standalone system.

 

If that doesn't prove fruitful here is what I'm thinking:

 

Request comes in for whatever module/table type deal. I query that table and pull back a list of fields and datatypes. Form is generated based on the DB datatypes. TEXT => textarea, VARCHAR => text, TINYINT => checkbox or something like that. Depending on the action the form gets prefilled or not, and has some buttons available.

 

Problem is you're typically going to have foreign keys and what not, so while a text field would technically work, you'll have to lookup primary keys to enter here. So, the above will function as the default action, but can be overrode. So like, I'll first look for /Views/CRUD/Update/news.php or some crap, if it exists I'll load up the form, if it doesn't I'll use the default method as stated above.

 

As usual, these are just random firings going on in my head. I'm very interested in hearing more from the folks who have dealt with these systems or who have built their own. Really interested in more the approach than the actual development.

 

Thanks guys!

[dbo]

Come on you guys. Gimme some love on this.

[mb81]

dbo, you may want to check out the scaffolding feature with codeigniter (www.codeigniter.com)

 

I have been trying to develop a customized CMS/module based system that will have these types of things also.

[dbo]

Thanks for the reply, I'll definitely look into it closer.

 

Maybe we could develop this thing together as a stand alone module and then integrate it into our own stuffs!