Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?
Mysql – the ideal data type to use when storing latitude / longitude in a MySQL database
database-designlatitude-longitudemappingmapsMySQL
Best Answer
Use MySQL's spatial extensions with GIS.