gem-hunter

A starter project showing how you can integrate Prisma and Cloudflare D1 with a HonoX application to build awesome full-stack apps.

0. Clone the database and install all dependencies:

$ git clone https://github.com/kristianfreeman/cloudflare-d1-prisma-honox-starter starter
$ cd starter
$ npm install

1. Copy the wrangler.toml.example file to wrangler.toml and fill in the necessary values:

$ cp wrangler.toml.example wrangler.toml

• Replace $APP_NAME with your Cloudflare Workers application name
• Replace $CURRENT_DATE with the current date like this 2022-01-01

2. Create a new D1 database using Wrangler:

$ npx wrangler d1 create <your-database-name>

Note that if you haven't yet used Wrangler, you will be prompted to log in to Cloudflare.

Copy the output of this command, which is structured TOML configuration, into your wrangler.toml.

3. Create a new migration file using the d1 migrations subcommand:

$ npx wrangler d1 migrations create <your-database-name> create_tables

4. Using Prisma's CLI, generate a SQL file based on your Prisma schema in the empty migration file you just created:

$ npx prisma migrate diff \
  --from-empty \
  --to-schema-datamodel ./prisma/schema.prisma \
  --script \
  --output migrations/0001_create_tables.sql

5. Generate the necessary Prisma files for Zod validations and any other configured Prisma outputs:

$ npx prisma generate

6. Apply the migration to your local database:

$ npx wrangler d1 migrations apply <your-database-name>

7. When you're ready, deploy your application:

$ npm run deploy

8. Once you've deployed your application, you can apply the migrations to your remote (production) D1 database:

$ npx wrangler d1 migrations apply <your-database-name> --remote