Geographic distance can be simple and fast (jonisalonen.com)

Interesting comparison. For the SQL distance example, though, a spatial database engine like PostGIS would of course be more appropriate.