drizzle_orm_postgres_migration_runner_quickstart.ts

1import { drizzle } from 'drizzle-orm/postgres-js';
2import { migrate } from 'drizzle-orm/postgres-js/migrator';
3import postgres from 'postgres';
4
5// for migrations
6const migrationClient = postgres("postgres://postgres:password@host:port/db", { max: 1 });
7
8async function main() {
9  await migrate(drizzle(migrationClient), { migrationsFolder: './drizzle' });
10  
11  await migrationClient.end();
12}
13
14main();