When you’re spinning up a new YugabyteDB instance, it’s often useful to pre-load your database with schema definitions, seed data, or custom […]
Read More
Extract Tablespace DDL in YugabyteDB using ysql_dumpall
YugabyteDB is a distributed SQL database with PostgreSQL compatibility that lets you manage data across multiple regions while ensuring high availability. It […]
Read MoreAudit 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 More