PtahBlog — Page 5
Practical guides to database schema changes with Ptah.
Add Shipment Tracking in a Ptah Assist Session
Start a conversation, change a requirement, and watch Assist revise the SQL before you approve the migration files.
From Atlas to Ptah: Keep the History, Control the Deployment
Continue an Atlas migration history with Ptah, catch a changed payment-queue view, and test both CLIs without external network access.
A Supabase Image as the Atlas Dev Database, Grants Included
Generate migrations against a dev database built from supabase/postgres while Ptah Compat keeps the image's grants and serial sequences intact.
Database Migrations Without Kubernetes: A Ptah CI Pipeline
Run a dispatch worker only after its migration and schema checks pass, then test drift, SQL failure, retries, and cancellation.
Transactional SQLite Upgrades and Full-Text Search with Ptah
We tested Ptah in MailCollector to turn repeated startup schema changes into recorded upgrades and add FTS5 search while preserving existing mail.
Replacing Atlas CE in Scooter to Generate Function and Trigger Migrations
We tested Ptah Compat in Scooter's existing migration workflow, adding PostgreSQL functions and triggers to desired SQL while preserving Atlas history.
What Migration Linters Catch Before Production
Reproduce lost column values, blocked writers, and a failing NOT NULL change, then compare the database results with Ptah's warnings and exit codes.
Ptah 0.12.0: Conditional PostgreSQL Roles in Desired SQL
Ptah 0.12.0 reads conditional PostgreSQL role declarations. Catch up on SQL preservation, migration loading, and container updates since 0.11.0.
Changing Embedding Models: Zengram Before and After Ptah
We tested a small Zengram integration that builds replacement embeddings with Ptah while old search keeps serving, then coordinates the final handover.
Replacing Atlas with Ptah: Preserve History and Reject Invalid Indexes
We tested Akashi's TimescaleDB migrations with Ptah Compat: the Atlas history stays readable, while an invalid concurrent index blocks migration success.