I'd like to set up a collaborative data modeling environment where multiple governmental licensing agencies jointly participate in designing an open source data model. (They license doctors, dentists, pharmacies, etc.)
The default web2py bundle is almost perfect for this except that sqLite is not multi-user and I'd like users to have the option of something physically functional to try with their in-house Java/PL-SQL programmers, and become familiar with alternatives to proprietary databases. Because it is an opportunity to showcase web2py, I hope it's okay to ask our group for ideas regarding designing the environment. Would it work where users create the data model in Postgres first, and then I write code in web2py controller to express their ideas? This way, they can use Postgres GUI data model designer or just type in the table commands. In this case, I would like to find a way to solve complexities of DAL being out of sync with data definitions. I'm not yet skillful in resolving constraint/out-of-sync issues with Postgres/w2p. (Maybe prototype would have no constraints. Is there any utility that converts Postgres schema to web2py DAL?) I'm thinking users would create the Postgres database somewhere, maybe on Hostmonster.com, and I would upload a copy to PythonAnywhere each week to write the views and controller functions. Alternatively they could just email their ideas and I post them to the DAL which creates the Postgres tables but then if I got too busy I'd become the bottleneck. If I separated the project out so Postgres was independent of web2py, then users could carry on without me if I fell behind on creating views and functions. Any thoughts appreciated, Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
