JSONB is incredibly flexible in YSQL. It lets you store semi-structured data, evolve your schema over time, and keep related attributes together […]
Read More
Making JSONB Feel Less Cumbersome for MongoDB Users
A customer recently asked a great question about working with jsonb attributes in YugabyteDB: 1. Are JSONB attribute values always returned as […]
Read MoreWhy ORDER BY Can Sort a Value Differently Than What You See
Sometimes a query result looks wrong at first glance… until you realize YugabyteDB is doing exactly what the type system told it […]
Read MoreHandling 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 More