In YSQL (Yugabyte Structured Query Language), idle sessions refer to database connections that remain open but are not actively executing queries. These […]
Read More
Keep Track of Who Created a Table and When…
When a table is created in YSQL, the catalog does not store information about the user who created it or the time […]
Read MoreYSQL – Treat NULL as Distinct in Constraints
In a previous YugabyteDB Tip, we explored how constraints like a unique index allow multiple NULL values to be inserted. The tip […]
Read MoreA 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 More