Cloudflare Developers•3y ago

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

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

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

yeah its still in alpha

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

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

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

its slowly increasing overtime

Paul ShrinerOP•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 ShrinerOP•11/3/23, 3:45 PM

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

Paul ShrinerOP•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 ShrinerOP•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 ShrinerOP•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 Gateway

502 Bad Gateway

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

justaname•11/4/23, 3:19 AM

Is there a reason it says i have 1 table but cant see that table?

Jjustaname Is there a reason it says i have 1 table but cant see that table?

forslunds•11/4/23, 9:31 AM

Maybe the migration table?

Jjustaname Is there a reason it says i have 1 table but cant see that table?

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

what does /tables output in the console?

bkyerv•11/4/23, 12:53 PM

what are some good patterns to handle error when query (e.g. select query using prepare method) fails? not when query returns empty object/result but when it fails for any reason

Epailes•11/4/23, 1:44 PM

Has there been any talk/suggestions around a graphql interface in front of d1?

EEpailes Has there been any talk/suggestions around a graphql interface in front of d1?

Cyb3r-Jak3•11/4/23, 1:49 PM

Like query via graphql or metrics via graphql?

CCyb3r-Jak3 Like query via graphql or metrics via graphql?

Epailes•11/4/23, 1:50 PM

Query d1 instance via graphql, sorry should have been more specific I know there's a graphql interface for the metrics

EEpailes Query d1 instance via graphql, sorry should have been more specific I know there...

Cyb3r-Jak3•11/4/23, 1:50 PM

My guess is probably not as that is something would be easier to implement via a worker

Epailes•11/4/23, 1:52 PM

I assumed there probably wouldn't be, but it'd be an amazing QOL feature if it were feasible

MMax (@rozenmd)what does /tables output in the console?

justaname•11/4/23, 6:23 PM

/tables

name
d1_migrations
sqlite_sequence
user

So it seems like it is the d1 migrations table. still odd to me that there is so many different actual number of tables right now it says there are 2 tables shows 1 table in tables tab and shows 3 tables in console.

addison•11/5/23, 3:21 AM

how easy would it be to access a D1 database from outside of cloudflare pages & workers?

i need to build something that i cannot run on workers or pages, but all the data i would need would be on cf d1. other than using the api is there any other way?

Aaddison how easy would it be to access a D1 database from outside of cloudflare pages & ...

Cyb3r-Jak3•11/5/23, 3:27 AM

There isn’t.

Aaddison how easy would it be to access a D1 database from outside of cloudflare pages & ...

kev-ac•11/5/23, 12:56 PM

Depends on what you need to do with the data you could create a worker that interacts with the DB for you. But keep the overall overhead of this in mind.

Aaddison how easy would it be to access a D1 database from outside of cloudflare pages & ...

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

https://github.com/elithrar/http-api-d1-example

GitHub

GitHub - elithrar/http-api-d1-example: An example HTTP API for Clou...

An example HTTP API for Cloudflare's D1 database: https://developers.cloudflare.com/d1/

GitHub - elithrar/http-api-d1-example: An example HTTP API for Cloudflare's D1 database: ht...

roftt•11/5/23, 4:37 PM

Is it possible for "json_extract" to search for all values, regardless of letter casing?

다

다미•11/5/23, 5:29 PM

Does d1 support ST_Distance_Sphere?

_tweak^prone•11/5/23, 5:50 PM

Does

wrangler dev

wrangler dev

connect to my external Cloudflare D1 if i specify it in the wrangler.toml by merely doing:

[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "(my db name)"
database_id = "(my db id)"

[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "(my db name)"
database_id = "(my db id)"

I would like to work on my "live" D1 database, on local dev.

Dahoom•11/5/23, 5:51 PM

you could try the remote dev feature

Dahoom•11/5/23, 5:51 PM

i never tried it myself but it MIGHT possibly have that as a feature

Dahoom•11/5/23, 5:52 PM

otherwise I would recommend turso for connecting to a live db while in local dev

DDahoom otherwise I would recommend turso for connecting to a live db while in local dev

_tweak^prone•11/5/23, 5:57 PM

turso ?

Dahoom•11/5/23, 5:57 PM

https://turso.tech

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

Similar Threads