Freek.dev

How to retrieve any geographical data from OpenStreetMap and transform them into usable PHP objects.

Read more [gummibeer.dev]

A clever use of MySQL indexes and generated columns to make blazing fast geolocation searches.

Read more [aaronfrancis.com]

Max Kostinevich explains how to create your own Geolocation service using Cloudflare workers.

Read more [maxkostinevich.com]

Bram Van Damme shows some code on how to do this.

Read more [www.bram.us]

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!

https://tighten.co/blog/a-mysql-distance-function-you-should-know-about

Read more

On Scotch.io a new post by Julien Bourdeau was published that shows how you can easily import and search geographic data with Laravel Scout and Algolia.

Laravel Scout makes it very easy to setup an external search engine to create consumer-grade search quickly. The package comes with Algolia as a default search engine. I'd like to demonstrate how to make use of the geo-location search feature with Scout.

In this tutorial, you'll learn how to prepare your data for Algolia and Laravel Scout to retrieve items based on location.

https://scotch.io/tutorials/achieving-geo-search-with-laravel-scout-and-algolia

Read more