PtahBlog — Page 2
Practical guides to database schema changes with Ptah.
How to Detect PostgreSQL Schema Drift with Ptah
Detect PostgreSQL schema drift with Ptah: compare a desired schema to a live database, catch an unreviewed column in CI, and choose a safe response.
How to Evaluate Ptah on an Existing PostgreSQL Database
Try Ptah on a copy of an existing PostgreSQL database: inspect its schema, verify a baseline, generate a migration, and detect drift.
Ptah or Flyway OSS for Versioned PostgreSQL Migrations?
Run the same PostgreSQL change with Flyway OSS and Ptah, then check migration history and a live schema change.
What Is a Database Schema Plan? A Ptah Walkthrough
Follow a saved Ptah schema plan from an existing SQLite table through review, approval, application, and stale-plan recovery.
Generate OpenMeter's View Migrations Instead of Copying Them
OpenMeter copies generated view SQL into its migrations by hand. Ptah Compat writes those statements and keeps Ent, golang-migrate and schema_om.
Bring Spark's Partitioned SQL into the Diff with Ptah
Spark keeps its partitioned-table definition outside the Ent diff. Ptah brings it into schema review while Spark keeps control of daily partitions.
Reducing Kubernetes API Traffic in the Ptah Controller
How we removed repeated enrollment and result reads while keeping publication authority and deletion checks live, then measured the released operator.
Go Models and HCL Database Rules in One Ptah Schema
Declare tables with Go annotations, keep a shared PostgreSQL trigger function in HCL, and let Ptah merge both into one schema it diffs and migrates.
When Migration Releases Arrive Faster Than Reconciliation
Follow cumulative migration releases through one ordered plan, exact approval, Apply, and fresh history verification in Ptah Operator and Console.
Recover After Only Part of a MySQL Migration Commits
Observe a MySQL column addition surviving a failed index build, correct the duplicate data, and let Ptah resume at the recorded next statement.