Hi guys, is there anyway to turn off foreign key check while migrating the database? Some table alte

Hi guys, is there anyway to turn off foreign key check while migrating the database? Some table altering tasks needs table to be dropped, which will cascade referenced tables.

Tony LeungOP•4/3/24, 1:39 PM

A sample scenario was mentioned in this issue https://github.com/cloudflare/workers-sdk/issues/5438

GitHub

🚀 Feature Request: Allow turning off foreign key check while migrat...

Some table altering tasks in SQLite cannot be achieved without replacing it with a new table (by dropping - recreating the table) (like adding foreign keys, changing primary keys, updating column t...

TTony Leung Hi guys, is there anyway to turn off foreign key check while migrating the datab...

Vy•4/3/24, 1:44 PM

checkout https://developers.cloudflare.com/d1/build-with-d1/foreign-keys/#defer-foreign-key-constraints

Cloudflare Docs

Define foreign keys · Cloudflare D1 docs

D1 supports defining and enforcing foreign key constraints across tables in a database.

VVy checkout https://developers.cloudflare.com/d1/build-with-d1/foreign-keys/#defer-...

Tony LeungOP•4/3/24, 1:46 PM

This works with table creating or importing but not for table dropping. Matt also suggested me to bracketing the migration by that pragma but sadly it didn't work

Village (Josef)•4/3/24, 2:23 PM

Got another question, there's still no way to dynamically bind to databases correct? I.e. bind to all 50k DBs from a Worker instead of the ~5k that'll fit in wrangler.toml? I believe you can use the API, but that kind of defeats the purpose.

kian•4/3/24, 2:25 PM

Correct

Original message was deleted

Tony LeungOP•4/3/24, 2:26 PM

Yeah I think it's the only way to add foreign key or change column type, but whenever I drop the table, all records in tables which reference to the table dropped before are gone too because of cascading on delete.

Tony LeungOP•4/3/24, 2:30 PM

My current approach is store the child table data to a temp table then insert it again after migrating the parent table. But when my child table also has some more children, the task turns out to be complex and wasteful

Kkian Correct

Village (Josef)•4/3/24, 3:10 PM

Thank you!

PPelps Hi. Is there any work on a package similar to database-js from planetscale to al...

Max (@rozenmd)•4/3/24, 5:03 PM

The REST API is significantly slower than a Worker, would recommend a simple wrapper over a Worker instead: https://github.com/elithrar/http-api-d1-example

Original message was deleted

Max (@rozenmd)•4/3/24, 5:07 PM

Can you try one more time when you're back online?

squareclamp•4/3/24, 5:24 PM

Is it possible to share a d1 database between worker and pages locally?

squareclamp•4/3/24, 5:31 PM

I'm symlinking the wrangler folder, it seems to work but was curious if there is a better way

PPelps I mostly use workers. I was just curious cause some ppl might like D1's offering...

Max (@rozenmd)•4/3/24, 6:16 PM

we are working on making it faster tho

Cory•4/3/24, 6:48 PM

I am trying to understand how session-based consistency would work in an application such as SvelteKit and the data invalidation methods. I understand the example of consistency when executing multiple queries in the same function, but how can I guarantee that the next reload of the page will be up to date? Does anyone have any examples of this?

Original message was deleted

Cory•4/3/24, 8:03 PM

Yes, but how can I know that the read replicas are caught up at that point

Ggotfredsen but .. where is the D1 download .. / export .. for backup ? 🙂

Cyb3r-Jak3•4/3/24, 8:19 PM

https://developers.cloudflare.com/workers/wrangler/commands/#export

Cloudflare Docs

Commands - Wrangler · Cloudflare Workers docs

Create, develop, and deploy your Cloudflare Workers with Wrangler commands.

Chaika•4/3/24, 9:00 PM

Looks like Oceania/Australia DOs are online! https://where.durableobjects.live/colo/SYD/
Now the question is, when will we get the D1 Location Hint for Oceania? ;p

Where Durable Objects Live

Sydney, New South Wales, Australia(colo) | Where Durable Objects Live

Tracking where Durable Objects are created, wherever you are in the world.

Chaika•4/3/24, 9:00 PM

(I tried using the api and not the dash with ococ and it still rejects it lol)

Original message was deleted

Cory•4/3/24, 9:07 PM

There is now, it was just released?

LordSilver•4/3/24, 9:07 PM

Does anyone have a comparison of D1 vs Turso?

LordSilver•4/3/24, 9:13 PM

it's an upcoming feature which breaks compatibility with previous API

LLordSilver it's an upcoming feature which breaks compatibility with previous API

zegevlier•4/3/24, 9:15 PM

It doesn't break compatibility with the old API, you can still use the old API just fine. It's just that there is no change to behaviour of the "old" API when the new API is introduced

Zzegevlier It doesn't break compatibility with the old API, you can still use the old API j...

LordSilver•4/3/24, 9:16 PM

So you can use both at the same time? Just one will make use of the deployed replicas while the other won't?

LLordSilver So you can use both at the same time? Just one will make use of the deployed rep...

zegevlier•4/3/24, 9:18 PM

I can't confirm whether you'll be able to use them simultaneously, but D1 is a GA product, so I would not expect any of the current APIs to change in a backwards-incompatible way.

Unsmart•4/3/24, 9:20 PM

If theres any changes it will be guarded by a compat date/flag

albyzyx•4/3/24, 9:55 PM

Hey team, What is the best implementation to achieve realtime using d1? some sort of CDC or access to the WAL?

Zzegevlier It doesn't break compatibility with the old API, you can still use the old API j...

Matt Silverlock•4/3/24, 9:58 PM

Exactly this.

You can use the existing env.DB.prepare()env.DB.prepare() and other APIs, or you create a session via let session = env.DB.withSession(commitToken)let session = env.DB.withSession(commitToken) and then call session.prepare()session.prepare(), session.batch()session.batch(), etc, etc.

We aren't breaking the APIs. Users that never adopt the session API will have D1 as it works today, with the same consistency model they've built their app against.

Developers who want to use replicas can adopt the session API.

forslunds•4/3/24, 10:02 PM

Do we really need replicas if we go 1db/user

if we dont have heavy writes ofc

Unsmart•4/3/24, 10:05 PM

replicas only helps with reads not writes

johtso•4/3/24, 10:57 PM

are there any tools that let you explore your d1 database with a gui similar to drizzle studio?

johtso•4/4/24, 12:13 AM

going to have a play with d1-manager, curious to hear if anyone's had any experience with it or has any other suggestions

Jjohtso are there any tools that let you explore your d1 database with a gui similar to ...

mulch•4/4/24, 3:46 AM

from this post it looks like it's possible to use Drizzle Studio with D1 (if you're using Drizzle): https://kevinkipp.com/blog/going-full-stack-on-astro-with-cloudflare-d1-and-drizzle/

