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/15/2025

Error: D1_ERROR: too many SQL variables at offset 460: SQLITE_ERROR

Hey there! Getting the following error ``` Error: D1_ERROR: too many SQL variables at offset 460: SQLITE_ERROR at D1DatabaseSessionAlwaysPrimary._sendOrThrow (cloudflare-internal:d1-api:129:19)...

Mini

1/15/2025

[Solved] applying migrations...error: type "application_status" does not exist

Hi! I am getting this error when trying pgEnum ```ts schema.ts ...

shreddish

1/15/2025

Connection terminated unexpectedly

I am all of a sudden starting to get errors thrown that state "Connection terminated unexpectedly" - I've updated to drizzle-orm 0.38.4 and am still seeing these issues. I am not sure if this is a drizzle, postgres driver or database issue. Anyone have any ideas? ``` import * as dotenv from 'dotenv';...

edard3v 🦀

1/15/2025

new api?

Have they changed the API? I don't see anything in the doc

pato

1/14/2025

When is it safe to delete migration files, snapshots and the journal file?

What the title says lol.

Jess182

1/14/2025

Does drizzle manage client connections internally?

Hi I have question for drizzle() method with STRING argument It is not clear in the documentation, but if I use string as an argument and call the method twice, does it create 2 connections/clients to the db or does it internally manage it to use the same connection/client? ```js...

Little Cutie Penguin 🐧

1/14/2025

InferInsertModel doesn't support sql<unknown>`` ?

It supported when insert but InferInsertModel wasn't. How to deal in this situation?...

Lazer_Pope (Vossi / Hendrik)

1/14/2025

Connection pool size > 1 leads to very erroneous DB behaviour

Heyo, I am using SvelteKit and Drizzle with a Postgres DB. When doing a lot of concurrent requests to my backend and with a connection pool with a max values > 1, I get a lot of weird behaviour. Sometimes after an insert, drizzle returns a correct looking DBO with an ID, but that row has never been inserted into postgres....

tur

1/14/2025

``` import { config } from 'dotenv'; import { defineConfig } from 'drizzle-kit'; import { resolve } from 'path'; ...

Tony

1/14/2025

Error: undefined is not an object

Getting the following error: ```bash 84 | span?.setAttributes({ 85 | "drizzle.query.name": query.name, 86 | "drizzle.query.text": query.text,...

Lazer_Pope (Vossi / Hendrik)

1/13/2025

Missing database entries under heavy load

If my server is under heavy load with many concurrent requests, inserts sometimes pretend to save a new object to the databse, return the DBO (which look correct), but then selecting that same entries returns nothing? `export async function insertProject(projectDto: InsertProject, userId: number) { const formFiles = projectDto.addFiles; try {...

Little Cutie Penguin 🐧

1/13/2025

Proper way to infer update model?

Currently I infer update model by partial of InferInsertModel which work fine, but in case of updating value with sql`` this error happended.

playsonmac

1/13/2025

drizzle-seed: how to avoid duplicate key value violates unique constraint for composite keys?

I have a usersWorkspaces table which references users and workspaces. When I run the seed script (I haven't defined any behavior for userWorkspaces), I'm getting the following error: ``` PostgresError: duplicate key value violates unique constraint "user_workspaces_user_id_workspace_id_pk" severity_local: 'ERROR', severity: 'ERROR',...

playsonmac

1/13/2025

[Solved] How to see a supabase with references to authUsers.id?

I have a supabase postgres and I'm trying to seed a table (permissions) with a foreign key to the drizzle-orm/supabase authUsers table. Here's what I'm getting when I try to seed permissions: ``` Error: Column 'userId' has not null contraint, and you didn't specify a table for foreign key on column 'userId' in 'permissions' table....

daveycodez

1/13/2025

Inferring Types from Schema?

Help plz. Been wrecking my brain why this doesn't work

Zefty

1/13/2025

Querying from information schema postgres

Does anyone know how to query from the system postgres tables? e.g. something like SELECT * FROM pg_timezone_names...

amianthus

1/12/2025

$defaultFn() for an ISO timestamp in a text() field set as NULL

Schema: ```ts export const users = sqliteTable("user", { id: text("id") .primaryKey()...

dayo

1/12/2025

Need help inferring types of nested model

I'm new to drizzle, so obvious skill issue here, but how can I infer types from models with specific relations selected? I know of InferSelectModel but I don't see a way to include relations. Ideally I'd want to infer the type i get from something like this:...

ice cream

1/12/2025

drizzle-kit generate not generating sql file anymore?

hello, is there a way to regenerate a deleted sql file? I tried doing drizzle-kit generate and it only says No schema changes, nothing to migrate 😴 I already ran generate once but I accidentally deleted it. Is there a way to regenerate it? Thanks!...

playsonmac

1/12/2025

[Solved] drizzle-seed autocomplete not working if there are enums or zod objects

Not sure which tag to use for drizzle-seed . I'm trying to seed my database and I was surprised that I wouldn't get table autocomplete inside the seed function when the schema is in different files. Whenever I import * from "./single-file" everything seems to work. Curiously when I deconstruct the import for a specific table, I lose the autocompelte. The tsconfig is in the comment below. Case 1 (works) - import * as schema from "./schema/contexts"...

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!