How can I share permission with another cloudflare account for D1? I gave "Workers Admin" permission

How can I share permission with another cloudflare account for D1? I gave "Workers Admin" permission to other account but it gets "Authentication error (Code: 10000)" error when click D1 page. Workers page is fine.

EEfe How can I share permission with another cloudflare account for D1? I gave "Worke...

Max (@rozenmd)•3/9/23, 9:02 AM

D1 isn't in the Workers Admin permission at the moment, it's coming very soon though

MMax (@rozenmd)D1 isn't in the Workers Admin permission at the moment, it's coming very soon th...

EfeOP•3/9/23, 9:03 AM

Do you have chance to share ETA? I got a job and client only wants to use cloudflare. Client's is not giving account access just permissions.

MMax (@rozenmd)D1 isn't in the Workers Admin permission at the moment, it's coming very soon th...

EfeOP•3/9/23, 9:07 AM

Or will administrator works?

EEfe Or will administrator works?

Max (@rozenmd)•3/9/23, 9:11 AM

Administrator will work, ETA is as soon as next deployment happens

Ffate hi to all, I am new to D1 implementation with workers. Is anyone having problems...

Max (@rozenmd)•3/9/23, 9:20 AM

are you getting an error?

Ffate i ran wrangler whoam i to check for permissions and i have d1 as write

Max (@rozenmd)•3/9/23, 9:39 AM

do you have the Workers Admin role, by any chance?

Ffate How do I check if I have the role

Max (@rozenmd)•3/9/23, 10:58 AM

in cloudflare's dash -> manage account in the bottom left corner -> click members

Max (@rozenmd)•3/9/23, 10:59 AM

if you're not the administrator of the account, that could be causing issues

Walshy•3/9/23, 12:33 PM

Yeah I'd type in your data but yeah

Max (@rozenmd)•3/9/23, 12:44 PM

if you give your d1 dbs a prefix like

D1_

D1_

, you could do something like

Object.keys(env).filter(key=>key.startsWith('D1_'))

Object.keys(env).filter(key=>key.startsWith('D1_'))

Max (@rozenmd)•3/9/23, 12:45 PM

otherwise Object.keys will give you everything on env, not just your d1 dbs

danielsundq•3/9/23, 1:50 PM

Hi! I wonder about the result object returned from from stmt.all() and .run(). Is it possible that it returns { success: false, ... } without raising an exception?

nickchomey•3/9/23, 5:34 PM

Hi there, I'm quite interested in D1, but of course find the 100mb quite lacking. Obviously that's an alpha restriction and I'm not concerned about timelines, but somewhere here it was said this is due to a technical limitation because it loads the entire SQLite DB into memory.

My question is whether that (loading into memory) might change in the future? Because, if not, it seems like D1 could only ever be for very small applications (or cost a fortune to pay for GBs or even TB of ram...).

Thanks!

Nnickchomey Hi there, I'm quite interested in D1, but of course find the 100mb quite lacking...

Max (@rozenmd)•3/9/23, 6:29 PM

we're very aware 100MB is limiting - looking at higher limits for beta

Zzszszsz `const stmt = d1.prepare('select ?1 + ?2').bind(1, 2)` throws `Too many paramete...

Max (@rozenmd)•3/9/23, 6:30 PM

does it work without the numbered params? as in just

Max (@rozenmd)•3/9/23, 6:30 PM

think there's a bug in miniflare

MMax (@rozenmd)we're very aware 100MB is limiting - looking at higher limits for beta

nickchomey•3/9/23, 6:30 PM

Yes, sorry, I'm aware that you're aware. My question is whether it will change to not load the entire db into ram, so that large dbs could be possible and affordable? If so, I'm happy to work within the alpha and beta limits. But otherwise, there's no point in me dedicating time to this if it won't be possible/affordable to use D1 in production

Nnickchomey Yes, sorry, I'm aware that you're aware. My question is whether it will change t...

Max (@rozenmd)•3/9/23, 6:32 PM

not sure yet tbh, next goal is at least a gig

nickchomey•3/9/23, 6:34 PM

Ok. I suppose I'll just keep an eye on this then. What I'm curious about is not what the limit will evolve to be, but whether it will be tied to ram (expensive and size-limited) vs ssd (cheap and unlimited in size). If there aren't currently any plans to consider moving out of ram, I can't justify testing D1

nickchomey•3/9/23, 6:35 PM

I'm sure it'll be a wonderful solution though for many smaller applications!

Zzszszsz Should I make a new issue for that

Max (@rozenmd)•3/9/23, 6:36 PM

yes please

Nnickchomey I'm sure it'll be a wonderful solution though for many smaller applications!

Max (@rozenmd)•3/9/23, 6:37 PM

for my own projects I'm thinking of an architecture where I use a d1 db to track which d1 db contains which customer's data

Max (@rozenmd)•3/9/23, 6:37 PM

as CF raises limits it'll make it more and more viable (imo)

nickchomey•3/9/23, 6:38 PM

I don't think that would work for my architecture/application. And, again, my issue is with it being stored in expensive ram - even if the architecture was split like you suggest, it would still be orders of magnitude more expensive than ssd.

How can I share permission with another cloudflare account for D1? I gave "Workers Admin" permission

Similar Threads

Similar Threads

Similar Threads