I've tried bracketing with `PRAGMA defer_foreign_keys = ON`/`PRAGMA defer_foreign_keys = OFF` but it

I've tried bracketing with

PRAGMA defer_foreign_keys = ON

PRAGMA defer_foreign_keys = ON

PRAGMA defer_foreign_keys = OFF

PRAGMA defer_foreign_keys = OFF

but it does not work either...

Tony LeungOP•3/28/24, 5:08 PM

do i still need PRAGMA foreign_keys = OFF;?

TTony Leung I've tried bracketing with `PRAGMA defer_foreign_keys = ON`/`PRAGMA defer_foreig...

Matt Silverlock•3/28/24, 5:08 PM

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

Tony LeungOP•3/28/24, 5:10 PM

I'm sorry, I mean after bracketing the migration with

PRAGMA defer_foreign_keys

PRAGMA defer_foreign_keys

, Table B was modified and my table A are cascaded without any errors like before

JoeDoe•3/28/24, 5:16 PM

Is there a visual explorer for local databases?

JoeDoe•3/28/24, 5:17 PM

something like d1-manager

JJoeDoe Is there a visual explorer for local databases?

Tony LeungOP•3/28/24, 5:17 PM

the database is stored under

.wrangler/state/v3/d1

.wrangler/state/v3/d1

. It's a sqlite file, you could explore or even modify it using your favorite tool

Tony LeungOP•3/28/24, 5:18 PM

I'm using sqlite viewer extension in vscode (which does not allows modification)

JoeDoe•3/28/24, 5:19 PM

ah ok perfect thank you

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

you could use any more advanced tool like datagrip

JoeDoe•3/28/24, 5:19 PM

Ill find something in intellij

JoeDoe•3/28/24, 5:19 PM

some plugin

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

IntelliJ or any Jetbrains IDE has database plugin bundled

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

it's a mini version of datagrip

JJoeDoe some plugin

Tony LeungOP•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

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

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

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

you could use dbeaver, it's opensource

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

there some plugins Ill try

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

Tony LeungOP•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.

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

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

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

that misleading line is noted in IntelliJ document.

TTony Leung that misleading line is noted in IntelliJ document.

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

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

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

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

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.

Tony LeungOP•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?

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

Possibly? Unsure.

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

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

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.

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

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

its ok

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

Ill manage for now

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

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

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

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:

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

I've tried bracketing with `PRAGMA defer_foreign_keys = ON`/`PRAGMA defer_foreign_keys = OFF` but it

Similar Threads

Similar Threads

Similar Threads