PtahArticles tagged “schema” — Page 4
Guides and worked examples about schema with Ptah.
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.
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.
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.
Atlas CE Doesn't Manage Postgres RLS. Ptah Does.
Atlas Community leaves PostgreSQL row-level security outside schema management. We tested Ptah Compat to manage tables, RLS policies, and grants together.
Generating erun's PostgreSQL Migrations with Ptah Compat
Keep erun's Atlas commands and migration history while generating PostgreSQL triggers, RLS policies, grants, and conditional role declarations.
Adding pgvector Search Without Serving Stale Embeddings
Use Ptah and a real local model to add vector search, catch source changes, test retrieval, and refuse a cutover whose evidence is out of date.
Replacing HCI's Atlas Workaround with Ptah Compat
We replaced HCI's split Atlas and psql schema deployment with one Ptah Compat desired state, preserving functions, triggers, and pgvector indexes.
Atlas CE Drop-In Replacement: What ptah-compat Found in wpmgr
We ran ptah-compat, an Atlas CE drop-in replacement, on wpmgr. It wrote an RLS policy migration Atlas CE skipped, and found schema.sql out of date.