Hacker News Reader

bravo_sierraon Calculate Latitude/Longitude Distances in MySQL with the Haversine Function

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.

bravo_sierraon Calculate Latitude/Longitude Distances in MySQL with the Haversine Function

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.

bravo_sierraon Calculate Latitude/Longitude Distances in MySQL with the Haversine Function

For what? How?

bravo_sierraon Calculate Latitude/Longitude Distances in MySQL with the Haversine Function

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.

bravo_sierraon Calculate Latitude/Longitude Distances in MySQL with the Haversine Function

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

bravo_sierraon Todos: a Backbone.js example Single-Page-App (with LocalStorage)

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

bravo_sierraon Apple Is No Longer Bundling Flash Player With Mac OS X

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

bravo_sierraon RVM for Windows: vertiginous's pik at master - GitHub

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

bravo_sierraon Dear Zed, please throw the bikeshedders a bone

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

bravo_sierraon Tiny Core offers a complete Linux solution in 11MB

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.

bravo_sierraon Thank you, Ubuntu

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

bravo_sierraon 17 Year Old creates website that predicts future of Digg

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

bravo_sierraon 17 Year Old creates website that predicts future of Digg

How is 6/10 extremely low?

bravo_sierraon Ask HN: Review my weekend project - MobilePly

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.

bravo_sierraon Ask HN: Sorting massive text files?

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

bravo_sierraon Oracle sues Google over use of Java in Android

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.

bravo_sierraon HTML5 Boilerplate: a rock-solid default

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/