D1 is Cloudflare's native serverless SQL database (docs). This project demonstrates using a Worker with a D1 binding to execute a SQL statement. A simple frontend displays the result of this query:

SELECT * FROM comments LIMIT 3;

The D1 database is initialized with a comments table and this data:

INSERT INTO comments (author, content)
VALUES
    ('Kristian', 'Congrats!'),
    ('Serena', 'Great job!'),
    ('Max', 'Keep up the good work!')
;

Outside of this repo, you can start a new project with this template using C3 (the create-cloudflare CLI):

npm create cloudflare@latest -- --template=cloudflare/templates/d1-template

A live public deployment of this template is available at https://d1-template.templates.workers.dev

1. Install the project dependencies with a package manager of your choice:

   npm install

2. Create a D1 database with the name "d1-template-database":

   npx wrangler d1 create d1-template-database

   ...and update the database_id field in wrangler.json with the new database ID.
3. Run the following db migration to initialize the database (notice the migrations directory in this project):

   npx wrangler d1 migrations apply --remote d1-template-database

4. Deploy the project!

   npx wrangler deploy