Drizzle TeamDT
Drizzle Team•2y ago
Gabriel Lucena

Help querying D1 with Drizzle

I was able to run migrations with this 
drizzle.config.ts
:

import { defineConfig } from "drizzle-kit"

import { env } from "./env.mjs"

export default defineConfig({
  dialect: "sqlite",
  driver: "d1-http",
  out: "./src/data/migrations",
  schema: "./src/data/schema/*",
  migrations: { table: "migrations" },
  dbCredentials: {
    accountId: env.CLOUDFLARE_ACCOUNT_ID,
    databaseId: env.CLOUDFLARE_DATABASE_ID,
    token: env.CLOUDFLARE_TOKEN,
  },
})


but I'm not sure how to connect with the database to run queries on it, one previous example I've used with RDS was:

const client = new RDSDataClient({})

export const db = drizzle(client)


does anyone knows how can I do the same but with D1?
Was this page helpful?