PostgreSQL provides an elegant way to handle problems such as overlapping reservations, duplicate-event windows, or effective-date ranges. A typical design uses a […]
Read More
How to Replace ST_SetSRID(ST_MakePoint(…),4326) from PostgreSQL/PostGIS in YugabyteDB (Without PostGIS)
Inroduction Many PostgreSQL applications that use PostGIS construct geographic points like this: ST_SetSRID(ST_MakePoint(lon, lat), 4326) This pattern is extremely common in location-based […]
Read MoreHow to Replace ST_DWithin Radius Queries in YugabyteDB Without PostGIS
Many geospatial applications built on PostgreSQL use PostGIS queries that combine: ● ST_DWithin() to filter objects within a radius ● bounding-box checks […]
Read MoreBenchmarking Geospatial Queries in YugabyteDB
Validating p95 / p99 Latency Without PostGIS (Part 3) In Part 1 of this series, Geospatial Queries in YugabyteDB Without PostGIS, we […]
Read More