In a previous YugabyteDB Tip, we explored how constraints like a unique index allow multiple NULL values to be inserted. The tip […]
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 MoreDISTINCT ON in YugabyteDB YSQL: The Elegant Way to Select Top Records
The DISTINCT ON clause in YugabyteDB YSQL provides greater flexibility than the standard DISTINCT clause by allowing us to retrieve unique rows […]
Read MoreYet Another Way to List the Latest Releases of YugabyteDB from the Command Line
As mentioned in a previous YugabyteDB Tip, we can view the recent releases of YugabyteDB via the web, an RSS feed, or […]
Read More