bravo_sierra

Using the Buffer function it does. Then MySQL will utilize the geometry index, rather than scanning the table. Not clear in the docs, but it's there.

The edge cases happen all the time.

Using a B-Tree on a Geohash (like MongoDB does) is a bit more efficient that just indexing min/max values, but not by much. MySQL, PostgreSQL and even SQLite have R-Tree indices that perform 10x better.

For what? How?

Why in the world would you use this when MySQL has almost proper geospatial support? It's far more efficient and less incorrect.

I swear - next time I'm going to get a R-Tree novelty account.

MySQL can use R-Trees too - http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.ht...

There's also Pocco (Python), Rocco (Ruby), and shocco (*sh) http://tomayko.com/linkings/67644cabf40a7aa32c2a99fda9a42e20

Look at it the other way. Why should Apple ship software it can't take responsibility for? Does Silverlight come bundled on Snow Leopard?

No. The old one-click installer used VS6, and the new one uses MinGW and GCC.

This has to be one of the stupidest running complaints in recent memory. How is his proposal much different than the m2sh tool? http://mongrel2.org/doc/tip/docs/manual/book.wiki#x1-220003....

If you were going to compile it yourself, it's just missing M4, autoconf, automake and OpenSSL. Otherwise you can use it's Appbrowser (ab in micro, the CLI version) to install Ruby in about five minutes.

MacPorts can be hard to grep if you haven't used a BSD before (not that it's great anyway), and Fink is a bit more painful than apt et al.

If you're on OSX, the ace up it's sleeve is Homebrew[1]. Definitely the easiest package management system anywhere.

[1]: http://github.com/mxcl/homebrew

I can't find the source ATM, but apparently it's 10-20% daily, down from 30-40% a year ago.

Scroll to the bottom of this for something tangible: http://www.raterush.com/pages/digg-reddit

How is 6/10 extremely low?

Definitely useful. Love the simplicity of it. Foursquare and Gowalla have too much going on, and it's weird to pull out your Spot at a restaurant.

One enhancement might be to use the location of your friend to get directions to each other.

Charging for something like mobileply.com/matt sounds like a good idea too.

My other thought comes from how Spot does it - they use passwords to make sure you can't get in just by knowing the URL. You could even mix that up so the password you give your mum only lets her know you're in Chicago, while someone else can see you're on 42nd & Grand. Maybe that's too much though.

The simplicity of it is the best part - keep it up.

Sort, with this map/reduce done in Bash: http://news.ycombinator.com/item?id=1604780

They could, but they haven't, and probably won't. Oracle had a big database-related portfolio long before they acquired Sun/MySQL, which had relatively few. They even bought Innobase, makers of the InnoDB engine a few years ago.

Other database vendors (Percona et al., not IBM) don't have assets for Oracle to take, don't directly threaten their core business, and going after them would get Oracle in trouble with regulators.

Better to land a tuna than chase sardines around.

Neat resource, definitely something to borrow from, but I think I'm with Fuchs on this... http://mir.aculo.us/2010/08/10/pragmatic-html-css/