Data Layer

Goal

This snapshot advances Driftwood Daily by teaching you to persist authors and posts with Cloudflare D1.

Every numbered folder is a complete app. Run this stage independently, then compare it with the previous folder.

Prerequisites

Use Node.js 20+, npm, and the Wrangler CLI. You should recognize async functions and HTTP verbs.

Port 8787 must be free. Copy .env.example before starting database stages.

• Node.js and npm
• A code editor and terminal
• Wrangler from part 4 onward

Concepts

D1 is SQLite at the edge. Each snapshot uses its own driftwood database binding.

Keep handlers thin: routes accept input, D1 queries enforce rules, and Hono JSX escapes output by default.

Walkthrough

Migrate tables on boot, seed Ada and Grace, list posts on the home page.

Read the example, then open the matching snapshot. The repository includes the surrounding setup and error handling.

const rows = await c.env.DB.prepare('SELECT ... FROM posts ORDER BY created_at DESC').all()

Run and verify

Enter 04-Data-Layer, install dependencies, copy .env.example when present, and start Wrangler on port 8787.

Open http://127.0.0.1:8787. Watch the terminal for validation and database errors.

git clone https://github.com/michaeldunga1/fcc-hono-blog.git
cd fcc-hono-blog/04-Data-Layer
npm install
cp .env.example .env
npm run dev

Troubleshooting

If the home page is empty after a bad migration, reset the local D1 database and restart.

For D1 failures, confirm Wrangler is running and the driftwood_NN binding matches this folder. Never commit .env or .wrangler secrets.

• Read the first error first
• Restart after environment changes
• Never commit secrets

Try this

Add a minimum title length check before insert.

Test a happy path and one invalid or unauthorized request.

• Make one small change
• Test it in the browser
• Compare with the next snapshot only after it works