Re: [web2py] Re: we should support this in DAL

2012-11-26 Thread pbreit
Yeah, something like that I would think. Is there a generic set of queries that some/most/all of certain types of NoSQL DBs share? Mongo is nice to support but also Postgres, Redis, etc. Are there some queries where DAL-style syntax makes sense? For example selecting for an item or set of items

Re: [web2py] Re: we should support this in DAL

2012-11-26 Thread Bruno Rocha
I think DAL has nothing to do with Mongo. It is much easier to use only PyMongo API. What we really need is a "Rows factory" it shoul take arbitrary data format (can have a scheme) and will give us back a Rows object. Also it should have some event binders to update, delete, insert... So program

Re: [web2py] Re: we should support this in DAL

2012-11-25 Thread Mark Kirkwood
I am wondering if there are some deeper issues getting NoSQL support in Web2py - for instance the model part seems pretty tied into relational ideas (e.g db.define_table and ..references db.dog etc). This design works really well and insulates developers from much of the fiddlyness of dealing

Re: [web2py] Re: we should support this in DAL

2012-11-21 Thread Niphlod
that is exactly the explanation of the term "experimental". The problem as always is that if noone starts to test it, it will be in this way forever. On Tuesday, November 20, 2012 11:25:59 PM UTC+1, Simon Ashley wrote: > > The bottom line seems to be that we/ others need to start to use nosql >

Re: [web2py] Re: we should support this in DAL

2012-11-20 Thread Simon Ashley
The bottom line seems to be that we/ others need to start to use nosql engines to sort the issues. My guess is that, currently, critical mass is not present to rely on it for production sites. --

Re: [web2py] Re: we should support this in DAL

2012-11-20 Thread Niphlod
I agree on the most part, but DAL "just the way it is now" doesn't get in your way. The second you need a larger field, add some fields, etc, you change your model and with a NoSQL engine you're good to go. --

Re: [web2py] Re: we should support this in DAL

2012-11-19 Thread Simon Ashley
In the not to distant future we need to refactor reasonable large SQL databases. Current open source choices are limited to MySQL and PostgreSQL. (trying to avoid vendor lock in issues). Interest in this thread is as a prompt to explore nosql pros and cons. Both SQL options are mature, well de

Re: [web2py] Re: we should support this in DAL

2012-11-19 Thread Niphlod
the main issue for those kind of ideas is to explain your vision of a NoSQL adapter..I've seen a lot of "please support a NoSQL DAL" but anyone explaining what is he missing from the current DAL. What do you need NoSQL DAL for ? Following some statements raised before: a) why DAL doesn't su

[web2py] Re: we should support this in DAL

2012-11-19 Thread Simon Ashley
+1 for moving in this direction. On Saturday, November 17, 2012 10:19:15 PM UTC+10, Massimo Di Pierro wrote: > > http://labs.codernity.com/codernitydb/index.html > --

Re: [web2py] Re: we should support this in DAL

2012-11-19 Thread Simon Ashley
Thanks for that. Was looking to see how tender the adapter was and how far it could be pushed, and that may have answered it. On Tuesday, November 20, 2012 2:50:20 AM UTC+11, Adi wrote: > > Hi Simon, i didn't go too far with DAL and mongo. Managed to get the grid, > but as mentioned before had

Re: [web2py] Re: we should support this in DAL

2012-11-19 Thread Simon Ashley
The part would would have interested us is potential to re factor live systems, particularly with changing tenancy requirements. Thinking that while the DAL, by necessity will have relational database tendencies and may never have full nosql capability, it would be interesting to explore areas

Re: [web2py] Re: we should support this in DAL

2012-11-19 Thread Adnan Smajlovic
Hi Simon, i didn't go too far with DAL and mongo. Managed to get the grid, but as mentioned before had a problem retrieving individual record (document) for view and update. Then I included pymongo, and got needed functionality outside of grid, but didn't have time then to continue working on it.

Re: [web2py] Re: we should support this in DAL

2012-11-19 Thread Vasile Ermicioi
the main problem is that web2pys DAL is designed for relational databases, and writing nosql adapaters will mean porting just a subset of relational functionality, but you will not be able to take advantage of unstructured data, because from web2py point of view it will look structured, just stored

[web2py] Re: we should support this in DAL

2012-11-18 Thread Simon Ashley
What issues are you coming up against with Mongo/ nosql ports and DAL operations? Interested because we need to start investigating this. On Sunday, November 18, 2012 12:02:12 PM UTC+10, Adi wrote: > > Definitely would be nice to support NoSQL. > > I tried the existing DAL with MongoDB and grid

[web2py] Re: we should support this in DAL

2012-11-17 Thread Adi
Definitely would be nice to support NoSQL. I tried the existing DAL with MongoDB and grid worked fine to the point of view/edit record. Due to different concepts (sql/nosql) if it's hard to keep them in a same DAL, maybe there could be a separate layer for NoSQL. I would be glad to test lots

[web2py] Re: we should support this in DAL

2012-11-17 Thread Niphlod
without making indexes on every field automatically it's not going to resemble anything more than a key-value store On Saturday, November 17, 2012 1:19:15 PM UTC+1, Massimo Di Pierro wrote: > > http://labs.codernity.com/codernitydb/index.html > --