YugabyteDB is a distributed SQL database with PostgreSQL compatibility that lets you manage data across multiple regions while ensuring high availability. It […]
Read More
Audit Selects on a Table to an Audit Table Using RLS
In PostgreSQL—and by extension, YugabyteDB—there’s no native trigger that fires on SELECT statements. This means we can’t use a traditional AFTER SELECT […]
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 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 MoreDisplay Tablet Leader/Follower Status on a Node
We learned in the YugabyteDB Tip View Metadata for YSQL/YCQL/System Tablets on a Server about the new (in YugabyteDB 2024.1) system view yb_local_tablets. The view […]
Read More