Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

1/26/2025

Error: getaddrinfo ENOTFOUND ep-delicate-thunder-a58xbwga.us-east-2.aws.neon.tech

I am only able to generate the migrations npx drizzle-kit generate but not able to migrate it npx drizzle-kit migrate or npx drizzle-kit studio when I am trying to open up the drizzle studio or run migrations, I am getting this error please find attachments. don't know from where it's coming, my internet is working fine...

Solution:

Seems like a Neon issue

dinhanhthi

1/25/2025

Cannot run Studio with IndexedDB setup for PGlite

Hi everyone, I start my PGlite setup with ``` const client = new PGlite('idb://xxxx'); const db = drizzle({client});...

MrGreyKnight

1/25/2025

Relations mysql Name

I am trying to use relations in drizzle and I want to have the foreign keys setup in mysql. I currently have a setup like this but when generating migratin files (drizzle-kit) it is causing foreign key names which are too long (mysql max 64). I cannot see anyway in the docs to name the specific foreign key and it would be painful if i had to manually change the foriegn key name in every generated migration each time. ``` customerId: varchar("customer_id", { length: 36 })...

nikhil

1/25/2025

drizzle-seed

is it not possible to have column refinement within a join? ```ts await seed(db, { ...schema, ...relations }).refine((f) => ({ profile: { count: 8,...

SheldonFromBBT

1/25/2025

Cannot use supabase serverless on cloudflare pages

Hey all I get this error on deployment : Error: Failed to publish your Function. Got error: Uncaught Error: No such module "node:events". This is my db setup: ``` ...

M Zeeshan

1/24/2025

Array of Integers Referencing Another Table

Hi there, I'm working with Drizzle ORM and PostgreSQL, and I need to define a column in a table that stores an array of integers. Each integer in the array should reference the id column of an asset table. Here's what I'm trying to achieve: ...

benjick

1/24/2025

error: relation "xxx" already exists

Hello! Every time I run a second drizzle-kit up I get the same error, on the same table every time. I need to completely wipe my database in between

error: relation "table_filters" already exists...

Case S.

1/23/2025

Variable behavior for .onConflict[X] method of .insert?

Let's say that I create an array of insert statements along the lines of db.insert(targetTable).values(targetValues) and, on a conflict, I want different behavior based on why there was a conflict. For instance, if the conflict arises due to the id field having a unique constraint that would be violated by the entry, I would want to update, like: db.insert(targetTable).values(targetValues).onConflictDoUpdate({ target: targetTable.id, set: targetValues }) ...

Anas Badran

1/23/2025

Database design

I'm building an app for a center 'school' for Quran teaching and memorization. I want to track students daily progress and attendees, there is also can monthly tests, each class also can choose best student of the week each week. My question is: how do I link these data to a certain year?...

outranker

1/23/2025

How to mark migration as applied?

The title. I got a hybrid database-first and codebase-first migrations I do some changes on the database itself via db tools and later create a custom migration for those changes using drizzle. Now I need to mark it as applied. I'm struggling to figure out how to do that. I would really appreciate if anyone could help me out with this one...

David L. Bowman

1/22/2025

visualizing schemas and relationships

is there good software i can use w/ drizzle orm which helps me visualize my schemas and relationships?

Erick V

1/22/2025

onedollarstats - invite feature

Hi, cool product! Is the "invite" feature not ready yet? I tried to invite a couple of persons and myself with another email and I don't get a link or something like that. I also send an email to [email protected] but it bounced back....

bradws

1/22/2025

How to insert data into table (seed) every time I do a 'drizzle-kit push'?

How do you set that up? I can't find any documentation on that,

Boby

1/22/2025

error while inserting the data in the dynamic table

Hi, I am trying to insert the data which is coming from the form into the table, so, I am using this ```tsx const tableName = data.tableName await db.insert(tableName).values() res.status(201).json({...

s.m.haris

1/22/2025

Drizzle forcefully dropping ENUMs

I am using a single neon db for 2 of my apps each app has 2 different ENUMs. If from scratch i push the first app it pushes alright But for the second app it asks for new enums creation an upon selection of create new the script tries to drop other enums and gets an error ```...

triple._.a

1/22/2025

My database suddenly stopped working and there's no helpful error message

It was running just fine even 2 hours ago, nothing has changed on my end since then. Can't even access the database through drizzle studio locally, or even by going on Turso -> Edit Data -> Drizzle Studio. More serverside errors from the console: LibsqlError: SERVER_ERROR: Server returned HTTP status 401 ...

Blume

1/22/2025

drizzle-kit studio reading .env file

Heya, I just wondered if it's drizzle-kit that automatically reads the .env file? Is it possible to disable that? I'm reading my env files in via nextjs's @next/env library so I can make use of .local etc. But when drizzle-kit reads in the normal .env file next-env can't override the already read env vars with the .env.local since it thinks the already read vars are system wide env variables which always have the highest priority.. Any Idea how to solve this? Just a flag or something that disables automatically reading .env files would be perfect.....

ac222222222222

1/21/2025

drizzle-kit generate keeps trying to recreate enum value that already exists

I recently created a migration using drizzle-kit generate after replacing a pg enum value. the generated migration was incorrect as it added the new value but never removed the old one. Hence, I manually edited the migration to look like this: ALTER TYPE job_status RENAME VALUE 'completed' TO 'successful'; however, now whenever I run generate for subsequent migrations, it keeps trying to create the new enum value: ALTER TYPE "job_status" ADD VALUE 'successful';--> statement-breakpoint...

Krimax

1/21/2025

Nullable field cannot be inserted or updated

Hi! I've already broken my head, I've asked several ai chats why this might be an error, but they don't know why the error occurs The problem is that I can't create/update the channels record's userId fields when the userId isn't set to .notNull() When I bet .notNull() everything works for me, but I need the user Id to be an optional field...

voglerr

1/21/2025

drizzle-orm/libsql 'file:' does not work with Next.js

I'm following https://orm.drizzle.team/docs/get-started-sqlite, but using e.g. drizzle('file:libsql.db') does not work with Next.js. When using import { drizzle } from 'drizzle-orm/libsql', I get

LibsqlError: URL_SCHEME_NOT_SUPPORTED: The client that uses Web standard APIs supports only "libsql:", "wss:", "ws:", "https:" and "http:" URLs, got "file:". For more information, please read https://github.com/libsql/libsql-client-ts#supported-urls

. When using import { drizzle } from 'drizzle-orm/libsql/node', I get Error: Neon: unsupported system: undefined. Both work fine when running a file via e.g. tsx but not when running with next dev --turbopack....

Previous Next

Gaming

Programming

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!