If you’re working in ysqlsh, YugabyteDB’s interactive SQL shell, you may not know about a small but powerful command: p. The p […]
Read More
Automatically Run SQL Scripts on Startup with yugabyted
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 MoreExtract 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 More