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 MoreGenerate UUIDv7 in YSQL
UUIDv7 is a newer UUID variant designed for modern, distributed systems. Unlike UUIDv4 (fully random), UUIDv7 embeds a Unix timestamp (milliseconds) in […]
Read More