***UNDER DEVELOPMENT node-pg-migrate boilerplate app for supabase
- Create a project directory and cd into it:
mkdir supabaseDBApp &&cd supabaseDBApp- install dependencies:
yarn install- Create a file called
.envand copy the contents ofexample.envinto it. - Copy the database connection string from the supabase console and update the DATABASE_URL in the .env file.
DATABASE_URL=[paste your connection string here]
Commands to be run from project root like so:
yarn [command] [args]| command | description |
|---|---|
| sg:create [migration-name] | create a new migration file in the migrations directory |
| sg:up {N} | runs all up migrations from the current state; optional int to run next N migrations |
| sg:down {N} | rollback latest migration; optional int to rollback last N migrations |
| sg:redo {N} | redo latest migration; optional int to redo last N migrations |
| sg:downall | rollback all migrations |
| sg:deploy:staging | apply all migrations using .env.staging |
| sg:deploy:prod | apply all migrations using .env.prod |
| sg:down:staging {N} | rollback N (default 1) migrations using .env.staging, |
| sg:down:prod {N} | rollback N (default 1) migrations using .env.prod |