Postgres migrations

A step of the Cloud application tree on Gradus, in the Data & storage area: DB, cache, queues.

Add a migration tool, write the first schema from the first journey and run migrations on every deploy before the new revision takes traffic.

One option of Database: Managed Postgres. The others: Document database.

Usually comes after: Managed Postgres.

Prompt for your AI assistant

Add a migration tool for Postgres to this service, write the first migration with the tables the first journey in docs/product/mvp.md needs and run pending migrations in the deploy workflow before the new revision takes traffic, failing the deploy if a migration fails. Document how to write and run a migration in docs/.

• Show on map
• This step as Markdown
• Every step of the tree, for AI assistants

This is https://gradus.kazet.blog/tree/cloud-application/step/db-postgres-migrations as plain HTML. In a browser the page also lets you mark the step forged and copy a message for your AI assistant.