Migrations
When developing locally, use
copper run
to run database migrations before starting the app server. You can disable this behavior with copper run -migrate=false
.To run migrations in production, use the
migrate
binary built by copper build
. This binary can be run with prod.toml
configuration on your server.Migrations are stored in the
migrations/
directory found at the root of the project. By default, it already has 0001_initial.sql
in it that looks similar to --- +migrate Up
-- +migrate Down
You can SQL statements that update your database schema after the
-- +migrate Up
line and SQL statements that rollback those changes after the -- +migrate Down
line --- +migrate Up
CREATE TABLE rockets (
id text PRIMARY KEY,
name text
);
-- +migrate Down
DROP TABLE rockets;
Each migration file can only be applied once. Once a migration has been applied, create a new migration file
migrations/0002_launches.sql
. Continue creating a new migration file for each change to your database schema.Last modified 10mo ago