Cloudflare Developers•3y ago

sqlite max is ~2b i believe

Paul•11/3/23, 2:30 PM

Anyone else considering an alternative until this thing is GA? If so, is there one that would be a seamless transition?

DahoomOP•11/3/23, 2:30 PM

possibly turso

DDahoom sqlite max is ~2b i believe

itsmatteomanf•11/3/23, 2:30 PM

Practically unlimited NotLikeThis

DDahoom possibly turso

Paul•11/3/23, 2:31 PM

Any experience with it? Seems like it’s the exact same offering

Iitsmatteomanf Practically unlimited <:NotLikeThis:946950222783840256>

GuillaumeLakano•11/3/23, 2:31 PM

Good, thank you all for the feedback !

SSamuel Barros is there a way to currently query a D1 database? dashboard doesn't work and wran...

Max (@rozenmd)•11/3/23, 2:51 PM

Workers can, both dashboard and wrangler use the API

SSamuel Barros yeah, but I don't think I can deploy a new worker to make a query since the bind...

DahoomOP•11/3/23, 2:53 PM

APi is currently down/degraded

SSamuel Barros is there a way to currently query a D1 database? dashboard doesn't work and wran...

_tweak^prone•11/3/23, 2:53 PM

my wranglers get 502'ed - not timeout'ed - fun difference actually

fredddde•11/3/23, 2:54 PM

Rozen, if I bake you a chocolate cake will that speed up the fixing?

digeratidave•11/3/23, 2:58 PM

Is this where we look for D1 Dashboard updates? The DB appears to be working for our workers but we can't get to it from the dashboard. Any eta on resolution?

Ddigeratidave Is this where we look for D1 Dashboard updates? The DB appears to be working for...

digeratidave•11/3/23, 3:03 PM

came across this in downdetector.com but it doesn't list D1 https://www.cloudflarestatus.com/

Cloudflare Status

Welcome to Cloudflare's home for real-time and historical data on system performance.

Ddigeratidave came across this in downdetector.com but it doesn't list D1 https://www.cloudfla...

_tweak^prone•11/3/23, 3:04 PM

its under here:

Cloudflare dashboard: Degraded availability but accessible
API: Degraded availability but accessible

Original message was deleted

DahoomOP•11/3/23, 3:29 PM

is this meant to make the queries the same? like

dbSource.prepare('UPDATE vote_features SET vote_count_yes = vote_count_yes + 1 WHERE id = ?;', id)

dbSource.prepare('UPDATE vote_features SET vote_count_yes = vote_count_yes + 1 WHERE id = ?;', id)

can work with either

 const dbSource = new TursoDatabaseSource('your-turso-url', 'your-turso-token');

 const dbSource = new TursoDatabaseSource('your-turso-url', 'your-turso-token');

const dbSource = new D1DatabaseSource(event.platform?.env?.DB);

const dbSource = new D1DatabaseSource(event.platform?.env?.DB);

DahoomOP•11/3/23, 3:30 PM

asking because I'm horrible at typescript so its taking me a while to wrap my head around these files

DahoomOP•11/3/23, 3:35 PM

I've been dreading having to create this myself so its interesting you already have one

DahoomOP•11/3/23, 3:35 PM

I'm going to give it a try, thanks!

DahoomOP•11/3/23, 3:37 PM

this might sound stupid but I'm going to untypescriptify it first

GGuillaumeLakano What is the maximum number of tables we can create per database please? The docu...

Paul Shriner•11/3/23, 3:37 PM

QUick question, with how quick 2GB of space seems to be eaten up, are there plans to someday increase that?

PPaul Shriner QUick question, with how quick 2GB of space seems to be eaten up, are there plan...

DahoomOP•11/3/23, 3:37 PM

yeah its still in alpha

DahoomOP•11/3/23, 3:38 PM

it used to be 100MB i think, then 500MB, then 2GB

DahoomOP•11/3/23, 3:38 PM

its slowly increasing overtime

Paul Shriner•11/3/23, 3:38 PM

