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 instance)... It not fully clear to my understanding if there is any structured way to determine how to include data or not in a given entity (document), I didn't apply my learning yet so... But I guess you should balance between the size and the amount of data you need to show base on the view of your application... Even the way you create your app maybe influenced by the fact that speed of the backend is not suppose be the bottleneck anymore or it limit is much higher...
I think mongo is a good nosql choice but I doubt that migrating relational model into mongo will bring you any benefit without remodeling your data structure... You should also consider using nosql type of database for particula piece of data but before on board and other database engine in your stack you have to consider it as it's not a trivial choice. For this reason and because Postgres offer nosql type of data structure (hstore) you may or may not be better to stick with it depends of your needs. Good luck Richard On Mon, Sep 25, 2017 at 6:29 PM, Dave S <[email protected]> wrote: > > > 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 >> text field in mysql (minor) ) but when tested with nosql (first try with >> mongodb) a lot of things must be changed in my existing code. >> yes you are right, i think that the application is a bit slower when >> using mongodb rather than using rdms, perhaps the reason is what you said >> 'having much less tables as it the key to improve the speed of the back end' >> >> n.b. >> when an error occured during testing with existing code, just tested in >> new app the suspected error code to make it simple and can focus what is >> going wrong and how to fix it >> >> thanks and best regards, >> stifan >> > > > My understanding of MongoDB is that it is supposed to be fast to WRITE to, > making it good for recording things that happen in a stream. > > I've only used it in a node.js/React context, and only for one assignment, > so I'm not able to provide you with much detail. > > /dps > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
