where do you get this info from? is there some documentation on the internals which I am incapable o
where do you get this info from? is there some documentation on the internals which I am incapable of finding?
Ci'd like to read more about this technology but god I can't find anything on it
HThe Cloudflare Blog
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
NI'm gonna google more about the diff. between PostgreSQL and SQLite to understand more
HThe Cloudflare Blog
We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.
Cof course they're blog posts...
Cthank you
NI'm not sure I even understand the whole complexity involved in a business like DoorDash but if someone were to build an application with DoorDash's business model, I don't know how many but say they needed 10-15-20 tables with 7-10 columns... would D1 be able to handle that?
Cthis is built with D1: https://northwind.d1sql.com/. here is the database: https://github.com/jpwhite3/northwind-SQLite3. you can find there a graph of its schema.
MTime Travel is now available in the latest
wrangler3.4.0): https://developers.cloudflare.com/d1/learning/time-travel/Time Travel is D1’s approach to backups and point-in-time-recovery, and allows you to restore a database to any minute within the last 30 days.
Cthis is rather a question of whether SQLite can handle scale. see https://www.sqlite.org/whentouse.html, https://news.ycombinator.com/item?id=33975635.
MThat is not a lot of tables. Schema complexity isn't really a problem. Making your queries efficient - D1 or not - is what is important.
NThat schema png is exactly what I had in mind. I'll check those links out, thanks.
NI'll keep that in mind
N"To use SpatiaLite with SQLite, you need to install the SpatiaLite library and load it as an extension to SQLite."
Does D1 currently have the ability to add a library as an extension?
Does D1 currently have the ability to add a library as an extension?
BAre databases created via the dashboard on the experimental backend? Or is that just an option via the CLI? And how can you tell which backend you're using?
CIt used to be an option when creating to enable experimental, but it looks like it was changed so that they're all experimental now. A really easy way to tell is if the dashboard has "Backups" or "Time Travel" option inside of the database. If it's time travel, it's running experimental.
Also if it has the metrics tab, only experimental has that.
Also if it has the metrics tab, only experimental has that.
BThanks!
TIs 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-63ea75a981fbCSure.
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:
7ecd59bfdc728ec8, timestamps are 1690381931502 (request) and 1690381936556 (D1 error)CHappy 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?
