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!

6/11/2024

getting the initialize drizzle types.

I wanted to do some backend crud. im not sure how to get the initialize db types of drizzel any knows how? ``` import { db } from "@utils/turso/clients"; const api = apiCrud({ client: db,...

christrading

6/11/2024

LibsqlError: SQLITE_BUSY: database is locked

I am getting a LibsqlError: SQLITE_BUSY: database is locked error on my insert function here with LibSQL/Turso as my SQLite driver ```ts export async function putClientGroup( clientGroup: ClientGroupRecord, ): Promise<void> {...

Caspian Nightworth

6/11/2024

Convert PostgreSQL to Drizzle ORM

I have the following SQL that I am trying to convert to Drizzle ORM for my NextJS project. ```sql SELECT ffxiv_blue_mage_tracker_spells.id,...

Solution:

That helped. Thank you

EarHolesMcGee

6/11/2024

Cannot use 'in' operator to search for 'enumValues' in undefined

This is suddenly issue - I haven't changed anything in my schema, I just updated to the newest version of drizzle/drizzle-kit ```ts export const user = pgTable('user', { id: serial('id').primaryKey(),...

fynn

6/11/2024

how to properly close mysql pool connection?

Just wanted to add a migrate.ts file, and got this out a example: ```import "dotenv/config" import { migrate } from "drizzle-orm/mysql2/migrator" import db from "@/app/db/drizzle"...

Lloyd

6/11/2024

Top-level await in drizzle.config.ts

Is there a reason top-level await is only supported in migrate/studio commands and not generate/check, is this something that can be trivially added to drizzle-kit? In my case I'm reading the secret asynchronously via AWS. There's an open issue with a workaround posted, which does work, but is kind of gross: https://github.com/drizzle-team/drizzle-orm/issues/1982#issuecomment-2112340840...

Simon

6/11/2024

Drizzle with Zod throws type errors with simple `numeric` example

For example, I define a PostgreSQL table with an input schema: ``` export const Foo = pgTable('foo', { bar: numeric('bar'), });...

SteveS

6/11/2024

Why is it the case that my IDE says `await` does nothing on pretty much every single function?

I'm trying to setup a startup script that creates a local db and seeds it when I start my project. I'm running into an error where db is just not defined or has undefined columns. I'm debugging, and I can't help but notice that my IDE says await does nothing on the migrate function or any of the db.select() calls....

JChicano

6/10/2024

How to do and "inArray" with a dinamic array?

I did this on the code and is working well, the things is that it throws and error and idk how to fix it

vr7bd

6/10/2024

too many clients already, remaining slots reserved for superuser

I have a production deployment where I'm facing this issue. I ran SELECT count(*) FROM pg_stat_activity and noticed that there are indeed 100 connections which is the max. However, I noticed most of them are idle. Temporarily I've increased the max_connections to 500. I have couple of questions to which I'm not getting straightforward answers: 1. Why are there so many idle connections? I understand if there are many active connections. But why idle? 2. If there are that many idle connections, shouldn't the connection pool of postgres.js kick in as it says here (https://github.com/porsager/postgres?tab=readme-ov-file#the-connection-pool) that the previous open connection will be used? So my understanding is that the idle connections will be made active with the new queries. Why isn't that happening? 3. Will I have to manually set the idle_timeout and max_lifetime values to lower and optimal values for my use case to get rid of idle connections? 4. Along with the increasing max_connections, should I increase anything else? Do I need something like pg_bouncer and how would that help?...

kubus

6/10/2024

Weird freeze in code, seemingly stalling on drizzle query

My function runs a few queries to the database, but they don't seem to basically ever finish. I don't know what it's caused by, i have tried fully resetting the database and creating only the user/database and running the migrations and that didn't help. The function is run lots of times concurrently, so there's probably around a 1000 queries being ran at the same time. I know it's not ideal for performance, and i am planning to fix it soon, but i don't think it should be causing issues.

Headless

6/10/2024

Typescript Error

Anyone know why this is happening? I upgraded my drizzle version so maybe something changed?

6/10/2024

Warning: You need to pass an instance of Client:Client

Could someone explain / show me what changes I need to apply to the config file? Thanks in advance! drizzle-kit push: ``` ❯ pnpm drizzle-kit push --config=.../drizzle.config.ts...

nowifi4u (Max) 🗕 🗗 🗙

6/10/2024

Prepared insert statement with customType

When using prepared insert statement with customType the Placeholder object gets passed to the toDriver of the custom type. How do I resolve it? Schema: ```ts export const sessionSchema = pgTable('session', {...

luis

6/10/2024

Drizzle ORM + Supabase Enforce SSL

I'm trying to connect with a direct pool connection (transaction mode). I'm deploying to Supabase Deno functions. This is my URL: postgres://postgres.{user}:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:6543/postgres const client = postgres(url, { prepare: false }); const db = drizzle(client);...

ztraeshuxjmv

6/10/2024

Can't infer relationship one-to-one

I'm trying to follow the relationship docs to set a relationship between a user and a role, but I'm getting the error Error: There is not enough information to infer relation "users.role" although I'm sure I'm following the example on this page: https://orm.drizzle.team/docs/rqb#one-to-one Can anyone help me find the issue? Code: ...

pvman

6/10/2024

Cannot set null value to FK - null value in column "X" of relation "Y" violates not-null constraint

Hi everyone, I'm trying to create a userId column, fk to users.id but optional (so I don't set the notNull property): userId: char("user_id", { length: 12, }).references(() => users.id), But when I try to insert a value with NULL user_id, I get the error:...

addamsson

6/10/2024

Drizzle complains when I'm trying to insert into a table.

I have a schema that looks like this: ```ts export const Organization = pGtable( "Organization", {...

addamsson

6/10/2024

Is it possible to use the Query API to select many-to-many relations?

In prisma I can do this to select the entities from the "other side" of a many-to-many join: ```json export const select = { id: true, email: true,...

addamsson

6/10/2024

How can I configure `drizzle-kit introspect` to generate a schema with a schema?

I'm using this guide to migrate from Prisma to Drizzle and when I'm calling drizzle-kit introspect it generates a schema.ts file without using a pg schema. It should be obvious to drizzle-kit that I'm using schemas since I have ?schema=myschema at the end of the database connection string. How can I fix this?

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!