Menu

How we replaced slow Overpass API queries with a 651k-row local UK geospatial engine in Laravel 12 & PHP 8.4
📰

How we replaced slow Overpass API queries with a 651k-row local UK geospatial engine in Laravel 12 & PHP 8.4

DEV Community: laravel·Jobbri UK·21 days ago
#D9p0LcUk
#devtolaravel#devto#dev#postcode#category
Reading 0:00
15s threshold

When building Jobbri UK — a direct-hire UK recruitment and gig economy platform designed to connect candidates with employers without recruitment agencies — we wanted to solve a very practical problem for British job seekers: commute and relocation transparency .

Most job boards only show a city name like "Manchester" or "London" . Before applying for a role, candidates actually need to know:

How far is the office from the nearest train, tube, or bus station?

Are there supermarkets, GP practices, gyms, and nurseries nearby?

What percentage of the net take-home pay (in £ GBP) will go towards local rent in that specific UK postcode?

To answer this, we built Area Guide 2.0 directly into every live listing on our UK jobs search engine alongside our free UK salary calculator and career tools .

However, our initial architecture hit a major bottleneck in production: public Overpass API rate limits and timeouts .…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.