@Matt my D1 db seems to have vanished... `546787dd-35d5-4822-9b50-36fa0a4310c2` <:NotLikeThis:946950
@Matt my D1 db seems to have vanished... 
546787dd-35d5-4822-9b50-36fa0a4310c2 
MAccount ID please
MAnd does vanished mean: "it doesn't respond to queries", "it doesn't show up in the API", or something else?
I275fcefacfae5b20fe129cbac8269aa4IFailed to reach database. Please try again later.
IBoth UI and Workers (which returns
D1_ERROR: internal error)MOK, so not "disappeared" - somehow stuck (still bad, but very different concern). Let us take a look.
IThank you... it was growing in size, but shouldn't have hit the 2GB limit, at all. It seem to have started failing yesterday, like ~30 hrs ago.
MLast I can see is 789MB
IYeah, aligns with what I expected, yes.
MOK. Looking into why.
IMostly in one single table.
IThank you 
Nany recommendation on how to visualize my d1 database locally? in preference something completely open source and simplistic. Thanks!
MShould be fixed now.
ILooks like it is! Thank you
IAny insights on what happened, that you are willing to share? 
MNot yet. We restored and are still working on the root cause.
Sd1 supports how many data type? when I create the table there is even no varchar, only text.
CIt should be all sqlite data types which are NULL, INTEGER, READ, TEXT and BLOB
Sso d1 is sqlite?
CYes
Sthanks
SI have a large complex MySQL application (like erp), is it smart to migrate to D1?
CHow are you connecting to the MySQL DB? There isn't a connection string that you can use to connect to a D1 DB externally, done through a worker or HTTP
SI originally plan to use PHP+MySQL. If I migrate MySQL to D1 then I have to migrate PHP to Worker.
Stested. D1 performance is not good.
HAre you using the API? That is usually much slower
Syes, I am using Page Functions to insert data into D1
HThere, the performance also depends on how close/far away the DB is
SYou will never get faster than on-prem perf with a remote DB
SIf DB perf is a requirement, you might want to look into on-prem. As far as I'm aware, D1 offers easy scalability (due to CF having 200 trillion servers, real number btw)
Rhi ummm, I couldn't find current D1 limitation article? could anyone mind to share it
Roh, there is pinned message
RI see then, let me stay with MongoDB Atlas
IIs there a way to see per table sizes (and even index, possibly) in D1?
II know
dbstat
HI would note that D1 can(once replication goes live) theoretically be faster than on-prem if you still use Workers. As in, you would have to have/managed many DBs to be able to match the scale/locations of D1
SAh yes, I was speaking from the perspective of him using php remote to D1
SWe fully transitioned from mongodb to d1 yesterday and it's plenty fast! The python script that runs on our server updates the DB while our pages functions act as the client which return the results on our api. Considering that many requests happen every minute which receive the same output how could we cache the response for example one minute in order to not burn row reads?
CUse the cache API to cache responses. The function will still run but will reduce usage of D1
JHey all, I'm new here. I'm noticing really slow performance using D1 (cold and hot runs) in other countries like Germany and Australia. I'm getting ~1200ms on cold starts and ~700ms on hot. Is this normal for the beta?
IWhere is the D1 located? Or better yet, where have you created it from?
ITrue, I assumed the current beta database version, but yeah…
JTo clarify, my queries were just for reads.
Most recent version, I think? Just created the D1 on Oct 1st and testing with a deployment made yesterday. I think it was in us-east.. but not sure where to check the region.
Most recent version, I think? Just created the D1 on Oct 1st and testing with a deployment made yesterday. I think it was in us-east.. but not sure where to check the region.
IIt is the closest location, in which D1 is supported, from the location you hit when you create it. So if you are in us-east, it would have been created in and around there.
ISo a 700ms latency, with the ocean crossing might make sense, even though it seems a bit high. How did you fetch it? Via a Worker?
IYou should see actual database execution times in the query response json (under meta)
JIt's via a worker. I'll have to check the meta. Should I expect their to be any regional or edge caching with D1 in the beta? In latency testing in US-Mich, Germany, NL, and Australia, I haven't seen faster latency than a singe region RDS micro instance.
IThere will be read-replicas, but an ETA is currently unknown. You can do your own caching in the worker via the cache api
JAh, got it that makes sense for now. I'd make a note in the d1 docs to mention this as a workaround, as it wasn't clear to me if I was going to roll out an app.
