Articles tagged “schema”
Guides and worked examples about schema with Ptah.
Ptah 0.25.0 Release: From Native YDB to a Provider Platform
A visual guide to the releases since our Ptah 0.13.0 post: provider engines, safer schema changes, and clearer limits in Ptah 0.25.0.
Try DuckDB in the Ptah Playground
DuckDB is now in the Ptah Playground. Preview schema changes, detect drift, and try versioned migrations in your browser without installing anything.
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.
Atlas vs Ptah: An Open Source Choice for Schema Management
Compare Atlas and Ptah by the database jobs they solve: plans, approvals, migrations, drift, OCI distribution, plugins, and rollout boundaries.
The Hard Parts of Moving YDB into a Ptah Plugin
How we extracted YDB into a Ptah plugin, from semantic ownership and release decisions to lock failures, performance, model identity, and parity.
Add Your Database to Ptah with a Plugin
Build a database plugin on Ptah's provider API, or use the official YDB, Spanner, and DuckDB plugins. See the capabilities and a complete DuckDB example.
Manage DuckDB Schemas and Migrations with a Ptah Plugin
Use Ptah's official DuckDB plugin to inspect an embedded database, generate reviewable SQL migrations, apply them, and verify the result.
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.