Running Nominatim with Docker and PostGIS
A hands-on guide to self-hosting geocoding with Nominatim, Docker, and PostGIS — covering setup, imports, spatial queries, and the RAM/storage trade-offs to plan for before you start.
EngPlain
EngPlain
For working engineers
Engineering, explained plainly. Practical writing on software, security, AI, cloud, and developer tools.
A hands-on guide to self-hosting geocoding with Nominatim, Docker, and PostGIS — covering setup, imports, spatial queries, and the RAM/storage trade-offs to plan for before you start.
SQL doesn't run in the order you write it. This post walks through the real logical execution order — FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT — using one worked query example, and explains the WHERE-vs-HAVING mistake it fixes for good.
CISA urges organizations to prioritize exploited vulnerabilities, apply risk-based updates investigate compromises, and nominate missing KEV entries using evidence.
How to design a location search API in Spring Boot and Elasticsearch, from coordinate checks to geo-distance queries and distance sorting.
API versioning is less about /v1 vs /v2 and more about contracts. Here’s a practical approach that keeps old clients working while you ship new features.