This post is the implementation companion to Part 1: Geospatial Queries in YugabyteDB Without PostGIS. In that tip you learned how geospatial […]
Read MoreGeospatial Queries in YugabyteDB Without PostGIS
Many applications rely on geospatial data for things like: ● “Find all points within X miles” ● “Which records fall inside this […]
Read MorePaging Large Result Sets in YugabyteDB (Without Re-Querying Everything)
When applications need to page through query results, a very common (but often inefficient) pattern shows up: SELECT some_columns FROM some_table ORDER […]
Read MoreDecode a UUID and Identify Its Version
UUIDs look random… but they aren’t. Every UUID encodes its version directly in the bits, and you can extract it easily in […]
Read MoreOrdering and indexing by time with UUIDv7
In our previous tip, Generate UUIDv7 in YSQL, we showed how to generate UUIDv7 values directly in YugabyteDB YSQL and use them […]
Read More