Here is my comparison between the two PostgreSQL Tables DAL ACID vertically scales set-schema
Both no built-in object model requires foreign key lookups requires migrations if schema DOES change MongoDB documents NoSQL quick reads horizontally scales changing-schema The advantages I see with NoSQL is that you don't need bloated ORMs and complicated DALs. Most of the NoSQL libraries in python are very small, don't require special drivers, and are small enough to go with your application. As with alot of things, it really depends on exactly what you are doing, if you need ACID (ie: your using this for *real* work, like a research firm or a bank) use RDBS, if your just a personal blog, small project, or anything other than a mission critical application, you probably could use NoSQL since its API is typically simpler and easier to use. For web2py, you don't have to do ``db = DAL()`` you can just as easily do ``db = MongoDB()`` and use it like with any other system. Looking at NoSQL APIs I do not see how they can integrate with the web2py DAL just because there is nothing for the DAL to do but provide a syntax. -- Thadeus On Fri, May 21, 2010 at 12:01 PM, Russ Ferriday <ru...@topia.com> wrote: > Final thought... > I think if NoSQL were indicated for use with a web2Py app, it might be most > appropriate to replace some, but not all SQL-based tables. > --r. > On May 21, 2010, at 9:31 AM, Thadeus Burgess wrote: > > I also see really no reason to use NoSQL unless you really just don't > like writing SQL... thats why we have ORMs and DALs anyways. > > You still have to use FK relationships with document based sets... ie: > with a 4MB document limit, they suggest you split comments for a post > into its own document and link them to a post via _id. > > If I am going to mess with relationships such as this I might as well > use a.... umm... relational database system ? > > -- > Thadeus > > > > > > On Fri, May 21, 2010 at 8:23 AM, Albert Abril <albert.ab...@gmail.com> > wrote: > > Haha! I enjoy with this jokes in tech slides, they're amusing! > > On Fri, May 21, 2010 at 3:02 PM, Timothy Farrell <tfarr...@swgen.com> wrote: > > Developers running with scissors!! LOL!!! > > On 5/20/2010 2:12 PM, szimszon wrote: > > Nice > > On máj. 20, 19:52, mdipierro<mdipie...@cs.depaul.edu> wrote: > > > http://www.scribd.com/doc/31669670/PostgreSQL-and-NoSQL > > > > > > Russ Ferriday - Topia Systems - Open Source content management with Plone > and Zope > ru...@topia.com - mobile: +1 805 234 6915 - skype: ferriday >
