Database Access

Querying D1 database

Database Access

D1 Database Queries

Basic Query:

const result = await env.DB.prepare(
  'SELECT * FROM news WHERE id = ?'
).bind(newsId).first()

Query Multiple Rows:

const result = await env.DB.prepare(
  'SELECT * FROM news ORDER BY created_at DESC'
).all()

Prisma Client

const prisma = new PrismaClient({ adapter: new PrismaD1(env.DB) })

const news = await prisma.news.findMany({
  where: { published: 1 },
  include: { tags: true }
})

Batch Operations

await env.DB.batch([
  stmt1.bind(...),
  stmt2.bind(...)
])