Cloudflare Developers•2y ago

outside of Cloudflare Workers, you mean?

Max (@rozenmd)OP•3/28/24, 6:14 PM

there's https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

IIsaac McFadyen I don't have WebStorm downloaded right now but I remember seeing it in there too...

kian•3/28/24, 6:16 PM

WebStorm is the 1 IDE that doesn’t

JoeDoe•3/28/24, 6:25 PM

if I do this

    async scheduled(event, env, ctx) {
        ctx.waitUntil(doSomeTaskOnASchedule(env, ctx));
                ctx.waitUntil(theOtherTask(env, ctx));
    }

    async scheduled(event, env, ctx) {
        ctx.waitUntil(doSomeTaskOnASchedule(env, ctx));
                ctx.waitUntil(theOtherTask(env, ctx));
    }

JoeDoe•3/28/24, 6:25 PM

will both run in parallel?

JoeDoe•3/28/24, 6:25 PM

or only first one, until its done, then second one?

MMax (@rozenmd)outside of Cloudflare Workers, you mean?

JoeDoe•3/28/24, 6:29 PM

meaning, can I just run a javascript script, but still have access to all the d1 binding under the hood

Kkian WebStorm is the 1 IDE that doesn’t

Isaac McFadyen•3/28/24, 6:30 PM

wow, really?

Isaac McFadyen•3/28/24, 6:31 PM

That's interesting. Thanks for the info.

kian•3/28/24, 6:31 PM

It’s cheaper than the rest, the DB plugin for WebStorm specifically is paid

kian•3/28/24, 6:31 PM

:notlikemeow:

kian•3/28/24, 6:32 PM

Kkian It’s cheaper than the rest, the DB plugin for WebStorm specifically is paid

Isaac McFadyen•3/28/24, 6:32 PM

That's quite annoying TBH.

Isaac McFadyen•3/28/24, 6:32 PM

I guess it's because they assume VSCode is the main competitor for web dev and so it needs to be cheaper?

kian•3/28/24, 6:32 PM

I think PHPStorm has the same JS/TS support so all of our devs use that instead

Kkian I think PHPStorm has the same JS/TS support so all of our devs use that instead

JoeDoe•3/28/24, 6:33 PM

PhpStorm is the bomb

JJoeDoe meaning, can I just run a javascript script, but still have access to all the d1...

Max (@rozenmd)OP•3/28/24, 6:38 PM

run it where?

MMax (@rozenmd)run it where?

JoeDoe•3/28/24, 6:39 PM

locally

JJoeDoe locally

Max (@rozenmd)OP•3/28/24, 6:55 PM

as in,

wrangler dev

wrangler dev

MMax (@rozenmd)as in, `wrangler dev`?

JoeDoe•3/28/24, 7:08 PM

I guess?

Kkian WebStorm is the 1 IDE that doesn’t

Tony Leung•3/29/24, 8:25 AM

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

Kevinnn•3/29/24, 3:44 PM

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?

KKevinnn I have a question about dynamic bindings and the "Maximum bindings per Workers s...

forslunds•3/29/24, 4:13 PM

The 5.000 limit is from a filesize limit in the config file, dynamic bindings wont be affected by that

Fforslunds The 5.000 limit is from a filesize limit in the config file, dynamic bindings wo...

Kevinnn•3/29/24, 4:14 PM

Perfect. Thanks for the reply.

Kai•3/29/24, 8:43 PM

just noticed beta badge is gone, did d1 go GA?

James•3/29/24, 8:44 PM

Who knows, maybe it's a sneak peak for next week?

Chaika•3/29/24, 8:49 PM

light mode best appearance theme

Max (@rozenmd)OP•3/29/24, 9:01 PM

huge if true

James•3/29/24, 10:03 PM

maybe you're hallucinating

Kai•3/29/24, 10:08 PM

https://tenor.com/view/dog-meme-gif-25326537

Tenor

arch•3/29/24, 10:09 PM

https://tenor.com/view/obi-wan-kenobi-these-are-not-the-droids-star-wars-jedi-mind-trick-gif-23067514

Tenor

Kysan•3/29/24, 11:07 PM

is that possible to use my d1 database outside of a cloudflare worker ?

James•3/30/24, 12:41 AM

There's the API: https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

James•3/30/24, 12:41 AM

Or you could write a Worker that interfaces with your D1 database and then hit that externally

JoeDoe•3/30/24, 6:50 AM

what does this mean?

 D1_TYPE_ERROR: Type 'bigint' not supported for value '12907242804498931'

 D1_TYPE_ERROR: Type 'bigint' not supported for value '12907242804498931'

John_rand•3/30/24, 8:23 AM

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)

Is there any other option?

sabin•3/30/24, 9:05 AM

Are there any multi tenant demos with d1?

Softbear•3/30/24, 12:55 PM

Hello has anyone tested the d1 driver for datagrip ?

I can't manage to make partial selects with it

The second request returns the whole user, while the first one fails at parsing

(I'm using this driver https://github.com/isaac-mcfadyen/d1-jdbc-driver/tree/main)

Miki•3/30/24, 12:55 PM

SSoftbear Hello has anyone tested the d1 driver for datagrip ? I can't manage to make pa...

Softbear•3/30/24, 2:50 PM

Looks like a known issue, too bad it's not at all maintained
https://github.com/isaac-mcfadyen/d1-jdbc-driver/issues/3

GitHub

Select anything but * seems to fail · Issue #3 · isaac-mcfadyen/d1-...

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...

albyzyx•3/30/24, 2:56 PM

Hello, New to cloudflare ecosystem. I am looking for the right stack for my project. Is D1 stable enough to use on production?

D4nk•3/30/24, 3:46 PM

Anyone know whyt my D1 binding now only has a "Fetcher" property? I can use prepare anymore

D4nk•3/30/24, 4:05 PM

I have been at this for a day now, why is my D1 suddenly a Fetcher I have everything setup correct

shahzaibkhalid•3/30/24, 4:13 PM

Hello, does someone know if it's safe to commit database_iddatabase_id and

preview_database_id

preview_database_id

wrangler.toml

wrangler.toml

file?

Sshahzaibkhalid Hello, does someone know if it's safe to commit `database_id` and `preview_datab...

Cyb3r-Jak3•3/30/24, 4:14 PM

Yes.

Cyb3r-Jak3•3/30/24, 4:14 PM

Everything in the wrangler.toml file is safe to commit. Unless you have sensitive environment variables which you should use secrets for.

CCyb3r-Jak3 Everything in the wrangler.toml file is safe to commit. Unless you have sensitiv...

shahzaibkhalid•3/30/24, 4:15 PM

Thank you!!

Original message was deleted

Isaac McFadyen•3/30/24, 7:18 PM

Yeah I'm not really maintaining that library any more unfortunately. At the time I made it I had a lot of other things going on and couldn't really find the time and then never got back around to it.

Isaac McFadyen•3/30/24, 7:18 PM

I should probably either find the time or archive it

Isaac McFadyen•3/30/24, 7:18 PM

Thanks for the reminder.

outside of Cloudflare Workers, you mean?

Similar Threads

Similar Threads

Similar Threads