MongoDb

36 views
Skip to first unread message

Tushar Tuteja

unread,
Dec 30, 2013, 5:34:02 AM12/30/13
to web...@googlegroups.com
I have an app running on MySQL , I want to use mongoDB instead. 
I want to help on migration from mysql to mongoDB.
Thanks,

regards,

Tushar Tuteja

Alan Etkin

unread,
Dec 30, 2013, 6:14:17 AM12/30/13
to web...@googlegroups.com
I have an app running on MySQL , I want to use mongoDB instead. 
I want to help on migration from mysql to mongoDB.
Thanks,

Beware that mongodb adapter is in an experimental stage of development, so you should know what you are doing before migrating. I suppose there are lots of howtos for migrating data between those backends. The web2py way of doing has two options, AFAIK:

- use cpdb (never tried it with those connections)
- use DAL.import_from_csv_file and DAL.export_from_csv_file methods (for a small amount of db records)

Mind that the most important issue is that mongodb is not a relational database management system and there's no such thing as JOIN queries. This is a limitation for web2py also, since some of the web2py features require joins to work.

Tushar Tuteja

unread,
Dec 30, 2013, 7:10:38 AM12/30/13
to web...@googlegroups.com
Hey,
Thanks for the answer. Luckily there are no joins, but I need to see what web2py features of DAL won't work.
Thanks,
Regards,
Tushar Tuteja



--
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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/oPCXZnnFvyI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
Tushar Tuteja
Undergraduate Student(Fourth Year)
Civil Engineering
IIT Delhi
"The question isn't who is going to let me; its who is going to stop me!" - Howard Roark

Alan Etkin

unread,
Dec 30, 2013, 7:33:13 AM12/30/13
to web...@googlegroups.com

Thanks for the answer. Luckily there are no joins, but I need to see what web2py features of DAL won't work.

To my knowledge, you cannot use the scheduler or Auth.accessible_query, everything else not requiring join queries should work.
Reply all
Reply to author
Forward
0 new messages