Drizzle Team•2mo ago

How to run migrations in production environment?

I'm using drizzle with sveltekit and ATM I run migrations locally using the following scripts I have in my package.json,

        "db:generate": "drizzle-kit generate --name=drizzle",
        "db:migrate": "tsx src/lib/server/database/migrate.ts",
        "db:drop": "drizzle-kit drop",

        "db:generate": "drizzle-kit generate --name=drizzle",
        "db:migrate": "tsx src/lib/server/database/migrate.ts",
        "db:drop": "drizzle-kit drop",

migrate.ts file has this,

import { logger } from "$lib/logger";
import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';

if (!process.env.DATABASE_URL) {
    logger.error("DATABASE_URL is not set");

    process.exit(1);
}

async function main() {
    const migrationClient = postgres(process.env.DATABASE_URL as string, { max: 1 });

    await migrate(drizzle(migrationClient), {
        migrationsFolder: "./src/lib/server/database/migrations",
    })

    await migrationClient.end()
}

main()

import { logger } from "$lib/logger";
import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';

if (!process.env.DATABASE_URL) {
    logger.error("DATABASE_URL is not set");

    process.exit(1);
}

async function main() {
    const migrationClient = postgres(process.env.DATABASE_URL as string, { max: 1 });

    await migrate(drizzle(migrationClient), {
        migrationsFolder: "./src/lib/server/database/migrations",
    })

    await migrationClient.end()
}

main()

9 Replies

CyberCipherOP•2mo ago

now in production I have don't have drizzle-kit available as I have it installed as a dev dependency.

CyberCipherOP•2mo ago

I found this stackoverflow post,https://stackoverflow.com/questions/77877947/how-to-run-generate-migrate-in-production-on-a-vps-with-sqlite-database-using but the example link provided is dead so I can't what they do to achieve it.

Stack Overflow

How to run generate & migrate in production on a VPS with SQLite da...

So I have a database in development that I run db:generate & db:migrate on to create the database & then run my app that uses that database. And it works fine. But how do I do that in produ...

CyberCipherOP•2mo ago

But reading from the post, it seems like they run migrations on their app start.. what does that mean exactly? like run all the code from migrate.ts when my app starts? I would like to keep migration a separate command ran from script or something if possible. Can anyone help?

Coaster•2mo ago

Hey, check out this part of the docs: https://orm.drizzle.team/docs/migrations, most likely section 4 If you want Drizzle to manage migrations for you while keeping it a seperate command, running your code in migrate.ts before running the start command sees like a good option. You could set up your production start command to be tsx migrate.ts && <sveltekit start command> which would migrate the database using the generated migrations, and then run the svelte kit app. Let me know if that made sense

CyberCipherOP•2mo ago

So the migrate script I have ATM I need that to run before the svelte app? and running that script will be my separate "command"..

Coaster•2mo ago

Yes

CyberCipherOP•2mo ago

I see.. is it OK to always run the migrate script every time I start app? it mostly just throw warning already exist skipping etc.. but it shouldn't cause any harm right? or should I not run it every time?

Coaster•2mo ago

Yeah it won't hurt anything to run it every time as long as you are not pushing unsafe migrations

CyberCipherOP•2mo ago

I see.

Gaming

Programming

How to run migrations in production environment?

Did you find this page helpful?