🧭 Introduction With PostgreSQL 18 introducing native uuidv7(), time-ordered UUIDs are finally going mainstream. But if you’re running YugabyteDB (or older PostgreSQL […]
Read More
How to Emulate PostgreSQL pgstattuple in YugabyteDB
If you come from PostgreSQL, pgstattuple is one of those extensions that feels like it should be part of your regular toolbox. […]
Read MoreHow 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 More