This repo has the code for https://northwind.d1sql.com/
- Cloudflare Workers for computing
- D1 for database
- Wrangler for building
- Typescript for better Javascript
- Tailwind CSS for the UI
- React for DOM interaction
- React Router v7 for the React framework
Requirements:
- You need a Cloudflare Account
- You need to get D1 enabled for your account
- Please join our developers Discord
- Please install nodejs (we're using v18.8.0), npm and npx
git clone https://github.com/cloudflare/d1-northwind
npm install
npm run remote:new
Get the output database id and add it to worker/wrangler.jsonc
"d1_databases": [
{
"binding": "DB",
"database_name": "northwind",
"database_id": "..."
}
]
npm run remote:init
npm run remote:load
Northwind is a React application. The source code is in the app folder folder.
To build a new version run:
npm run build
To run the dev server, run:
npm run dev
This project supports local development:
npm run local:init -w worker
npm run local:load -w worker
npm run dev
This will start the application at http://127.0.0.1:5173 with the database loaded with data.
Wrangler will persist a local SQLite compatible sql file which you can access to with other clients:
sqlite3 src/.wrangler/state/v3/d1/*/db.sqlite
.tables
Deploy to production when you're done.
npm run deploy