Any updates on if D1 will get jurisdictional restrictions? https://community.cloudflare.com/t/d1-loc
Any updates on if D1 will get jurisdictional restrictions? https://community.cloudflare.com/t/d1-location-hints-explanation-and-improvement/634791
JIs there any montioring of what queries are reading the most rows? 
MIs there a way to set upper limits on how many read/write rows per operation?
EIssues on d1 continue. New issues also coming: Cant read from request stream after response has been sent.
Internal error while starting up D1 DB storage caused object to be reset.
Network connection lost.
Etc…
Its been a month now that we receive this issues constantly .
Internal error while starting up D1 DB storage caused object to be reset.
Network connection lost.
Etc…
Its been a month now that we receive this issues constantly .
- Cant read from request stream after response has been sent.* started yesterday, and it correlates with the time that the latency issue was identified : https://www.cloudflarestatus.com/incidents/919j0tc3dmmd
MWhat's your databaseId?
Mand you haven't redeployed your Worker since yesterday?
ENo, we have stopped pushes for 3 weeks now to keep this issue tracked, so we don’t get sidetracked on where the issue is coming from
MI ask because
Cant read from request stream after response has been sent is typically a Worker issueENo pushes
EAlso errors like max size reached are coming in..
VYes, we're planning for H1 2025
FRare ETA detected 
BDo you only pay for the database round trip cost once with
.batch, rather than for every statement in the batch?
E:pOg:
VYou pay for rows read/written not how many calls, statements or batching.
https://developers.cloudflare.com/d1/platform/pricing/
https://developers.cloudflare.com/d1/platform/pricing/
Mthink they meant pay in the network-round trip cost sense
VAh performance wise, yea, batching better (although the downside of
params)BWhat's the downside with
params?VIf you're using the workers API for D1 batch, you're fine. But if you the HTTP API for D1 batch, you can't add
params (as the separate json field)BAh got it.
BIf
stmt. and db. methods can throw, what's the purpose of D1Result.success? Would it ever be false
LHie there I am using Cloudflare D1 for a project and i noticed the latency is really high around 800 to 900 ms.
resulting in overall high latency in api calls. The DB is deployed in APAC region and the worker is in colo=DEL.
Any insights on why this could be Happening?
Thanks
resulting in overall high latency in api calls. The DB is deployed in APAC region and the worker is in colo=DEL.
Any insights on why this could be Happening?
Thanks
Mthink we just used the types from the HTTP API here
BDoes that mean I can just assume
successtruewithin the Worker, yep
BGot it, probably a good idea to have it documented though.
JThey have very different use-cases. That benchmark is a bit out of date with https://blog.cloudflare.com/faster-workers-kv/ now, and KV getting even faster, but it’s going to really depend on your application.
Lots of write-once read-often key-value data? KV makes a tonne of sense. Lots of deep relational data, D1 makes more sense.
Lots of write-once read-often key-value data? KV makes a tonne of sense. Lots of deep relational data, D1 makes more sense.
JIf you can describe your app and the kinds of data/queries you’ll be doing, we can probably provide better recommendations 
JIt’s also pretty common for apps on Cloudflare to use both, as well as R2, etc, again just depending on the kind of data you’re storing and how you need to access it.
CD1 perf is going to be hard to measure as its a single durable object/instance running in a single region where KV is two central stores (US, EU) + heavy caching in front
NHi all. I am really often getting
{"D1_RESET_DO":true} error when trying to import db using https://developers.cloudflare.com/api/operations/cloudflare-d1-import-databaseNany insights into what could be going on?
Mno - the bookmarks time travel uses are like pointers rather than actual copies of the DB, makes it hard to do stuff like that
i initially wanted to build a Time Machine style UI for it, but it wouldn't work
i initially wanted to build a Time Machine style UI for it, but it wouldn't work
Mthat's a pretty bad error on our part, if i had to guess it's hitting an error and rolling back, does it work if you call the /query API with the sql text directly?
N@Max (@rozenmd) problem is that this DB is giving error all the time
Nno matter what I do, and wait for how long
Dsame here
DError: D1_ERROR: Invalid primary location hint provided
Osame here, all services using D1 are down
D
rip d1Oback up it seems
Dyep, getting results from my dbs now
Msame here, got good a few minutes ago
DLooks like it’s resolved now, but I’ll see if we can get a retro statuspage for this
VIs Cloudflare team playing with our production databases in the backend
Dsee above
VI think the D1 was out of beta few months back, still these issues regularly.
