that's weird to have only one IDE which does not have a database tool bundled when all others having it. Btw I think all jetbrains IDE is just intelliJ in disguise. I used to code ActionScript on IntelliJ for years until I couldn't beating a dead horse for a dying startup anymore
I have a question about dynamic bindings and the "Maximum bindings per Workers script" limit described here: https://developers.cloudflare.com/d1/platform/limits/ When dynamic bindings are introduced, will it be possible to bind more than 5,000 D1 databases to a single worker script? Or, will this limit still apply?
Hi folks, I was wondering how people deal with D1 not supporting transactions on the client side when an insert of a child table needs to have the id of the parent (ie insert parent, insert many children with parent_id, or rollback)
I am thinking of 2 options: Have an "is_orphan" column on the parent, commit, insert children and set false in a batch, and have a cleanup process scheduled for is_orphan = true.
Or have a separate "sequence" table, where the first commit monotonically increments, and then insert parent with id provided, insert children in a batch. That way though ids could exhaust if there is a bug on the client (ie getting new ids, crashing in batch)
where mytable has a primary key of mykey the follow queries error: select distinct field from mytable select field from mytable They succeed in the CF D1 console. I tested 3 different tools, just t...