TYeah 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.
TMy 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
VThank you!
MThe 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
MCan you try one more time when you're back online?
SIs it possible to share a d1 database between worker and pages locally?
SI'm symlinking the wrangler folder, it seems to work but was curious if there is a better way
Mwe are working on making it faster tho
CI 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?
CYes, but how can I know that the read replicas are caught up at that point
CCloudflare Docs
Create, develop, and deploy your Cloudflare Workers with Wrangler commands.
CLooks 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
Now the question is, when will we get the D1 Location Hint for Oceania? ;p
Where Durable Objects Live
Tracking where Durable Objects are created, wherever you are in the world.
C(I tried using the api and not the dash with
ocThere is now, it was just released?
LDoes anyone have a comparison of D1 vs Turso?
Lit's an upcoming feature which breaks compatibility with previous API
ZIt 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
LSo you can use both at the same time? Just one will make use of the deployed replicas while the other won't?
ZI 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.
UIf theres any changes it will be guarded by a compat date/flag
AHey team, What is the best implementation to achieve realtime using d1? some sort of CDC or access to the WAL?
MExactly this.
You can use the existing
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.
You can use the existing
env.DB.prepare()let session = env.DB.withSession(commitToken)session.prepare()session.batch()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.
FDo we really need replicas if we go 1db/user 
if we dont have heavy writes ofc
if we dont have heavy writes ofcUreplicas only helps with reads not writes
Jare there any tools that let you explore your d1 database with a gui similar to drizzle studio?
Jgoing to have a play with d1-manager, curious to hear if anyone's had any experience with it or has any other suggestions
Mfrom 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
A step-by-step guide to adding a back-end to your Astro project using Cloudflare D1 and Drizzle ORM
MAny ETA on worker-level support for the per-user DB approach?
Mwe don't do ETAs
FTrue 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 
i only have isolated users that dont/cant see other data so it should always be closest to the user 
Mread replicas are also critical above the 500-1k RPS mark, otherwise the individual DO starts queuing/overloading
FAah 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”!)
(especially with that “price”!)
M:soontm:
MThis is definitely not expected - we have metrics for cold starts. Are you seeing this repeatedly, or just a one-off?
Lhey, 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?
I created a model for a DB with prisma and migrated it SQLite. How can i "connect" this DB to Cloudflare D1?
MI'd recommend stepping through this guide from beginning to end! https://developers.cloudflare.com/d1/tutorials/d1-and-prisma-orm/
Cloudflare 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 …
Lthank you!!
LI was following the guide until this error appeared
Ldoes someone know how to resolve it?
Mwhats the contents of that SQL file?
Ljust this
Mout of curiousity, does it work if you remove the comments?
-- CreateTable and -- CreateIndex