Welcome to Answer Overflow!
Answer Overflow is the best way to discover Discord content. Browse trending forum posts, explore popular servers, or view new content. Know of a Discord server that should show up on the site? Learn more about adding a server!DTDrizzle Team
•Created by kinsyu on 12/1/2023 in #help
There's not enough information to infer relation
I am trying to use drizzle studio but I'm running into the following issue,
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.3 replies
DTDrizzle Team
•Created by iqrow on 5/24/2023 in #help
How to delete with cascade?
I'm using postgres with the following schema (reduced to the important parts):
And I'm trying to implement an api call to delete a
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.7 replies
DTDrizzle Team
•Created by McLean 25 on 4/5/2023 in #help
Can't find meta/_journal.json file when running migrate
3 replies
DTDrizzle Team
•Created by Louistiti on 7/18/2023 in #help
Clear the whole database?
For my test environment I'd like to clear the whole db.. is there a way to achieve this using drizzle ?
59 replies
DTDrizzle Team
•Created by eatmoose on 6/2/2023 in #help
Auto update timestamp fields
How to auto update fields like updated_at?
17 replies
VVALORANT
•Created by Mevix on 1/26/2024 in #community-help
secure boot verification failure
219 replies
NNovu
•Created by Sudhanshu on 10/15/2023 in #💬│support
How to install a specific version of 'pnpm'
As Novu using 7.33.4 version of pnpm but when I try to install pnpm then it install latest version but I don't want that,
Ref : https://pnpm.io/installation#installing-a-specific-version
from this link I got a command
curl -fsSL https://get.pnpm.io/install.sh | env PNPM_VERSION=<version> sh -
but this command works only on mac as curl is not supported in windows.9 replies
DTDrizzle Team
•Created by pablo on 9/21/2023 in #help
Does Drizzle support Microsoft SQL Server?
Does Drizzle support Microsoft SQL Server ?
3 replies
DTDrizzle Team
•Created by mr_pablo on 5/24/2023 in #help
drop tables
Is there a way to do a migration to drop tables? Other ORMs like Sequelize and Prisma have a concept of up & down migrations, but Drizzle doesn't. Is there a Drizzle way to do a "down" migration?
23 replies
DTDrizzle Team
•Created by fermentfan on 7/30/2023 in #help
Mocking Drizzle instance
Hey there, I am currently trying to find a good way to mock our drizzle instance for our unit test suite, but the nature of the usage of it makes it kinda hard. Is there somebody who is running a code base with a mocked drizzle?
19 replies
DTDrizzle Team
•Created by paaradiso on 11/8/2023 in #help
Cannot read properties of undefined (reading 'referencedTable')
i'm just playing around with queries and i can't get this to work:without the
with
it works.
i'm passing the schemas to the db
object:and here are the two schemas:12 replies
DTDrizzle Team
•Created by fasm on 5/31/2023 in #help
update multiple rows
How can I update values in multiple rows at once?
28 replies
DTDrizzle Team
•Created by Hocus on 12/5/2023 in #help
Updated drizzle-kit -> Error: Cannot find module 'drizzle-orm/pg-core'
I updated drizzle from:
to
I updated my config to use the new
defineConfig
method and changed the connectionString
to uri
but now I am getting this error when I try to run drizzle-kit:
Error: Cannot find module 'drizzle-orm/pg-core'
I dont use postgres, my driver is mysql2
using PlanetScale as DB provider.
my package.json - I am using bun run
incase it matters:
7 replies
VVALORANT
•Created by derek on 12/16/2023 in #community-help
how do you check what you got banned for?
Help
15 replies
DTDrizzle Team
•Created by ippo on 9/15/2023 in #help
TRIGGERS in Drizzle
Is there a way to define/implement TRIGGERs in Drizzle?
An example would be great!
13 replies
HHomarr
•Created by Bon on 2/24/2023 in #💬・get-help
Plex Integration Setup
Is there anything specific that needs to be done in order to connect Homarr to Plex? I'd assume an area to place the Plex instance URL, or some sort of API key field? I've enabled the Plex & Jellyfin widget but it doesn't seem to do anything.
Thank you in advance!
67 replies
DTDrizzle Team
•Created by johnnydt on 7/12/2023 in #help
testing best practices
Can anyone share how they're writing tests that involve drizzle? Looking for something similar to these docs for Prisma:
https://www.prisma.io/docs/guides/testing/unit-testing
9 replies
DTDrizzle Team
•Created by Hussein on 10/26/2023 in #help
"Seems like the schema generic is missing - did you forget to add it to your DB type?"
how to fix this... i need to use db.query
19 replies
DTDrizzle Team
•Created by SteveS on 8/11/2023 in #help
unknown command: drizzle-kit
Can't seem to get the command to work. Followed the instructions of the quick start guide. Any ideas?
24 replies
DTDrizzle Team
•Created by gambitboy on 6/6/2023 in #help
Postgres-js Migrate - Error: Can't find meta/_journal.json file [SOLVED]
I've gotten drizzle setup and running but I'm unable to run any migrations.
I'm using postgres-js and created a migrate.ts file that i'm executing.
Here is my code:
/lib/migrate.ts
I setup my config file:
./crizzle.config.json
so I've managed to generate some migrations in the migrations-folder but the migrate function is failing.
I've tried different databases, locations, tried to trigger the migration through a trpc api call.
10 replies
Filament\FilamentManager::getUserName(): Return value must be of type string, null returned
Is it possible to edit the user at Filament? I want instead of the name column, the columns firstname and lastname, but then comes the following error. How can I use my own columns without destroying the logic of filament
Filament\FilamentManager::getUserName(): Return value must be of type string, null returned
2 replies
DTDrizzle Team
•Created by Guy on 8/27/2023 in #help
Reference to auth.users?
i was following ben davis video about sveltekit + supabase/drizzle. in his video he mention that he want to use sql file in supabase/migrations as a source of truth and then rewrote it in schema.ts,
but i prefer to use schema.ts as a source of truth then use the drizzle migrations.
the problem is that i can't reference the auth.users like in the .sql file
7 replies
HHomarr
•Created by h3rm17 on 10/10/2023 in #💬・get-help
Torrent integration says no supported client found
13 replies