Hi Michael... I really wanted to use CRUD tools when starting 1000 Corks - http://1000corks.com
I tried Catwalk for a while but it really didn't work for anything that I wanted to do. So I am glad you guys are working on this. > Is your admin interface web based? > Is it hand written, or do you use existing CRUD solutions? We ended up basically writing our own Admin interface. It was a useful exercise that I'm not sure CRUD tools could give us. For example if someone puts in a toll free number in the field that is for non-toll free numbers, JavaScript offers to move it for them. We try very hard to make sure that we never have to use the command line, that everything should be in the Admin interface. We are very close---but probably like every website we occasionally have to do things manually. > Who enters the data? > Script / developer / admin/ secretary? > How many persons use the admin interface? We have only two people, one who would perhaps be classified as admin, and one (me) as developer. > How long per day are they supposed to work with it? About four hours a day. > Are there granular permissions requirements? Given the small number of people, we mainly use warning messages instead of actual permissions. For example if someone wants to delete the wines of a particular store from the database, they can. But they are forced to type the word "delete" into a pop-up. That hopefully makes them think about it. We do have one table which only I can edit. That is controlled by only allowing me to access that page using identity. > How many tables does your database contain? Or can you give any > measure for the complexity? Wow, I just counted them and we have 75. I would have guessed we only had 35. Amazing! A few of them are automatically created/controlled by the versioning extension of sqlobject. > Do you use additional tools for your database for querying/editing the > data? I find phpPgAdmin to be absolutely invaluable. I like phpMyAdmin even better, it has a few great features that the PostgreSQL one lacks. But I am using Postgres, so I have to use the former. I think both of them are really great tools, and I encourage you to look at them closely. I've written fairly sophisticated backup tools of my own, but that's not quite the same thing as querying/editing. > What additional requirements do you have, that are not fulfilled by > todays CRUD packages? Where to start? ;) I hope that whatever you guys right will be not just monolithic, but can also be used to help making write our own CRUD stuff easier. I hope this helps. -Sam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
