How do i import that into my project? afaik wrangler is a cli thing no?

DDahoom How do i import that into my project? afaik wrangler is a cli thing no?

H

You don't. If you add a D1 Binding to your Worker, then it will just work

export default {
  async fetch(req, env) {
    // ...
    const result = await env.D1.exec("SELECT * FROM db;");
    // ...
  }
}

export default {
  async fetch(req, env) {
    // ...
    const result = await env.D1.exec("SELECT * FROM db;");
    // ...
  }
}

export default {
  async fetch(req, env) {
    // ...
    const result = await env.D1.exec("SELECT * FROM db;");
    // ...
  }
}

export default {
  async fetch(req, env) {
    // ...
    const result = await env.D1.exec("SELECT * FROM db;");
    // ...
  }
}

D

DahoomOP•6/13/23, 7:50 AM

thing that confuses me is that im trying to use a pages function here

DDahoom thing that confuses me is that im trying to use a pages function here

H

Hello, I’m Allie!•6/13/23, 7:52 AM

Pages Functions is the same, it should be present on the

ctx.env

ctx.env

ctx.env

ctx.env object.

export const onRequestGet = ctx => {
  const result = await ctx.env.D1.exec("SELECT * FROM db;");
  // ...
};

export const onRequestGet = ctx => {
  const result = await ctx.env.D1.exec("SELECT * FROM db;");
  // ...
};

export const onRequestGet = ctx => {
  const result = await ctx.env.D1.exec("SELECT * FROM db;");
  // ...
};

export const onRequestGet = ctx => {
  const result = await ctx.env.D1.exec("SELECT * FROM db;");
  // ...
};

D

DahoomOP•6/13/23, 8:04 AM

I'm a little stupid, for the .env item what should i add? my wrangler.toml file looks like this but i dont think its working:

[[d1_databases]]
binding = "DataB"
database_name = "thing"
database_id = "dwadwadwad3213dsfasfdaeiu2"

[[d1_databases]]
binding = "DataB"
database_name = "thing"
database_id = "dwadwadwad3213dsfasfdaeiu2"

[[d1_databases]]
binding = "DataB"
database_name = "thing"
database_id = "dwadwadwad3213dsfasfdaeiu2"

[[d1_databases]]
binding = "DataB"
database_name = "thing"
database_id = "dwadwadwad3213dsfasfdaeiu2"

if i have to create a .env file would i format it the same way?

DDahoom I'm a little stupid, for the .env item what should i add? my wrangler.toml file ...

H

Hello, I’m Allie!•6/13/23, 8:05 AM

You don't use

wrangler.toml

wrangler.toml

for Pages, you pass bindings via the CLI

HHello, I’m Allie!You don't use `wrangler.toml` for Pages, you pass bindings via the CLI

D

DahoomOP•6/13/23, 8:40 AM

do you mean wrangler pages dev --d1 db -- vite or some other method?

I

Isak•6/13/23, 11:10 AM

Is it possible to cache database queries using the cache API inside workers? Do you simply make a response with the data with some random url and call it a day?

DDahoom do you mean wrangler pages dev --d1 db -- vite or some other method?

M

Matt Silverlock•6/13/23, 11:14 AM

https://developers.cloudflare.com/pages/platform/functions/bindings/#d1-databases

Bindings · Cloudflare Pages docs

A binding enables your Pages Functions to interact with resources on the Cloudflare developer platform. Use bindings to integrate your Pages Functions …

IIsak Is it possible to cache database queries using the cache API inside workers? Do ...

M

Matt Silverlock•6/13/23, 11:15 AM

d1-database

MMatt Silverlock https://discord.com/channels/595317990191398933/992060581832032316/1117859495134...

I

Isak•6/13/23, 12:15 PM

Thanks was to lazy to search the threads.

S

sokorototo•6/13/23, 12:21 PM

Any idea why

wrangler d1 execute EmailTracker --command='SELECT * FROM SenderInfo WHERE email = "drnewt536@gmail.com";'

wrangler d1 execute EmailTracker --command='SELECT * FROM SenderInfo WHERE email = "drnewt536@gmail.com";'

wrangler d1 execute EmailTracker --command='SELECT * FROM SenderInfo WHERE email = "drnewt536@gmail.com";'

wrangler d1 execute EmailTracker --command='SELECT * FROM SenderInfo WHERE email = "drnewt536@gmail.com";' fails, yet

