Sometimes a simple SQL feature can make reporting queries much easier to read. One of my favorite examples is PostgreSQL’s FILTER clause […]
Read More
Expanding Pure SQL Table DDL Export in YugabyteDB: Indexes, Constraints, Triggers, and Partitions
In a previous YugabyteDB Tip, we built a pure SQL function to export a table’s CREATE TABLE DDL directly from YugabyteDB system […]
Read MoreHow to Protect Your Database from Accidental DROP DATABASE
🚨 The Problem Today a customer asked a great (and very real) question: “What if a DBA accidentally runs DROP DATABASE on […]
Read MoreDate Offset Views (Make Old Data Look New)
🤔 The Question You’ve got a dataset… but all the dates are from the 1970s. You want to: ● Keep the original […]
Read More