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!

12/20/2024

Drizzle Kit Schema Diff?

Is it possible to use drizzle kit to detect if there are schema differences, without actually applying them? I'd love to create a CI/CD job that looks at the production schema and blocks merging new code in until any schema changes have been published.

wowzee101

12/20/2024

drizzle-zod is not sending custom message upon validation

I have created the following loginValidationSchema which I call in a validateData middleware inside my routes. I was expecting the custom error message to be sent to user whenever the user does not provide a value but it is not working \ zod-schema ```export const loginUserSchema = createSelectSchema(user, { email: (schema) =>...

cmrtk

12/19/2024

Driver error callback

I'm trying to upgrade to 0.3.4 with the new drizzle client and am wondering how you are supposed to access driver callback events like 'error' or 'end'. My current code looks like this: ``` const pg = new pg.Client(...); const db = drizzle(pg, { schema }); pg.on("error", () => ...)...

nomodule

12/19/2024

Sequence problem with drizzle-seed

I'm experiencing an issue where after seeding data into a PostgreSQL table with Drizzle ORM, the sequence (users_id_seq) doesn't update to reflect the highest id inserted. Here are the details: Schema: ```export const users = pgTable("users", { id: serial().primaryKey(),...

neural

12/18/2024

Update column ONLY enabled when column is set as NOT NULL #3666

TL;DR: // Sharing this on Discord to find some help and explanation about the title. After the first problem that started as a discussion on github and not get any attention, I'm trying to reach you guys through discord....

bennettcohen

12/18/2024

Column not created even though appears in migration file

Hey team - I'm noticing a column that isn't created in my database, even though the schema + migration file clearly show that it is. Setup: - docker postgres running locally - drizzle-kit: "^0.28.0"...

whoami

12/18/2024

Unexpected error happened 😕

```ts import { env } from "@/env.mjs"; import type { Config } from "drizzle-kit"; const path = "./src/server/lib/db";...

jafar3599

12/18/2024

Drizzle always says data exists even tho it can be undefined in ts.

export const selectRenter = async (name: string) => {
  return db.select().from(renter).where(eq(renter.name, name));
};

export const selectRenter = async (name: string) => {
  return db.select().from(renter).where(eq(renter.name, name));
};

This is my service....

cv01

12/18/2024

Is this community still active?

For such a large OSS project with so many backers and users, it sure is quiet here.

Omesepelepe

12/18/2024

"There is not enough information to infer relation" with many to many query

Hey there, I'm encountering the following error message when trying to do a many to many query:

ERR error: There is not enough information to infer relation "locations.tags"

...

patrick

12/18/2024

drizzle-zod 0.6.0 breaks my createSelectSchema vs 0.5.1

subject line says it. the result of createSelectSchema returns a schema that has all fields nullable. No other changes other than upgrading from 0.5.1

Sadra

12/17/2024

Issue with $defaultFn and Column Typing in SQLite

Hey Drizzle team! 👋 When using $defaultFn in an SQLite schema, it seems like column typing gets ignored during inserts and updates. Is there a plan or timeline to address this issue?

DiamondDragon

12/17/2024

Can't upsert with onConflictDoUpdate & generatedAlwaysAsIdentity ID columns?

I've noticed the type system doesn't recognize the ID columns (since they are supposed to be autogenerated?) How would one upsert or update? The ID field is not available ```ts...

The Rumbling

12/17/2024

Cannot generate Typebox schema from Drizzle Enum

i just trying to do the same thing as show in the docs here: https://orm.drizzle.team/docs/typebox#select-schema so i just copy and paste this from the docs: import { pgEnum } from "drizzle-orm/pg-core"; import { createInsertSchema } from 'drizzle-typebox'...

RamonaSteve

12/16/2024

Error: we don't support params for `sql` default values

I use a specific format for the default value for the primary key for the tables in my PostgreSQL database. In my schema file, this works: ``` export const unitOfMeasureTable = pgTable("unit_of_measure", { id: text("id")...

Johnny

12/16/2024

Filter on included relations

Hello! Hope you're all doing well! Is it possible to filter based on included relations? ``` return await this.db.query.myTable.findMany({ with: {...

callMeBonstana

12/16/2024

drizzle-kit error: Invalid target "es2023" in "--target=es2023"

How can i configure drizzle-kit to support es2023, when i reduce version to es2022 it works but for the project we need es2023. Is there a way to do this?

Hello, I’m Allie!

12/16/2024

Migrations against Local Turso

I am currently running a local Turso instance with turso dev. How do I go about seeding it with drizzle-kit? Here's my config so far: ```ts import { defineConfig } from "drizzle-kit"; ...

jsingleton37

12/16/2024

Running into some type errors with query.where

I have a massive query that grabs rows from a table called transfer_portal_entries and joins them with a couple other tables to get the players information back that is needed to populate a page. However, when it comes to the if statements around the filters, query is underlined saying ``` Property 'where' is missing in type 'Omit<import("/Users/jamessingleton/Code/Businesses/redshirt-sports/nodemodules/.pnpm/drizzle-orm@0.38.2@libsql+client-wasm@0.14.0@opentelemetry+api@1.9.0@types+pg@8.6.1_@types_oydy3vileqrvfkrrqmsazssq7y/node_modules/drizzle-orm/pg-core/query-builders/select").PgSelectBase<"transfer_portal_entries", { id: import(...' but required in type 'Omit<import("/Users/jamessingleton/Code/Businesses/redshirt-sports/nodemodules/.pnpm/drizzle-orm@0.38.2@libsql+client-wasm@0.14.0@opentelemetry+api@1.9.0@types+pg@8.6.1_@types_oydy3vileqrvfkrrqmsazssq7y/node_modules/drizzle-orm/pg-core/query-builders/select").PgSelectBase<"transfer_portal_entries", { id: import(...'.ts(2741) select.d.ts(402, 5): 'where' is declared here....

AlexDaniel

12/15/2024

Executing a query that was made with QueryBuilder

I have a pnpm workspace where the schema and some queries are defined in one subproject, but the db connection is another subproject. I want to use a QueryBuilder to build my queries, which I'd then import and execute once I have my connection. So the question is simple – how can I execute the result of a QueryBuilder using the drizzle object?...

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!