3 reasons to use MongoDB

Re:3 reasons to use MongoDB by angilly on Thursday September 09, 2010 @01:21PM (#1676092)

Got it. I agree. The "where exists (select 1...)" thing was neat. Learned me something.

[ Parent | on HN ]

Re:3 reasons to use MongoDB by nerfhammer on Thursday September 09, 2010 @01:53PM (#1676194)

I believe that select * is actually conventional for an exists subquery

[ Parent | on HN ]

Re:3 reasons to use MongoDB by ergo98 on Thursday September 09, 2010 @02:10PM (#1676248)

I have a natural aversion to "SELECT *" (it is almost always a bad usage), so while any decent database system will parse it to yield the same query plan, I still use SELECT 1.

[ Parent | on HN ]