Re: [web2py] Re: move database to mongodb

2017-09-26 Thread Dave S
On Tuesday, September 26, 2017 at 7:15:08 AM UTC-7, 黄祥 wrote: > > thank you all for the input, this topic is open just to put what i tested > when using mongodb (just started to learn nosql trying first with mongodb > that is supported by web2py), perhaps there are some issue is not resolved

Re: [web2py] Re: move database to mongodb

2017-09-26 Thread Richard Vézina
I think the issue you talk about is related or is the same one to the one report here : https://groups.google.com/forum/#!topic/web2py/oPcn_TFEJvQ Richard On Tue, Sep 26, 2017 at 10:15 AM, 黄祥 wrote: > thank you all for the input, this topic is open just to put

Re: [web2py] Re: move database to mongodb

2017-09-26 Thread 黄祥
thank you all for the input, this topic is open just to put what i tested when using mongodb (just started to learn nosql trying first with mongodb that is supported by web2py), perhaps there are some issue is not resolved like auth permission another error testing found : 1. Didn't support

Re: [web2py] Re: move database to mongodb

2017-09-26 Thread Richard Vézina
I listen a few vid tutorial about data modeling it mongoDB and basically you should think to put in a single document (mongo is a document database important to remember) all (or most of them) the piece of data into a single document base on the use case of these data (application view for

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread Dave S
On Monday, September 25, 2017 at 2:44:19 PM UTC-7, 黄祥 wrote: > > just want to learn about mongodb and how to use it with web2py, the same > code is work in all rdms (tested in sqlite, mysql, postgre except change > configuration db uri in appconf.ini and the executesql() create index for >

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread 黄祥
just want to learn about mongodb and how to use it with web2py, the same code is work in all rdms (tested in sqlite, mysql, postgre except change configuration db uri in appconf.ini and the executesql() create index for text field in mysql (minor) ) but when tested with nosql (first try with

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread Richard Vézina
Hello Steve, I had read about MongoDB for a project that I had in mind... When I see your thread first question come to mind is why porting relational database to mongo... In mongo you will have to design your database in a much different way then in and relational engine in order to make some

[web2py] Re: move database to mongodb

2017-09-24 Thread 黄祥
*Code:* auth.add_permission(auth_user_id_1, "impersonate", "auth_user", auth_user_id_2) *Error:* ... OverflowError: MongoDB can only handle up to 8-byte ints there was a ticket 2 years ago, but still occured, tested in web2py 2.15.4 *ref:* https://github.com/web2py/pydal/issues/223 best

[web2py] Re: move database to mongodb

2017-09-23 Thread 黄祥
*Can't retrieve value of reference field (tested in views and in models using represent)* {{=DIV('%s - %s' % (row_person.id_card.id_card_type, row_person.id_card.id_card_number) ) }} *Error:* ... RuntimeError: Using a recursive select but encountered a broken reference: id_card 1 *Solution: *