Cloudflare d1

Create a database

wrangler d1 create <DATABASE_NAME>

----
filename: wrangler.toml
----

[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "<DATABASE_NAME>"
database_id = "<unique-ID-for-your-database>"

Write queries within your Worker

import { D1QB } from 'workers-qb'

export interface Env {
  DB: any
}

export default {
  async fetch(request: Request, env: Env, ctx: ExecutionContext): Promise<Response> {
    const qb = new D1QB(env.DB)

    const fetched = await qb
      .fetchOne({
        tableName: 'employees',
        fields: 'count(*) as count',
        where: {
          conditions: 'active = ?1',
          params: [true],
        },
      })
      .execute()

    return Response.json({
      activeEmployees: fetched.results?.count || 0,
    })
  },
}

Batch queries

One of the main Cloudflare D1 features is the ability to batch together a bunch of queries and execute them in a single run.

import { D1QB } from 'workers-qb'

export interface Env {
  DB: any
}

export default {
  async fetch(request: Request, env: Env, ctx: ExecutionContext): Promise<Response> {
    const qb = new D1QB(env.DB)

    const fetched = await qb.batchExecute([
      qb.fetchAll({
        tableName: 'tableA',
        fields: '*',
      }),
      qb.fetchAll({
        tableName: 'tableB',
        fields: '*',
      }),
    ])

    return Response.json({
      tableARows: fetched[0].results,
      tableBRows: fetched[1].results,
    })
  },
}