Re: [web2py] Dynamic model creation

2012-06-07 Thread Christian Hoffmann
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

Re: [web2py] Dynamic model creation

2012-06-07 Thread pbreit
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

Re: [web2py] Dynamic model creation

2012-06-07 Thread Andrew
Check out http://www.web2pyslices.com/slice/show/1491/plugin-lookout I have a need to open up other databases and inspect their structures, by looking at the other system's catalog. The slice above also does that.

[web2py] Dynamic model creation

2012-06-03 Thread Christian
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

[web2py] dynamic model (with uploaded db)

2012-02-08 Thread giovanni allegri
Hi, I'm moving my first steps ith web2py. I'm considering it to setup a REST service where a user can upload (zipped) sqlite DBs and view/edit their content through a web interface. The db structure is fixed (it's the storage of a desktop application), so I can define a model for it, but I wonder

Re: [web2py] Dynamic Model

2011-09-30 Thread Vasile Ermicioi
doesn't seem to much memmory

Re: [web2py] Dynamic Model

2011-09-30 Thread Vasile Ermicioi
I have success using the embedded (core, common + persistence jars) version via jpype (Java API), I will try to prototype an adapter, if I will have success I will inform you It has all in one: - key value store - document database - graph database - object database

Re: [web2py] Dynamic Model

2011-09-30 Thread Massimiliano
I'm very interested on dynamic model and I'm investigating a little bit. I've had some results with this model. The user can define compound models. Types are ancestor types (string, integer etc) useful for representation db.define_table( 'types', Field('type', 'string'),

Re: [web2py] Dynamic Model

2011-09-30 Thread Phyo Arkar
Thanks Massimilliano! This is very interesting , i will test it out. On 9/30/11, Massimiliano mbelle...@gmail.com wrote: I'm very interested on dynamic model and I'm investigating a little bit. I've had some results with this model. The user can define compound models. Types are ancestor

Re: [web2py] Dynamic Model

2011-09-29 Thread TheSweetlink
I have recently found OrientDB http://orientechnologies.com It is a document-graph db that will allow you to evolve your schema over time. In fact you can have no schema, mixed-schema, or full schema. There is SQL syntax that is both familiar and powerful, especially when combined with Gremlin

[web2py] Dynamic Model

2011-09-28 Thread Phyo Arkar
Here is what i was asked for, weird that i haven't see in any application yet. A Dynamic Model : A dynamic table schema. They want a feature to add a column dynamically , for example a table do not have comment field. they want a button to add a new field on the fly and add the data into it. so

Re: [web2py] Dynamic Model

2011-09-28 Thread Ismael Serratos
Hi Phyo!!! I needed almost the same, and I found the EAV Modeling technique (http://en.wikipedia.org/wiki/Entity-attribute-value_model) useful, but due the complexity of my project I write the model as a file, I mean open the *.py, write, append. On Wed, Sep 28, 2011 at 4:31 PM, Phyo Arkar

Re: [web2py] Dynamic Model

2011-09-28 Thread Phyo Arkar
Thank you very much for that technique. I will check it. Yeah i also thought about writing schema_0-1-2-3-4.py file for each of the table for each users. But Letting python write its own Python code , wont it introduce security concern :| ? On Thu, Sep 29, 2011 at 4:11 AM, Ismael Serratos

Re: [web2py] Dynamic Model

2011-09-28 Thread pbreit
NoSQL

Re: [web2py] Dynamic Model

2011-09-28 Thread Phyo Arkar
Couch ? Mongo? I really have to try them , not started yet. On Thu, Sep 29, 2011 at 4:28 AM, pbreit pbreitenb...@gmail.com wrote: NoSQL