There is not enough information to infer relation "__public__.collectionsTable.tokens"
.
Here's a simplified version of the schema.
In short, each collection can have multiple tokens, but each token can belong to only one collection.
I haven't had any issues with this schema for around the 6 months that we've been using it, but we wanted to try out drizzle studio and ran into that issue. The database is running on Planetscale, not sure if that's relevant.world
. Due to the reference to the world in the users_to_worlds I get the error:
Error: update or delete on table "worlds" violates foreign key constraint "users_to_worlds_world_id_worlds_id_fk" on table "users_to_worlds"
I believe what I want to use is a CASCADE delete where everything referencing a world is deleted when I delete a world. Is this possible through Drizzle? I can't seem to find anything on this.{ skipCache: true }
is set, the user can bypass the cache and get the latest data. I'm feeling a bit lost however when it comes to the implementation itself. I can't find anything in the docs regarding refetching with new/updated params.
Is this something that's possible?svelte-turnstile
but I don't think that should make a difference.
Does anyone know what this error code means? And my other question is, is this the best way to protect inputs? I have a feeling I shouldn't use 1 global turnstile to protect more than 1 input however I didn't want to have to manage many different turnstiles and a lot of these inputs don't have anywhere for the turnstile to be so they have to be invisible. Will having 1 turnstile that thousands of people have to solve many times cause it to think all those people are bots?