Initialize/Update D1 Database

When executing the wrangler login command for the first time, you will be prompted to log in. Follow the prompts to complete the login process.

Initialize Database

cd worker
cp wrangler.toml.template wrangler.toml
# Create D1 and execute schema.sql
wrangler d1 create dev
wrangler d1 execute dev --file=../db/schema.sql --remote

After creation, you can see the D1 database in the Cloudflare console.

Update Database Schema

For schema updates, please confirm your previously deployed version. Check the Changelog

Find the patch file you need to execute and run it, for example:

cd worker
wrangler d1 execute dev --file=../db/2024-01-13-patch.sql --remote
wrangler d1 execute dev --file=../db/2024-04-03-patch.sql --remote