Sometimes a query result looks wrong at first glance… until you realize YugabyteDB is doing exactly what the type system told it […]
Read More
Handling NaN in NUMERIC Columns (Postgres vs YugabyteDB)
💡 TL;DR PostgreSQL allows NaN in NUMERIC. YugabyteDB currently does not. The best solution is to model “NaN” explicitly in your schema, […]
Read MoreMaking yb-admin list_snapshots Output Valid JSON
🧑💼 Customer Story A customer recently automated their backup validation pipeline and wanted to parse snapshot metadata using: yb-admin list_snapshots show_details JSON […]
Read MoreStoring 128-bit Integers in YugabyteDB (YSQL)
💡 Intro YSQL (like PostgreSQL) gives us INT (32-bit) and BIGINT (64-bit), but there’s no native 128-bit integer. So what happens when […]
Read More