Cloudflare Developers•2y ago

idk if I'm doing it wrong, but the most popular plugin on intellij didn't work for me

JJoeDoe idk if I'm doing it wrong, but the most popular plugin on intellij didn't work f...

Isaac McFadyen•3/28/24, 5:52 PM

It shouldn't be a plugin.

Isaac McFadyen•3/28/24, 5:53 PM

It should be built-in to the IDE itself.

JoeDoeOP•3/28/24, 5:53 PM

webstorm, not ultimate

Isaac McFadyen•3/28/24, 5:53 PM

For example, in RustRover it's the little Database icon.

JJoeDoe webstorm, not ultimate

Isaac McFadyen•3/28/24, 5:53 PM

Yeah. All IDEs have it I think

Isaac McFadyen•3/28/24, 5:53 PM

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

Isaac McFadyen•3/28/24, 5:53 PM

It might be a hidden button that you need to find in the More tool windows section.

JoeDoeOP•3/28/24, 5:54 PM

its ok

JoeDoeOP•3/28/24, 5:54 PM

Ill manage for now

JoeDoeOP•3/28/24, 6:10 PM

Is there a way to run a script that will still have access/context of the cloudflare bindings

JoeDoeOP•3/28/24, 6:11 PM

because right now, the only way I can see to do this is to trigger the exection via fetch()

JJoeDoe Is there a way to run a script that will still have access/context of the cloudf...

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

outside of Cloudflare Workers, you mean?

Max (@rozenmd)•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

JoeDoeOP•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));
    }

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

will both run in parallel?

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

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

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

JoeDoeOP•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

JoeDoeOP•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)•3/28/24, 6:38 PM

run it where?

MMax (@rozenmd)run it where?

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

locally

JJoeDoe locally

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

as in,

wrangler dev

wrangler dev

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

JoeDoeOP•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)•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

JoeDoeOP•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)

idk if I'm doing it wrong, but the most popular plugin on intellij didn't work for me

Similar Threads

Similar Threads

Similar Threads