PtahBlog
Practical guides to database schema changes with Ptah. Commands, examples, and the results they produce.
Ptah 0.8.1: The Online Migration Takes a Lock Timeout
Ptah 0.8.1 runs the generated online migration under a lock timeout, and ptah-compat now applies and lints an Atlas project on TimescaleDB.
From Flyway to Ptah Without Replaying Production
Import a Flyway history, verify it against an existing PostgreSQL database, and let Ptah apply the next change while preserving the application's data.
Shipping a Schema Through Harbor by Digest
Publish a schema to Harbor with Ptah, promote the same artifact, and prove that a digest-pinned Kubernetes deployment changes only when you select new content.
A Big Update to the Ptah Playground
The real Ptah CLI in your browser tab, against SQLite. What's new: guided steps, change marks in the editor, and a layout for phones.
Ptah 0.8.0: Change a Schema, Then Check What It Did
What Ptah 0.8.0 adds for changing a schema under a running application and checking afterwards what the change did, and where each part stops.
Your First Schema Change with the Ptah Kubernetes Operator
Publish a shipment schema with Ptah, inspect the operator's plan, approve that exact change, and verify the database has converged.
An AI Agent That Waits for Your Approval
A screencast of Ptah Assist: a model using Ptah's own tools to propose a schema change, with every write held until it is approved.
Making Order Currency Required While Checkout Keeps Writing
Use Ptah to make order currency required while old and new checkout writers run, with a measured PostgreSQL workload and bounded lock waits.
Same Migrations, Different Schemas: Adopting a Production Hotfix Back into Git
Detect schema drift with Ptah and adopt a production hotfix into Git while preserving the existing PostgreSQL index.