This example demonstrates how to create an API to access Cloudflare D1 from an external app.

Note: This example is meant for demonstration purposes only. Please make sure you follow the best security practices to use it in production.

• Hono
• Cloudflare D1
• Cloudflare Workers

• Sign up for a Cloudflare account.
• Install npm.
• Install Node.js.

Clone the project on your local machine by running the command:

$ git clone https://github.com/harshil1712/d1-http-example.git

Install the required dependencies using the following command:

$ npm i

Generate an API Key with the following command:

openssl rand -base64 32

Copy the generated value.

Next, rename .dev.vars.example to .dev.vars. Replace YOUR_API_KEY with the value generated above.

Execute the following command to create a new D1 database.

$ npx wrangler d1 create d1-http-example

You might be asked to login to your Cloudflare. Once logged in, the command will create a new D1 database.

Make a note of the displayed database_name and database_id. You will use this to reference to the database by creating a binding.

In the wrangler.toml file, update the value for database_name and database_id.

Create a table in your D1 database with the schema from schemas/schema.sql file using the following command:

$ npx wrangler d1 execute d1-http-example --file=./schemas/schema.sql

Execute the following command to start the development.

$ npm run dev

Your API will be availabe at http://localhost:8787.

To test the API, execute the following cURL commands. Make sure to replace YOUR_API_KEY with the correct value.

---
header: /api/all
---
$ curl -H "Authorization: Bearer YOUR_API_KEY" "http://localhost:8787/api/all" --data '{"query": "SELECT title FROM posts WHERE id=?", "params":1}'

---
header: /api/batch
---
$ curl -H "Authorization: Bearer YOUR_API_KEY" "http://localhost:8787/api/batch" --data '{"batch": [ {"query": "SELECT title FROM posts WHERE id=?", "params":1},{"query": "SELECT id FROM posts"}]}'

---
header: /api/exec
---
$ curl -H "Authorization: Bearer YOUR_API_KEY" "localhost:8787/api/exec" --data '{"query": "INSERT INTO posts (author, title, body, post_slug) VALUES ('\''Harshil'\'', '\''D1 HTTP API'\'', '\''Learn to create an API to query your D1 database.'\'','\''d1-http-api'\'')" }'

First, create a table in the remote (production) database. Execute the following command:

$ npx wrangler d1 execute d1-http-example --file=./schemas/schema.sql --remote

Next, deploy your application using the below command.

$ npx wrangler deploy

Lastly, add the API_KEY as the environment variable with the following command.

$ npx wrangler secret put API_KEY

Enter the value of your API key. Your API key will get added to your project. Using this value you can make secure API calls to your deployed API.