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 More
YSQL – 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 MoreNavigate Wide Query Output in YSQLSH Using Your Left and Right Arrow Keys
Using ysqlsh and annoyed by wrapping lines creating difficult-to-read outputs? Try setting the PAGER environment variable, when starting ysqlsh (then you’ll be […]
Read More