YSQL (YugabyteDB Structured Query Language) supports two dedicated data types to store JSON (JavaScript Object Notation) data. JSON Stores JSON data as […]
Read More
DISTINCT 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 MoreView YugabyteDB Recent Releases from the Web, an RSS Feed or the Command Line
The list of the latest stable and preview releases of YugabyteDB can be found via the fabulous World Wide Web here: YugabyteDB […]
Read MoreGENERATED BY DEFAULT AS IDENTITY vs GENERATED ALWAYS AS IDENTITY
Identity columns in YugabyteDB automatically generate unique numbers for a column. They are defined using the GENERATED BY DEFAULT AS IDENTITY or […]
Read More