I'm not sure it's a Web2py limitation so much as an SQL limitation. You actually might be able to implement dynamic schemas in Web2py I guess by building your define_tables() on-the-fly but it doesn't sound like the best idea (you'd need to be doing a lot of unpredictable migrations).
But dynamic schemas are where NoSQL DBs really shine. There's some degree of support for Mongo in Web2py but I think it's fairly preliminary. You could also program directly to Mongo but you'd lose DAL features (which might not be too bad). On Thursday, June 7, 2012 3:47:00 AM UTC-7, Christian wrote: > > Hi pbreit and thanks for the reply. > So web2py is not the preferred way to go as DAL needs a scheme? Is there > no way to integrate DAL in a dynamic way? > > Regards, > Christian > > Am Sonntag, 3. Juni 2012 schrieb pbreit : > >> My guess is it's NoSQL, probably Mongo which seems to be the preferred DB >> behind a lot of these "real-time" JavaScript frameworks. >> >> >> On Sunday, June 3, 2012 2:35:34 AM UTC-7, Christian wrote: >>> >>> Hello group, >>> >>> I found a backend service, mostly for mobile apps, called parse.com. >>> Looking at their REST documentation (https://parse.com/docs/rest), it >>> looks like one can e.g. dynamically generate different kind of objects, >>> which get persistet (see "creating objects" in the docs to see what I >>> mean). These objects can get relationships to other objects and can also be >>> queried. So if the client posts GameScore or GameScores, both are valid >>> (but different) objects (in different tables?) and get persisted, >>> My questions: how looks sth. like this on the model side? How is this >>> done? How to model general tables and still make them queryable. Or does >>> the model generate tables dynamically? Could something like this be modeled >>> with DAL? >>> On the controller side: could such a dynamic model be made available via >>> sth like @request.restful? >>> >>> I would be happy for any hint, as I have no idea, how this is done! >>> >>> Thanks and regards, >>> Christian >>> >>> P.S.: I also found a open source clone, which rebuilds the iOS client >>> library and the server with node and MongoDB, if this might be of any help. >>> I do not speak JS and have no clue about mongo. >>> https://github.com/eaigner/**DataKit<https://github.com/eaigner/DataKit> >>> >>>
