some plugin

T

Tony Leung•3/28/24, 5:19 PM

IntelliJ or any Jetbrains IDE has database plugin bundled

T

Tony Leung•3/28/24, 5:20 PM

it's a mini version of datagrip

JJoeDoe some plugin

T

Tony Leung•3/28/24, 5:21 PM

Here, if you use intelliJ ultimate then it's bundled
https://www.jetbrains.com/help/idea/relational-databases.html#first-steps

J

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

The Database Tools and SQL plugin is available only in IntelliJ IDEA Ultimate.

The Database Tools and SQL plugin is available only in IntelliJ IDEA Ultimate.

J

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

T

Tony Leung•3/28/24, 5:22 PM

you could use dbeaver, it's opensource

J

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

there some plugins Ill try

MMatt Silverlock What does “not work” mean - it does nothing? Errors?

T

Tony Leung•3/28/24, 5:28 PM

is there any better solution rather than creating a temp table to hold my data since I'm having multiple tables referencing table B and they holds a lot of records. I've tried another solution as mentioned in: https://github.com/launchbadge/sqlx/issues/2085#issuecomment-1499859906 but it raises an error like this:

✘ [ERROR] Wrangler could not process the provided SQL file, as it contains several transactions.

  D1 runs your SQL in a transaction for you.
  Please export an SQL file from your SQLite database and try again.

✘ [ERROR] Wrangler could not process the provided SQL file, as it contains several transactions.

  D1 runs your SQL in a transaction for you.
  Please export an SQL file from your SQLite database and try again.

✘ [ERROR] Wrangler could not process the provided SQL file, as it contains several transactions.

  D1 runs your SQL in a transaction for you.
  Please export an SQL file from your SQLite database and try again.

✘ [ERROR] Wrangler could not process the provided SQL file, as it contains several transactions.

  D1 runs your SQL in a transaction for you.
  Please export an SQL file from your SQLite database and try again.

JJoeDoe ```The Database Tools and SQL plugin is available only in IntelliJ IDEA Ultimate...

I

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

This is quite incorrect, I can confirm that the bundled SQLite plugin is available in all Jetbrains IDEs. Not sure why they have this listed in their docs.

IIsaac McFadyen This is quite incorrect, I can confirm that the bundled SQLite plugin is availab...

T

Tony Leung•3/28/24, 5:33 PM

that misleading line is noted in IntelliJ document.

TTony Leung that misleading line is noted in IntelliJ document.

I

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

Yeah I know. I'm unsure why it's noted in there.

I

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

The Datagrip integration is available in all IDEs so not sure why they noted it.

I

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

Maybe it's for a more advanced version? As far as I know they're all identical though...

IIsaac McFadyen Yeah I know. I'm unsure why it's noted in there.

T

Tony Leung•3/28/24, 5:36 PM

to boost intelliJ selling I guess? A sql console is more than enough for casual use to me. Maybe the more advanced database like dynamo, snowflake is not supported?

I

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

Possibly? Unsure.

M

Max (@rozenmd)•3/28/24, 5:44 PM

Early release, but if you want to try an unoptimized

wrangler d1 export

wrangler d1 export

: https://github.com/cloudflare/workers-sdk/pull/5425

J

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

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

I

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

It shouldn't be a plugin.

I

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

It should be built-in to the IDE itself.

J

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

webstorm, not ultimate

I

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

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

JJoeDoe webstorm, not ultimate

I

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

Yeah. All IDEs have it I think

I

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

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

I

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.

J

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

its ok

J

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

Ill manage for now

J

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

J

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

M

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

outside of Cloudflare Workers, you mean?

M

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

K

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

WebStorm is the 1 IDE that doesn’t

J

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

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

J

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

will both run in parallel?

J

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?

J

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

I

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

wow, really?

I

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

That's interesting. Thanks for the info.

K

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

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

K

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

:notlikemeow:

K

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

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

I

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

That's quite annoying TBH.

I

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?

K

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

J

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

M

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

run it where?

MMax (@rozenmd)run it where?

J

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

locally

JJoeDoe locally

M

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

as in,

wrangler dev

wrangler dev

?

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

J

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

I guess?

Kkian WebStorm is the 1 IDE that doesn’t

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

K

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?

Similar Threads

Similar Threads

Similar Threads