Cloudflare Developers•3y ago

I guess "queries" here mean those all-important billable units, not queries, hopefully?

Chaika•6/12/23, 3:15 PM

they're already in the dash as well

Chaika•6/12/23, 3:15 PM

pretty sure those are just raw queries and not billable units

John SpurlockOP•6/12/23, 3:15 PM

ah hmm

Chaika•6/12/23, 3:16 PM

found this after: https://discord.com/channels/595317990191398933/1022981666744061972/1116806120380575834

Chaika•6/12/23, 3:39 PM

Hey,

Are you using the new experimental backend?
Also, D1 works on Durable Objects (which are currently having issues as well), which also means that they only run where Durable Objects are & the D1 Database you created may be far away from your location. Read Replicas and such currently are planned but do not yet exist
From the dash, you can create a D1 Database with a specific locationhint using the new experimental backend. I believe there is still no DO support at all in South America/Africa, so those locations are just always going to get higher latency. Otherwise, specifying a locationhint for your region may help, as well as using the experimental backend.
For more information on the experimental backend: https://blog.cloudflare.com/d1-turning-it-up-to-11/

JJohn Spurlock I guess "queries" here mean those all-important billable units, not queries, hop...

Max (@rozenmd)•6/12/23, 4:00 PM

yeah just read/write query counts for now

Rex•6/12/23, 4:26 PM

Unique Constrained Failed returns success: truesuccess: true on UPDATE sadkurz

is that on purpose?

Unsmart•6/12/23, 4:27 PM

It successfully failed stonks

Unsmart•6/12/23, 4:28 PM

(no clue if thats intended)

Rex•6/12/23, 4:28 PM

its supposed to throw an error back to me like it does on INSERT, i wrote such a cute handler for all of that sadkurz

JJohn Spurlock I guess "queries" here mean those all-important billable units, not queries, hop...

Matt Silverlock•6/12/23, 4:31 PM

These are just query counts. Units are a WIP - counting queries is "easy". We didn't want to hold back analytics — read/write unit analytics won't ship this month at all.

RRex Unique Constrained Failed returns `success: true` on UPDATE <:sadkurz:8955883535...

Matt Silverlock•6/12/23, 4:32 PM

This is a holdover from the v4 API response format we use at Cloudflare. We don't really need to return this for D1.

GG Caching queries to d1: am I right in thinking you just make a request to d1, get...

Matt Silverlock•6/12/23, 4:54 PM

That would work right now, yes — that's how you can use the Cache API for anything, not just D1.

MMatt Silverlock This is a holdover from the v4 API response format we use at Cloudflare. We don'...

Rex•6/12/23, 4:58 PM

so it will stay that way? its not the world ofc, i can work around it easily, just wanting to know

GG Thanks. Do you know of any plans that will streamline this? Or even somehow usin...

Matt Silverlock•6/12/23, 4:58 PM

On the roadmap. Not soon. LOTS of work to do first

RRex so it will stay that way? its not the world ofc, i can work around it easily, ju...

Matt Silverlock•6/12/23, 4:59 PM

TBD.

Rex•6/12/23, 4:59 PM

im confused on what that means

sorry

RRex im confused on what that means 😅 sorry

Matt Silverlock•6/12/23, 4:59 PM

"To be determined" - aka, I can't give you an answer either way right now (vs. just ignoring you)

Rex•6/12/23, 4:59 PM

ouh i see, thanks for your help

GG D1 speed: appreciate this is in alpha, but does anyone know of any speed compari...

Matt Silverlock•6/12/23, 7:35 PM

It really depends on your access patterns. If you are trying to read the same KV pair repeatedly, in the same location, KV is likely going to be faster. The trade-off is that (naturally) you need to fit into a KV-type data model.

Dahoom•6/13/23, 7:45 AM

Hello, is there a newer d1 api? Im trying to access my d1 db from my sveltekit cloudflare pages project but the only api i can find seems to be a little dated? https://www.npmjs.com/package/@cloudflare/d1?activeTab=readme

npm

@cloudflare/d1

The D1 Client API supports:. Latest version: 1.4.1, last published: a year ago. Start using @cloudflare/d1 in your project by running

npm i @cloudflare/d1

npm i @cloudflare/d1

. There are no other projects in the npm registry using @cloudflare/d1.

DDahoom Hello, is there a newer d1 api? Im trying to access my d1 db from my sveltekit c...

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

IIRC, that package existed before the D1 shim was added directly to

wrangler

wrangler

, so you shouldn't need to install it for it to work

Dahoom•6/13/23, 7:48 AM

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?

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

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;");
    // ...
  }
}

Dahoom•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

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

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;");
  // ...
};

Dahoom•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"

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 ...

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

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

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

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?

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 ...

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

d1-database

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

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

Thanks was to lazy to search the threads.

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";'

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';"

passes

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

I just changed it from

"--"

"--"

'--'

'--'

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

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...

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...

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...

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

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

I guess "queries" here mean those all-important billable units, not queries, hopefully?

Similar Threads

Similar Threads

Similar Threads