hey all — brandon here (previously from Outerbase) we just shipped a new experience for D1 including

hey all — brandon here (previously from Outerbase) we just shipped a new experience for D1 including our data studio. it's read only for now, but an editable experience is coming soon! would love to get your thoughts!
No description
16 Replies
James
James4w ago
love the new design and UX! One minor a11y comment about these: https://i.james.pub/file/2025/05/387f3575-9417-4610-a50c-c54484166e0f.png github/deploy are buttons that open new tabs so ideally should just be anchors so folks can middle click them and accessibility tooling understand what they do a little better :MeowHeartCloudflare:
Chaika
Chaika4w ago
The sorting of queries/size is only for the DBs visible on the current page you are on, which is pretty confusing oh actually, not sure if that overview is strictly part of what you shipped? hmm
Brandon
BrandonOP4w ago
Yeah we have a ticket open for this — right now the API is paginated, so sorting only applies to the current page. Hoping it's a fairly straightforward fix haha.
Successful-Arm-3762
Hi, been facing D1 network connection failure since some time now, on my production API. Error: Database error during login: Error: D1_ERROR: Network connection lost. Happens randomly.
Tim
Tim4w ago
My worker app is randomly getting errors like D1_ERROR: D1 DB storage operation exceeded timeout which caused object to be reset.. The Cloudflare dashboard page for the worker shows 0 errors. However, I know this is happening, and have evidence in Sentry reporting.
James
James4w ago
It's generally recommended to build retries into your app for those kind of errors. Hopefully we'll see some official guidance soon for https://github.com/cloudflare/cloudflare-docs/issues/18485
가브리엘 | Verzach3
Hi all, im creating an app with workers and D1, whats the recommended way to create a multitenant app with D1, how i can create and assign database dynamically to workers?
Silvan
Silvan4w ago
the current easiest solution is to use durable objects instead
Unknown User
Unknown User4w ago
Message Not Public
Sign In & Join Server To View
Successful-Arm-3762
D1 doesn't support transactions, but SQLite through Durable objects do. I'm still using D1, not sure how difficult would the transition be, but I will soon be making that change or shift to a proper postgresql service D1 batches do support transactions!
gruntlord6
gruntlord64w ago
Cloudflare Docs
D1 Database
To interact with your D1 database from your Worker, you need to access it through the environment bindings provided to the Worker (env).
Mirith
Mirith4w ago
I have what I think is going to be an obvious question, but I can't figure out how to properly look up the answer. I have a database (Surprise!) connected to a worker that I'm accessing on the worker. Locally everything works fine. However, when I deploy it to remote, I can insert new rows into my database, but I don't seem to be able to update them. I don't seem to be getting any errors, but I'm also wondering since I'm using a web socket to transmit some of that data involved if that is getting hidden in my logs. Is there a way to just look at the console.log output remotely? Actually, I think the error might be something else
gruntlord6
gruntlord64w ago
the worker is transmitting the d1 operation by web socket?
Mirith
Mirith4w ago
No. The problem involves the websocket but the operation is just not getting called
Chaika
Chaika4w ago
wrangler tail https://developers.cloudflare.com/workers/observability/logs/real-time-logs/ but you'll only see logs when the websocket ends
Successful-Arm-3762
ooh, thanks for letting me know! this is helpful! I thought batch just reduces round trips, good to know!

Did you find this page helpful?