GOt it, so don't stress, the size right now.

PPaul Shriner QUick question, with how quick 2GB of space seems to be eaten up, are there plan...

Max (@rozenmd)•11/3/23, 3:40 PM

you also get 50k dbs (effectively limitless) x 2GB, it's significantly easier for us to encourage sharding than a single huge db

Paul Shriner•11/3/23, 3:45 PM

yeah, I think I could shard and merge result sets.

Paul Shriner•11/3/23, 3:46 PM

I could also logically seperate tables that will never, ever need to know about each other.

Max (@rozenmd)•11/3/23, 3:47 PM

we have a lot of work to do to make sharding ergonomical from a developer-experience perspective, but we can trivially support it (and it's already how DOs currently work)

MMax (@rozenmd)you also get 50k dbs (effectively limitless) x 2GB, it's significantly easier fo...

Isaac McFadyen•11/3/23, 3:57 PM

There's the account limit though, correct?

IIsaac McFadyen There's the account limit though, correct?

Matt Silverlock•11/3/23, 4:02 PM

All of those limits are marked as beta and we’ve been clear that they will increase over time, including on that very docs page.

Alexandre Custodio•11/3/23, 5:11 PM

Are there any other ways to disassociate a D1 from a Page while the Cloudflare D1 API is not working? I have a Page associated with D1, but it's not in use, and I am unable to perform a new deployment due to this error:

Error: Failed to publish your Function. Got an error: binding INFO_SESSION_D1 of type d1 failed to generate. Please try again later or contact support.

Error: Failed to publish your Function. Got an error: binding INFO_SESSION_D1 of type d1 failed to generate. Please try again later or contact support.

Paul Shriner•11/3/23, 5:44 PM

Right, I believe you could remove your D1 bindings, which for me is a PITA

PPaul Shriner Right, I believe you could remove your D1 bindings, which for me is a PITA

Alexandre Custodio•11/3/23, 6:40 PM

I could, but I can't, because it doesn't load in the Settings page

Paul•11/3/23, 6:58 PM

have there been any updates specific to D1 about restoring wrangler/API? or more importantly an ETA?

PPaul have there been any updates specific to D1 about restoring wrangler/API? or more...

Matt Silverlock•11/3/23, 7:13 PM

d1-database

we don't have an ETA yet.

Paul Shriner•11/3/23, 7:48 PM

I am still asking, are we talking hours, days or weeks?

PPaul Shriner I am still asking, are we talking hours, days or weeks?

Matt Silverlock•11/3/23, 7:52 PM

Hours, but I can't give you a more precise answer than that. Not days and certainly not weeks.

Paul Shriner - Titleless•11/3/23, 8:36 PM

Got it, thank you

Kodie Goodwin•11/3/23, 8:48 PM

Best of luck all!

Kodie Goodwin•11/3/23, 8:48 PM

Should out to all the devs and SREs jamming on this incident

_tweak^prone•11/3/23, 9:07 PM

Well, somethings happening

wrangler API endpoint for d1 went from 502 Bad Gateway502 Bad Gateway to

503 Service Unavailable

503 Service Unavailable

matt•11/3/23, 9:23 PM

When the HTTP error wraps around from 999 back to 0 then 200, we'll be back

Matt Silverlock•11/3/23, 9:34 PM

@D1 Database The D1 API is beginning to recover: operations through the REST API, including deploying projects that have D1 bindings, should begin to work again.

Kodie Goodwin•11/3/23, 9:46 PM

able to just deploy my worker w/ d1 binding

Paul Shriner•11/3/23, 10:00 PM

Same! Thanks for your hard work getting this back online!

Paul•11/3/23, 10:05 PM

woot woot! great stuff !

digeratidave•11/3/23, 10:39 PM

my D1 dashboard is working again!

kpeek0•11/4/23, 1:13 AM

Is there a plan to be able to use D1 from outside of Cloudflare? Would love to experiment with it from Fly.io

sqlite max is ~2b i believe

Similar Threads

Similar Threads

Similar Threads