PtahArticles tagged “schema” — Page 2
Guides and worked examples about schema with Ptah.
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.
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.
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.
From OCI Artifacts to Database Plans in Ptah Operator
Follow a schema or migration update from an OCI registry to a verified database change, with real Ptah Console plans and approval decisions.
Watch a Schema Change in Ptah's Drift View
Schema drift means the live database no longer matches the schema file in Git. Add a column by hand, see the read-only viewer report it, then decide what to do.
Give Your Team a Database Reference They Can Open
Export a self-contained Ptah HTML reference with tables, relationships, navigation, and light and dark themes, then inspect the actual result.
Draw the Database You Actually Have
Turn a live SQLite catalog into a Ptah entity diagram, trace the order relationships, and retain both the inspected SQL and the generated image.
Read a ClickHouse Schema as a Columnar Design
Run Ptah migrations on ClickHouse, inspect MergeTree ordering and defaults, and verify the SQL export and migration replay.
Review a MySQL Schema Change Before It Runs
Generate a tracking-code migration for MySQL, review the native SQL, and verify old orders, application updates, and a fresh replay.