Calculating distance using MySQL

Logan Henson, a developer at Tighten, wrote a new post on the company blog about MySQL’s cool ST_Distance_Sphere function.

On a client project recently, we had to make it easy to filter database query results based on the distance between a user and an entity in our database. It’s easy to get overwhelmed in that context, worrying about the crazy amount of PHP calculations you’re going to have to run.

If you need to calculate this, you can actually get surprisingly far by just using MySQL!

Freek Van der Herten

Written by

PHP developer and Laravel enthousiast at https://spatie.be, blogging at https://murze.be

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade