PtahArticles tagged “postgres”
Guides and worked examples about postgres with Ptah.
Database Migration Tools: Ptah, Atlas, Flyway, Liquibase, and Goose
Choose a database migration tool by its source of truth, review workflow, drift check, database coverage, and deployment model.
Ptah or Liquibase Community for an Existing PostgreSQL Workflow?
Run the same PostgreSQL change with Liquibase Community and Ptah, then compare edited history, rollback, and checks for changes made outside the changelog.
Ptah Operator vs SchemaHero: Kubernetes Schema Operators Compared
We ran Ptah Operator and SchemaHero on one cluster: stale plans, destructive changes, drift, failed statements, approvals, and PostgreSQL coverage.
How to Compare Two PostgreSQL Databases with Ptah
Compare two PostgreSQL schemas, such as staging and production, with one Ptah command. Read every difference as SQL and review it before anything runs.
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.
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.
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.