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 More
How 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 MoreRight-Sizing Connections in YugabyteDB with YSQL Connection Manager (YCM)
Why Connection Counts Matter in YugabyteDB One of the most common questions when deploying YugabyteDB in production is: How many database connections […]
Read MoreAvoid the Midnight Timestamp Trap (Use Half-Open Ranges)
Filtering by date ranges looks simple… until it silently drops rows. If your column is a TIMESTAMP (not DATE), using <= ‘YYYY-MM-DD’ […]
Read More