Back to articles
I built Envoy - Control Plane for Painless PostgreSQL Schema Migrations
How-ToSystems

I built Envoy - Control Plane for Painless PostgreSQL Schema Migrations

via Dev.toFrancisco Luna

If you have some years of experience as a FullStack Developer, Dbadmin or DevOps engineer, you already know managing database migrations across Staging, QA, and Production is a mess. You already know how this game work: We switch .env files manually is dangerous and error-prone Then forget GRANT permissions in pgAdmin causes production downtime Audit logs are non-existent, scattered in sql files, or hard to verify Multiple tools required for simple database operations We build custom scripts we forget how to use Here's how every Friday was like in a regulated environment from an actual registered startup: I get the development database credentials Then replace the environment variable in .env file Run migration command with the orm Verify migration was successful Try changes in development Realize I forgot to give permissions to new tables Go back to pgAdmin/psql to fix permissions Try again Repeat next week across all environments Introducing Envoy This month I've built Envoy . It is

Continue reading on Dev.to

Opens in a new tab

Read Full Article
5 views

Related Articles