### Foreword

Haversine formula is a very popular and often used method at developing GPS applications. The Haversine formula is used to calculate

distance by latitude and longitude of two different points. This is the shortest distance between two points on the Earth’s surface.

**Mathematical foundation**

Implementing a pattern on a database query using SQL looks like

as follows:

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin(radians(lat)) ) ) AS distance FROM issues ORDER BY distance;

A big plus of use Haversine formula is that it can be implemented in SQL, and thus the time-consuming calculations of the distance are transferred from the application to the database.