When building a schema in YugabyteDB, you might catch yourself repeating the same constraints, like making sure emails are valid, integers are […]
Read More
A Cleaner Way to Extract Nested JSON Data in YSQL (with Postgres15 Support)
YSQL (YugabyteDB Structured Query Language) supports two dedicated data types to store JSON (JavaScript Object Notation) data. JSON Stores JSON data as […]
Read MoreExtract YCQL Types Into DDL Commands
Migrating system metadata between YCQL Universes can be challenging since system keyspaces, such as system_schema, cannot be transferred using simple INSERT INTO […]
Read MoreWhich Character Data Types in YSQL Preserve Preceding or Trailing Spaces?
The following character data types are supported in YugabyteDB YSQL: varchar(n): variable-length string char(n): fixed-length, blank padded text, varchar: variable unlimited length While […]
Read MoreBetter Performance on JSONB Data Value Search with a GIN Index
YSQL supports the JSON and JSONB data types which both can store JSON (JavaScript Object Notation) data. JSON stores an exact copy […]
Read More