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

Clone the database and install all dependencies:

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

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.

Create a new migration file using the d1 migrations subcommand:

$ npx wrangler d1 migrations create starter create_tables

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

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

$ npx prisma generate

Apply the migration to your local database:

$ npx wrangler@latest d1 migrations apply cdph-starter

When you're ready, deploy your application:

$ npx wrangler@latest deploy

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

duckhoa-uit/cloudflare-d1-prisma-honox-starter

cloudflare-d1-prisma-honox-starter

Installation