PtahArticles tagged “postgres” — Page 3
Guides and worked examples about postgres with Ptah.
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.
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.
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.