`ALTER TABLE` works! <a:party_yay:820426146024914955> 🎉

ALTER TABLE

ALTER TABLE

works!

itsmatteomanfOP•6/10/23, 10:52 PM

But is DROP COLUMNDROP COLUMN supported? It's giving me a not authorized...

kian•6/10/23, 10:54 PM

Seems like it should be

itsmatteomanfOP•6/10/23, 11:03 PM

I tried both, and they both returned a "not authorized".

ALTER TABLE <table> DROP COLUMN <column>;
ALTER TABLE <table> DROP <column>;

ALTER TABLE <table> DROP COLUMN <column>;
ALTER TABLE <table> DROP <column>;

Iitsmatteomanf `ALTER TABLE` works! <a:party_yay:820426146024914955> 🎉

Matt Silverlock•6/11/23, 1:18 AM

It hasn’t shipped yet.

Kkian Seems like it should be

Matt Silverlock•6/11/23, 1:18 AM

Source != deployed.

MMatt Silverlock It hasn’t shipped yet.

itsmatteomanfOP•6/11/23, 1:39 AM

Ohhh, so some sections of

ALTER TABLE

ALTER TABLE

did work already

I assumed it was fully blocked. Will wait

Garrett•6/12/23, 3:38 AM

What's the state of D1 these days? Guessing not feature/API stable and unsuitable for production use? Any ETAs on it?

GGarrett What's the state of D1 these days? Guessing not feature/API stable and unsuitabl...

Max (@rozenmd)•6/12/23, 8:37 AM

https://blog.cloudflare.com/d1-turning-it-up-to-11/

The Cloudflare Blog

D1: We turned it up to 11

We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.

Mozzy•6/12/23, 2:30 PM

Have gotten 37 "Error: Network connection lost." errors starting today 15:30 CEST
ID:

e68dccd4-7bf7-4860-ba18-17978966ec10

e68dccd4-7bf7-4860-ba18-17978966ec10

Mozzy•6/12/23, 2:31 PM

Unsmart•6/12/23, 2:33 PM

Theres an issue with durable objects at the moment:
https://www.cloudflarestatus.com/incidents/z4lmb920dm09

Cloudflare R2 Availability Issues

Unsmart•6/12/23, 2:33 PM

(ignore the title only saying R2

)

Mozzy•6/12/23, 2:33 PM

Ahh, okay. Thanks

John Spurlock•6/12/23, 3:13 PM

looks like the announced graphql datasets for D1 have started to ship! https://twitter.com/johnspurlock/status/1668273301901148164

John Spurlock (@johnspurlock)

Undocumented changes in the @Cloudflare GraphQL Analytics API, Jun 12:

new d1AnalyticsAdaptiveGroups dataset to report on D1 database query times/sizes, available to all plans!

https://t.co/7uzx83Coo6

Twitter

•

6/12/23, 3:05 PM

John Spurlock•6/12/23, 3:14 PM

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 Spurlock•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: true

success: true

on UPDATE

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

`ALTER TABLE` works! <a:party_yay:820426146024914955> 🎉

Similar Threads

Similar Threads

Similar Threads