bravo_sierra

5 ms·

1.
by bravo_sierra 16y ago
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.
2.
by bravo_sierra 16y ago
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.
3.
by bravo_sierra 16y ago
For what? How?
4.
by bravo_sierra 16y ago
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.
5.
by bravo_sierra 16y ago
MySQL can use R-Trees too - http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.ht...
6.
by bravo_sierra 16y ago
There's also Pocco (Python), Rocco (Ruby), and shocco (*sh) http://tomayko.com/linkings/67644cabf40a7aa32c2a99fda9a42e20
7.
by bravo_sierra 16y ago
Look at it the other way. Why should Apple ship software it can't take responsibility for? Does Silverlight come bundled on Snow Leopard?
8.
by bravo_sierra 16y ago
No. The old one-click installer used VS6, and the new one uses MinGW and GCC.
9.
by bravo_sierra 16y ago
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....
10.
by bravo_sierra 16y ago
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.
11.
by bravo_sierra 16y ago
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 sy
12.
by bravo_sierra 16y ago
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
13.
by bravo_sierra 16y ago
How is 6/10 extremely low?
14.
by bravo_sierra 16y ago
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.
15.
by bravo_sierra 16y ago
Sort, with this map/reduce done in Bash: http://news.ycombinator.com/item?id=1604780
16.
by bravo_sierra 16y ago
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 datab
17.
by bravo_sierra 16y ago
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/