The DISTINCT ON clause in YugabyteDB YSQL provides greater flexibility than the standard DISTINCT clause by allowing us to retrieve unique rows […]
Read More
Yet 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 MoreSet a GUC (Grand Unified Configuration) Parameter to its Default Value
In YugabyteDB, GUC stands for Grand Unified Configuration. These are configuration parameters that control various aspects of the database system, such as […]
Read More