cloudflare-d1-prisma-honox-starter

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

[!TIP] If the above paragraph was a bunch of buzzwords that seem confusing, here's the simple version:

• HonoX is a full-stack framework combining backend API endpoints with the ability to render frontend applications with React
• Cloudflare D1 is a SQL database
• Prisma provides an ORM wrapper around D1, to allow data models and querying using a straightforward syntax

Installation

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. Create a new D1 database using Wrangler:

$ npx wrangler@latest d1 create starter # or name it something of your choice

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

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

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

$ npx wrangler d1 migrations create starter create_tables

3. 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

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

$ npx prisma generate

5. Apply the migration to your local database:

$ npx wrangler@latest d1 migrations apply cdph-starter

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

$ npx wrangler@latest deploy

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

$ npx wrangler@latest d1 migrations apply cdph-starter --remote