README.md

PostgreSQL migrations

Super simple PostgreSQL migrations for postgresjs in Deno

Import

import { migrate } from "https://deno.land/x/[email protected]/mod.ts";

Migrate

The migrate function will look (if not specified otherwise via options) in the migrations folder for .sql files. It's up to you how you sort your .sql files. An example is:

migrations\
  1_create_users_table.sql
  2_create_posts_table.sql
  3_alter_users_table_with_role.sql

Usage

import postgres from "https://deno.land/x/[email protected]/mod.js";
import { migrate } from "https://deno.land/x/[email protected]/mod.ts";

const sql = postgres("postgres://johndoe:secret@localhost:5432/example");

await migrate(sql, {
  path: "./db/migrations"
});