With CouchDB in particular, is there any thoughts for treating nested
structures as though they had been retrieved through a join?
Taking the following document:
{
_id: 'abcd1234',
type: 'person',
name: 'John Doe',
phones: ['555-555-3614', '555-555-1812'],
addresses: ['123 S Nowhere Ln...']
}
Because the phones and addresses, although nested objects, can be
added as top level objects to a view arbitrarily, and because self-
contained documents like the above are the way to do things in Couch,
it seems prudent to be able to simulate 'table' relationships in the
DAL in some way, in this example with phones and addresses being
understood as virtual tables so as to integrate with SQLTABLE and
CRUD, to name a few.
Additionally, when completed, will we be able to define arbitrary
predefined views as read-only tables that can only be filtered by key/
key-range? Temporary views will have noticeably slower performance,
which would make ad-hoc filters something to be discouraged.
On Dec 8, 2:20 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Because the integration is not completed. Close but not done.
>
> On Dec 8, 2:44 pm, António Ramos <ramstei...@gmail.com> wrote:
>
> > For dummies why not a video tutorial on using couchdb with web2py?
> > I would help a lot for newcommers and for web2py in general!
>
> > Best regards
> > António
>
> > 2010/12/8 mdipierro <mdipie...@cs.depaul.edu>
>
> > > Please make sure you have the latest sql.py from trunk.
> > > CouchDB should call the rollback at 2325 not the one at line 988.
>
> > > Massimo
>
> > > On Dec 8, 1:57 pm, David Marko <dma...@tiscali.cz> wrote:
> > > > I tried it but getting following error:
>
> > > > Traceback (most recent call last):
> > > > File "c:\java\web2py\gluon\main.py", line 488, in wsgibase
> > > > BaseAdapter.close_all_instances(BaseAdapter.rollback)
> > > > File "c:\java\web2py\gluon\sql.py", line 264, in close_all_instances
> > > > action(instance)
> > > > File "c:\java\web2py\gluon\sql.py", line 988, in rollback
> > > > return self.connection.rollback()
> > > > AttributeError: 'Server' object has no attribute 'rollback'
>
> > > > Changes are available in CouchDB but after every request I'm getting
> > > > error above.
>
> > > > David
>
>
