PtahBlog — Page 6
Practical guides to database schema changes with Ptah.
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.
Doctrine Models with Ptah: Reviewing SQL Before Deployment
Keep Doctrine entities and queries, use Ptah to review and rehearse SQL migrations, and compare the result with Doctrine's native migration workflow.
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.
Ptah 0.11.0: A Schema Plan Can Span a MySQL Server
Plan several MySQL databases together, defer PostgreSQL constraint validation, and keep index options with Ptah 0.11.0.
GORM with a Reviewed Ptah Migration
Move schema changes out of a Go application's startup, adopt its existing GORM database with Ptah, and deploy a reviewed change before starting the new code.
SQLAlchemy Models, Ptah Migration Review
Turn an Alembic development schema into a reviewed Ptah migration, then catch a missing database default that successful SQLAlchemy inserts can hide.
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.
The Ptah Playground Now Runs PostgreSQL
play.ptah.run now runs PostgreSQL 18.3 in your browser tab through PGlite. A new scenario queries JSONB, then plans and applies a GIN index with Ptah.