Viewing profile — 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 an…

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 novel…

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…

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…

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 …

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-…

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 t…

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 Innoba…

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/