Kevin Kipp

Going full-stack on Astro with Cloudflare D1 and Drizzle

A step-by-step guide to adding a back-end to your Astro project using Cloudflare D1 and Drizzle ORM

mulch•4/4/24, 3:47 AM

Any ETA on worker-level support for the per-user DB approach?

Mmulch Any ETA on worker-level support for the per-user DB approach?

Max (@rozenmd)•4/4/24, 5:31 AM

we don't do ETAs

Original message was deleted

forslunds•4/4/24, 5:32 AM

True your case need it, good luck

i only have isolated users that dont/cant see other data so it should always be closest to the user

Fforslunds Do we really need replicas if we go 1db/user 🤔 if we dont have heavy writes ofc

Max (@rozenmd)•4/4/24, 6:06 AM

read replicas are also critical above the 500-1k RPS mark, otherwise the individual DO starts queuing/overloading

MMax (@rozenmd)read replicas are also critical above the 500-1k RPS mark, otherwise the individ...

forslunds•4/4/24, 6:19 AM

Aah right its an DO, valid case! Thanks for heads up. Cant imagine that load per user for my case but better safe than sorry

(especially with that “price”!)

CChaika Looks like Oceania/Australia DOs are online! https://where.durableobjects.live/c...

Max (@rozenmd)•4/4/24, 8:05 AM

:soontm:

LLiudmila cold start time with D1 appears to be 2sec, my DB is <2MB. Is this expected? Do ...

Matt Silverlock•4/4/24, 12:51 PM

This is definitely not expected - we have metrics for cold starts. Are you seeing this repeatedly, or just a one-off?

Lucho•4/4/24, 2:42 PM

hey, im a beginner with D1 and i was hoping to find some help
I created a model for a DB with prisma and migrated it SQLite. How can i "connect" this DB to Cloudflare D1?

LLucho hey, im a beginner with D1 and i was hoping to find some help I created a model ...

Matt Silverlock•4/4/24, 3:01 PM

I'd recommend stepping through this guide from beginning to end! https://developers.cloudflare.com/d1/tutorials/d1-and-prisma-orm/

Cloudflare Docs

Query D1 using Prisma ORM · Cloudflare D1 docs

Prisma ORM is a next-generation JavaScript and TypeScript ORM that unlocks a new level of developer experience when working with databases thanks to …

Hi guys, is there anyway to turn off foreign key check while migrating the database? Some table alte

Similar Threads

Similar Threads

Similar Threads