Is there any way to share/access a D1 Database from multiple CF accounts, from different workers or
Is there any way to share/access a D1 Database from multiple CF accounts, from different workers or pages from different accounts?
CThere is not. Resources like KV, R2, D1 are all scoped by account so you can only share between workers of the same account
TConfirmation of what I was afraid... Thank you for the answer
MD1 Dashboard seems to have trouble with BLOB columns, it appears to take the column's representation as a Uint8Array and concatenate all of the decimal values therein, resulting in this to represent a column containing
(please forgive my horrendous screenshot skills)
[248, 15, 244, 44, 190, 134, 199, 60, 153, 194, 10, 101, 112, 55, 185, 241]:(please forgive my horrendous screenshot skills)
Mthe native
sqlite3 utility isn't any better (it just obliterates your terminal with binary data), so I don't have much of a suggestion, other than the behavior should probably have a length limit. Perhaps anything 32 bytes and fewer could be shown in a hex representation, and anything bigger should just show a <Binary Data> placeholder
Myeah tbh it's a long standing bug, I wasn't really sure how folks would want binary data represented
Myeah it's tricky
Mmaybe a placeholder, and when you click on it, it brings up a hexdump?
II am seeing two error messages for what seems to be same error, any specific reason for the difference?
I
IIt's most likely 2 different tables being referenced here, but would expect the same error message.
MDo you mean the duplicates (each of) "Foreign key mismatch - X referencing Y" twice, and "FOREIGN KEY constraint failed" twice?
MYes, for now. 
IWait, your message made me read those errors again… they are not the same thing. I don’t know why I read the one on top as another way to write a constraint violation. But it’s not.
INot exactly sure what changed, it worked perfectly until a couple days back…
MForeign keys are now enforced. Docs soon.
IOhhh, so I had some violations somewhere, apparently, which I didn't realize. That's gonna be fun 
II'm gonna need to do some countings and checking 
ICan we get the analytics stats on the top-right of the D1 page to be formatted as the others are? I get those are precise, but if I 1M queries, I don't really care abot single digit changes
Chey y'all - we're experiencing intermittent
D1_ERROR: Network connection lost's in our Workers hitting D1.- New storage backend
- Seems to be intermittent + random, there's no one query w/ 100% failure rate or anything - just scattered.
- This is a higher-volume (I believe, compared to typical workloads) D1 DB, serving >50 queries/s
Coriginally submitted a support ticket but was redirected here to chat with y'all
MWhat is the result set size / how many rows x bytes wide are you trying to return? Do you a database ID?
CSure, e707d84e-7dd9-4c4b-940a-63ea75a981fb is the ID. I’m on my phone right now so can’t be precise w/ result set size, but it’s definitely no more than 100 rows each being at most 512 bytes
MGot it. Account ID would be great too. I don't see any immediate logs for
e707d84e-7dd9-4c4b-940a-63ea75a981fbSure.
Account ID:
DB ID:
And some extras: Ray ID of a failed request:
Account ID:
cfd355bcff7e6af6838743ae944184b0DB ID:
e707d84e-7dd9-4c4b-940a-63ea75a981fbAnd some extras: Ray ID of a failed request:
7ecd59bfdc728ec816903819315021690381936556Happy to add you on Discord + provide exact queries/source code if it'd help too 
BReferencing this blog post (https://blog.cloudflare.com/whats-new-with-d1/), wondering about the plans for implementing procedures. I saw some references that this isn't in development/available (https://discord.com/channels/595317990191398933/789155108529111069/1104131881194246334).
Discord
Discord is the easiest way to communicate over voice, video, and text. Chat, hang out, and stay close with your friends and communities.
Cdoes d1 support foreign keys?
CCthank you
Cwhat about auto increment? is that supported or do I just have to use random uuids?
HHey guys. Im wondering when transactions will be supported on D1. Would love to be able to simplify database integrity maintenance
MBy default there is an automatic rowid column. You can also specify your own
col_name INT PRIMARY KEY
MDo you mean JS transactions? We don’t have an ETA we can share.
HI’m a little confused. I thought transactions were not supported at all. Does this mean I can write transactions in SQL and they would work fine? For example if i’m using an orm that generates SQL of the transaction and executes it against D1, will that work normally?
MAll queries are in an implicit transaction for D1.
MSome folks want a separate, callback-driven JS API that allows you to combine SQL + JS —> that part is further out.
HGotcha
Jis there a graphical way of working with D1?
CThere is a console with dashboard
Jhmmm
Jtrying to find the easiest way to manage like 1,000,000 rows
CManage how? Like query them?
Jlike configure / edit
CProbabaly the console in the dasboard
Jcurrently managin my database via google sheets, exporting to csv then importing into my sql database lol
Jits a nightmare
