Database migration using sqlite

Questions / Help
,
1

What is the best way to run a database migration using a sqlite database on fly.io?

Should I place my migration script in my Dockerfile or my fly.toml

For reference, this is my migration script in my package.json

"db:up": "vite-node ./src/lib/server/migrate.ts"

Is there anyway to do a sort of dry run, before fly deploy?

2

You could use docker entrypoint with a script.

Dockerfile:

COPY ./entrypoint.sh .

...

ENTRYPOINT ["sh", "entrypoint.sh"]

entrypoint.sh:

#!/bin/env sh

set -e

npm run db:up

exec npm start
3

I just run it in the code. Doing it in Dockerfile is also a good idea.