News for hackers. Stuff that matters.
Re:MongoDB gotchas for the unaware user by msy on Thursday December 23, 2010 @08:59AM (#2034376)
Another small one I'd point out: You can't sort large sets on fields that aren't indexed. It's not just slow, mongo flat out refuses to do it.
Re:MongoDB gotchas for the unaware user by piotrSikora on Thursday December 23, 2010 @09:03AM (#2034383)
This is actually awesome feature! AppEngine's Datastore requires this as well.

I really wish that PostgreSQL (and other SQL databases) would allow one to enforce such policy, it's a lifesaver.

Re:MongoDB gotchas for the unaware user by xal on Thursday December 23, 2010 @03:07PM (#2035693)
Agreed. I wish normal SQL dbs would implement a mode where index misses result in errors unless they contain some sort of opt in text.
Re:MongoDB gotchas for the unaware user by eldenbishop on Thursday December 23, 2010 @08:00PM (#2036316)
Mongo servers can be run in a mode that rejects the query with an error if it would result in a row scan. Very useful for safely avoiding bad queries slamming your server.
Re:MongoDB gotchas for the unaware user by latch on Thursday December 23, 2010 @07:24PM (#2036271)
Some "normal" SQL dbs can, at the very least, be configured to log this. Which is pretty great when you consider some can't.