News for hackers. Stuff that matters.
Re:MongoDB 1.8 (stable) released by andrewjshults on Wednesday March 16, 2011 @04:17PM (#2333696)
If you are working with location data, Mongo has built in geospatial indexing built in since 1.4 (earlier in the unstable builds) - http://www.mongodb.org/display/DOCS/Geospatial+Indexing which has been a big draw for a number of people I know using it (it looks like 1.8 brings spherical distances to the stable branch which makes the geo lookups a lot more useful if you need accurate distances and not just near by lookups).
Re:MongoDB 1.8 (stable) released by look_lookatme on Wednesday March 16, 2011 @05:56PM (#2334142)
In reference to the OP, when comparing Mongo and Postgres, I wouldn't bring up geo...
Re:MongoDB 1.8 (stable) released by igrekel on Wednesday March 16, 2011 @04:34PM (#2333769)
Interesting I was planning to toy with location data, do you know how it compares with Postgresql extension PostGIS?
Re:MongoDB 1.8 (stable) released by crux_ on Wednesday March 16, 2011 @05:10PM (#2333938)
If by "location data" you have points, and the only location operations you need are distance or bounding-box searches, it may do the trick.

If you're interested in polygons, lines, etc; more physically accurate (and completely implemented) distance queries, spatial joins, aggregation, 3D and surveyor-annotated data, set-theoretic operations ... PostGIS is far and away the way to go. It's far more mature and debugged than any of the NoSQL geospatial stuff I've seen, not only WRT correctness but also performance.

As a point of reference: There's a growing legion of geographers who do all their vector work in SQL using PostGIS.

All that said, for some applications, being tied to the relational model is a deal breaker. Just know that in terms of capability and maturity on the geospatial front, you'll be trading off a Cadillac for a partially assembled rocket sled.

Re:MongoDB 1.8 (stable) released by crux_ on Wednesday March 16, 2011 @04:38PM (#2333782)
I got excited and looked it up.

> We don't currently handle wrapping at the poles or at the transition from -180° to +180° longitude, however we detect when a search would wrap and raise an error.

generalized grumble

Why does everyone always seem to punt on doing geospatial right? It's not _that_ hard.

Re:MongoDB 1.8 (stable) released by gt384u on Thursday March 17, 2011 @01:23AM (#2335177)
Why not go ahead and help them? I'm sure they'd be happy to have the assistance. Fork mongo from github at https://github.com/mongodb/mongo . Happy hacking!
Re:MongoDB 1.8 (stable) released by crux_ on Thursday March 17, 2011 @12:15PM (#2336664)
You know, nobody ever replies to these comments with an "I will", but I'm seriously considering it.

(It's a nice opportunity to publicly show off a specialty/core competency and brush up a bit on C++ a the same time. I'm not that easily provoked into action by internet commentary! ;) )

But, looking at the source, I think I will be probably a Bad Contributor and end up with a gigantic pull request and a (mostly) full re-implementation...

Re:MongoDB 1.8 (stable) released by thibaut_barrere on Thursday March 17, 2011 @05:51AM (#2335587)
> Why does everyone always seem to punt on doing geospatial right? It's not _that_ hard.

Do you mean you think they don't know how to do it?

As I followed the roadmap on this specific point, it looks more like an incremental development to me: they first used rectangular coordinates in 1.6, then a spherical model in 1.7 etc.

It allows to bring a more lightweight solution quickly to people that need it (like me), then to evolve based on the feedback etc.

Re:MongoDB 1.8 (stable) released by crux_ on Thursday March 17, 2011 @11:18AM (#2336382)
The problem I have is at least partly one of truth in advertising.

For example: If they were truly using a "spherical model", then one would not expect to have queries fail at the poles & dateline, would you?

At least it is documented and fails hard with an error rather than giving wrong results, so a developer can quickly figure out the weak spots --- though I bet a lot of people would prefer the wrong results to queries that cause exceptions in their systems.

> Do you mean you think they don't know how to do it?

I think it has more to do with the absurdly low bar they've set for themselves to check the "geospatial" box than it does with competence.

Re:MongoDB 1.8 (stable) released by thibaut_barrere on Thursday March 17, 2011 @12:04PM (#2336596)
I don't know really - if limitations are documented like they are apparently, it's really not an issue for me - I don't feel cheated (but it's really an opinion!).

Your mileage may vary as they say: I used the GIS since 1.6 and it was very helpful for me in this form already :)

Re:MongoDB 1.8 (stable) released by crux_ on Thursday March 17, 2011 @12:29PM (#2336735)
The limitations are documented as foot/side notes.

Analogy: It's like seeing "ACID compliance!" on a feature list, then finding buried in the documentation that is only the case for single-document transactions in unordered collections on a single machine only.

The new feature might be useful to some but including it on a feature list without disclaimer is misleading.

Re:MongoDB 1.8 (stable) released by thibaut_barrere on Thursday March 17, 2011 @01:46PM (#2337114)
I understand your analogy really :)

Really curious: are you using mongo currently? Or browsing the docs?

Re:MongoDB 1.8 (stable) released by crux_ on Thursday March 17, 2011 @02:45PM (#2337435)
I'm not using it directly, but sometimes I use tools that in turn use mongo. -- So for now, browsing docs.