Got it. Account ID would be great too. I don't see any immediate logs for `e707d84e-7dd9-4c4b-940a-6
Got it. Account ID would be great too. I don't see any immediate logs for
e707d84e-7dd9-4c4b-940a-63ea75a981fb
CSure.
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?
C
Cthank 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 which will also be auto incrementing. We haven’t yet published docs on this, but this applies: https://www.sqlite.org/rowidtable.html
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
MManually, yes. Take a backup, import it into a new DB. https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally
D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …
CI believe there is no planned auto migration.
The new backend will no longer have backups and only time travel
The new backend will no longer have backups and only time travel
CMy guess is you missed the converting step https://developers.cloudflare.com/d1/learning/importing-data/#converting-sqlite-database-files
MNot at the moment. Prioritizing larger DBs, performance, and bringing branching & cloning to Time Travel first.
SFirst one is the most exciting and much needed! Larger DBs!
Bquestion on the "larger databases" part, is the plan to (eventually) to support large databases of 100GB - 500GB?
UU(also scroll down a bit for the talk about adding some form of way for you to shard a db)
Bthx, sharding would be completely reasonable of course
Λis it possible to get a dump of D1 (alpha) database?
Λcould you point me how? i couldn't find anything helpful