PtahBlog — Page 4
Practical guides to database schema changes with Ptah.
Add a Non-NULL Column to an Existing SQLite Table
Give existing SQLite orders a new column, inspect Ptah’s generated SQL, and check preserved rows, foreign keys, replay, and rollback.
Take Your First Ptah Project to PostgreSQL
Generate PostgreSQL migrations for the new order service, test them on a scratch database, and verify the same application contract after fresh replay.
Start a New Service with Ptah and SQLite
Build an order service from an empty database: generate reviewed SQL, test the first migration, and run a small application with Ptah.
Test the Data Your Migration Must Preserve
Catch a migration that silently loses a price, test the corrected SQL and rollback, and share native Ptah test reports without a vendor account.
Customer's Case Study: Fewer Baseline Steps with Ptah
A customer's Atlas migration experiment showed where Ptah removes manual baseline work, adds SQL review, and needs care before replacing a custom runner.
Ptah Is Now Verified on Context7
Ptah is now verified on Context7. Give your coding assistant access to our documentation and migration examples with the library ID /stokaro/ptah.
10 Reasons to Choose Ptah over Atlas
Atlas Pro-like workflows in an open-source stack you can host yourself: schema checks, private artifacts, reviewed AI changes, and no third-party telemetry.
Ptah MCP: Inspect the Tools Before You Trust the Write
Connect MCP Inspector to Ptah, inspect a migration patch, approve it once, and see stale previews refused before deploying to PostgreSQL.
Manage YDB Schemas and Migrations with HCL
Use Ptah to generate YDB migrations from HCL, preserve existing rows, detect drift, and replay the migration history on a disposable database.
Ptah 0.13.0: Native YDB Schemas and Migrations
Ptah 0.13.0 adds native YDB migrations and desired YQL schemas, expands dev databases, and improves locking and schema comparison across engines.