yusukebe / cloudflare-d1-drizzle-honox-starter

cloudflare-d1-drizzle-honox-starter

cloudflare-d1-drizzle-honox-starter

A starter project showing how you can integrate Drizzle ORM 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
• Drizzle ORM provides an ORM wrapper around D1, to allow data models and querying using a straightforward syntax

Installation

0. Clone the template and install all dependencies

git clone [email protected]:yusukebe/cloudflare-d1-drizzle-honox-starter.git starter
cd starter
npm install

1. Create a new D1 database using Wrangler

npx wrangler@latest d1 create d1-todo

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

npm run migration:generate

3. Apply the migration to your local database

npm run migration:apply:local

4. When you're ready, deploy your application

npm run deploy

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

npm run migration:apply:remote

Prisma Version

You can see the starter using Prisma instead of Drizzle ORM:

• https://github.com/kristianfreeman/cloudflare-d1-prisma-honox-starter

Author

Yusuke Wada https://github.com/yusukebe

License

MIT

cloudflare-d1-drizzle-honox-starter's Issues

Not accessible in development mode

pnpm run dev

> sendx@ dev /Users/doit/sendx
> vite

Proxy environment variables detected. We'll use your proxy for fetch requests.
(!) Could not auto-determine entry point from rollupOptions or html files and there are no explicit optimizeDeps.include patterns. Skipping dependency pre-bundling.

  VITE v5.2.10  ready in 1623 ms

  ➜  Local:   http://localhost:5173/
  ➜  Network: use --host to expose
  ➜  press h + enter to show help
Sourcemap for "/Users/guanwei/i/doit/sendx/node_modules/.pnpm/[email protected][email protected][email protected]/node_modules/drizzle-zod/index.mjs" points to missing source files
POST  /
GET   /
POST  /todos/clear_completed
POST  /todos/:id/toggle

Deploy or package preview locally, all access is normal

http://localhost:5173/ There has been no response to web visits