Drizzle Team

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

Join

Drizzle Team

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

Join

Gurbinder

1/2/2025

Weird SQLite malformed error

Hey guys im getting this weird error and them my terminal just disconnects Error: ```js...

hasaanistein

1/2/2025

drizzle kit studio proble help ???

i am using drizzle and postgres but when i am launching drizzlekit studio it is showing this can any one help me i even tried ssl:false it still doesn't work

Helm

1/2/2025

TypeError: col.shouldDisableInsert is not a function

... (I use postgres)

PicardyTheThird

1/2/2025

drizzle-kit studio not reading typescript

When I run npx drizzle-kit studio it will throw errors that look like a pure js interpreter is looking at typescript files. All my files are valid typescript and no syntax errors. I think drizzle expects js when I'm providing ts. How do I solve this? "drizzle-orm": "^0.38.3" "drizzle-kit": "^0.30.1"...

James A Rosen

1/1/2025

Migrations with User-Defined Functions

I'm working on a very data-intensive application where we use a lot of user-defined functions to keep things performant and consistent. So far, every time we want to change one of these functions, we've defined a new custom migration with the full content of the function. This works, but it makes it very hard to see and review the changes in pull requests. Does anyone have a good solution for this?...

atri

1/1/2025

[SOLVED] - How to prevent columns from dropping - after merging fellow developer changes?

My fellow developer added some new columns in existing tables. I merged his code to my branch. Then I added a new table. But when I tried to generate migration, that migration drops all the changes made by fellow developer. What is the solution for this situation in drizzle orm. I am using drizzle with NestJS....

michi

1/1/2025

[solved] drizzle-kit push fails when using with cockroachdb

I have simply used pnpx sv create . and then pasted in my connection string from cockroachdb to my .env and am trying to run drizzle-kit push as instructed. ```

drizzle-kit push

drizzle-kit: v0.22.8...

David Gomes

12/31/2024

schemaFilter not working as expected

I've got this on my drizzle.config.ts:

schemaFilter: "public",

schemaFilter: "public",

And this is my schema.ts: ```import { InferSelectModel } from "drizzle-orm"; import {...

Nicolas Quiroz

12/31/2024

Can I install an extension in in psql through custom migrations?

Can I use a custom migration to install extensions on the database?

SpamixTheProducer

12/31/2024

drizzle-kit push tries to re-define all primary keys when updating schema (mysql/mariadb)

When I run drizzle kit push it tries to redefine all primary keys which of course ends up in a failure. I am using MariaDB with the mysql driver, so I've had to make a few adjustments to make it work (like not using serial). ``` ❯ bun drizzle-kit push No config path provided, using default 'drizzle.config.ts'...

GermanJablo

12/31/2024

`findMany` returns an empty array if the number of rows is +500 approx.

Hi, Could someone tell me why the following query works if I have less than 500 nodes in the DB, but fails otherwise? ```ts await this.db.query.nodes.findMany({...

Jonathan

12/31/2024

Error: Role "root" does not exist

Hi, I am trying to set up a project with Drizzle Studio but when I try to start the db with Podman (podman compose up --detach && drizzle-kit push) an Error occurs: PostgresError: role "root" does not exist. .env: DATABASE_URL="postgres://root:mysecretpassword@localhost:5432/local" ````...

Kyrre Gjerstad

12/31/2024

Which db provider for Edge connection with transactions

Hi! I'm trying to figure out which postgres client to use for edge compatibility in my Next.js app. I'm currently running on Vercel Node runtime, but working on migrating my app over to the edge runtime. I'm currently using supabase (as vanilla postgres), but I'm having issues getting the serverless edge compatible connection to work. I looked at neon, but looks like the serverless driver does not support transactions. I need support for transactions since I'm using them extensively with Drizzle. Current setup: - Next.js app using edge runtime - Drizzle ORM with postgres-js...

ersindeniz

12/31/2024

How to Use db.query to Access Transaction Data in Drizzle ORM When Using Connection Pool?

In Drizzle ORM, I was using createConnection and performing transactions with trx.create. After creating the transaction, I could use db.query to retrieve the data created within the transaction without any issues. However, after switching to createPool, the same approach doesn’t work. Specifically: After trx.create, the subsequent db.query calls cannot access the data created within the transaction....

Bryce

12/31/2024

Help with relations - Error: Unknown column in 'where clause'

When I try run this query to fetch all 'test' records along with the users that created each record, I get the following error: ``` const result = await db.query.testTable.findMany({ with: { creator: true...

ayyjohn

12/30/2024

how to nest select statement to achieve aliased result

if I have a basic findMany with nested relations and the following schema * users create reviews (as reviewer) * reviews are of a performance * performances are by an artist * performances are at a venue...

atri

12/30/2024

Need guidance - Migration dropping existing tables

I merged the migrations from other developer: Then I created a model named as 'C': But when I tried to generate migration for it:...

Rahul aithal

12/30/2024

Having Issue with Enum in Neon Postgres

I have been trying to have a schema of this kind ```export const userRoleEnum = pgEnum('user_role', ['user', 'admin']); export const users = pgTable('users', {...

Sameer

12/29/2024

[Solved] Issues with Middleware and Authentication in NextAuth.js with Drizzle and SQLite

Hi, I'm working with NextAuth (Auth.js) and Drizzle for the first time. I've successfully implemented OAuth for Google and GitHub, and I added the DrizzleAdapter and schema by following the NextAuth documentation. Now, I want to set up middleware to differentiate between protected and public routes based on whether the user is logged in. However, I'm running into a couple of issues:...

dBranded1

12/29/2024

Unable to push changes to Supabase

When running the command "drizzle-kit push", I can't get past the "Pulling schema from database" phase. I can do pretty much everything else, I haven't tested the studio though. This is a T3 stack app. This is the content of the drizzle.config.ts file:...

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!