wrangler d1 execute EmailTracker --command="SELECT * FROM SenderInfo WHERE email = 'drnewt536@gmail.com';"

wrangler d1 execute EmailTracker --command="SELECT * FROM SenderInfo WHERE email = 'drnewt536@gmail.com';"

wrangler d1 execute EmailTracker --command="SELECT * FROM SenderInfo WHERE email = 'drnewt536@gmail.com';"

wrangler d1 execute EmailTracker --command="SELECT * FROM SenderInfo WHERE email = 'drnewt536@gmail.com';" passes

S

sokorototo•6/13/23, 12:21 PM

I just changed it from

"--"

"--"

"--"

"--" to

'--'

'--'

'--'

'--'

Ssokorototo Any idea why `wrangler d1 execute EmailTracker --command='SELECT * FROM SenderIn...

M

Max (@rozenmd)•6/13/23, 1:12 PM

"..."

"..."

"..."

"..." means column, or general database objects - you want

'...'

'...'

'...'

'...' for strings

Ttjenkinson hi with the `batch` api is it possible to get the results of all statements up t...

M

Matt Silverlock•6/13/23, 7:53 PM

It is not. The batch runs in an implicit transaction, so that a batch doesn’t “partially” complete and leave your database in an unexpected state.

Ttjenkinson Thanks. Could it not still return the results from earlier stages though, even i...

M

Matt Silverlock•6/13/23, 7:58 PM

That’s not how a transaction works. What if some of those earlier queries insert data? Modify the schema? Or return nothing? etc.

If you need to treat them as discrete queries, issue multiple separate queries

Ttjenkinson I think it would still be helpful to see what the output was with the understand...

M

Matt Silverlock•6/13/23, 8:22 PM

We plan to expose a transaction API, but you can’t do this right now

A

Adi•6/14/23, 1:33 AM

Some of the discussion actually reminded me of a question I have had since wrangler3/miniflare3 came out.
With those old miniflare packages (https://www.npmjs.com/package/@miniflare/d1) when in a test environment, you could write code that would simulate d1 in the following way

import { D1Database, D1DatabaseAPI } from "@miniflare/d1";
import { drizzle } from "drizzle-orm/d1";

const d1 = new D1Database(new D1DatabaseAPI(sqliteDb));
const db = drizzle(d1); // now I can can write unit tests for drizzle

import { D1Database, D1DatabaseAPI } from "@miniflare/d1";
import { drizzle } from "drizzle-orm/d1";

const d1 = new D1Database(new D1DatabaseAPI(sqliteDb));
const db = drizzle(d1); // now I can can write unit tests for drizzle

import { D1Database, D1DatabaseAPI } from "@miniflare/d1";
import { drizzle } from "drizzle-orm/d1";

const d1 = new D1Database(new D1DatabaseAPI(sqliteDb));
const db = drizzle(d1); // now I can can write unit tests for drizzle

import { D1Database, D1DatabaseAPI } from "@miniflare/d1";
import { drizzle } from "drizzle-orm/d1";

const d1 = new D1Database(new D1DatabaseAPI(sqliteDb));
const db = drizzle(d1); // now I can can write unit tests for drizzle

How can I write this with miniflare 3?

MMatt Silverlock Yes, but not > 100 at this stage. I’d like to get a better understanding of your...

J

Jason Hostetter•6/14/23, 2:53 AM

I ended up refactoring my query into two separate queries, which now seems to keep it under the depth of 20 limit. I initially had the queries combined with nested CTEs so that I could avoid two DB round-trips, but it seems like the speed of the new backend more than makes up for it. It's really fast now.

M

Matt Silverlock•6/14/23, 5:59 PM

Typically a week or two, but best to not look at commits to workerd. We'll publish in the changelog once it ships: https://developers.cloudflare.com/d1/changelog

S

Sameer Ali•6/14/23, 10:07 PM

deleting table with 1000 rows would count 1000 writes?

M

Matt Silverlock•6/15/23, 11:47 AM

Self-plug: built an authenticated HTTP API on top of D1 so you can query it from legacy/non-Workers apps: https://twitter.com/elithrar/status/1668601365860425733?s=46

Matt Silverlock 🐀 (@elithrar)

Built an example app that combines @Cloudflare D1 and @honojs to put an authenticated HTTP API in front of your database: https://t.co/6RVspFGe5V

Exposes .all(), .exec() and .batch() to any existing app: