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!

8/24/2023

Sub-field Filtering example

In the 0.28.0 update that removed relation filters, the changelog suggests: https://github.com/drizzle-team/drizzle-orm/releases/tag/0.28.0

If you have used those fields in the where callback before, there are several workarounds:...

Andrey Los

8/24/2023

It is possible to stop notice logs from appearing?

Hi there. So I'm using postgres and I run execute with table truncate. No matter what I try I always get some stuff spammed into the console. Same applies for migration scripts. Overriding logger or writer doesn't help in this case....

space marine

8/24/2023

Drizzle-zod createInsertSchema types

if I have a schema : ```export const listings = pgTable("listings", { id: serial("id").primaryKey(), ... squareFeet: integer("sq_ft").notNull(),...

Ahmed

8/24/2023

cannot find package '@opentelemetry/api' in 0.28.4

I just upgraded to 0.28.4 and after I made the necessary changes for my types, I started the dev server and got this error. I'm using planetscale driver. ``` Error: Cannot find package '@opentelemetry/api' imported from qaimni\nodemodules.pnpm\[email protected]@[email protected]\node_modules\drizzle-orm\planetscale-serverless\index.mjs...

ak4zh

8/24/2023

adding default to array of text creates invalid migrations

values: text('values').array().notNull().default(['a', 'b']) generates: ALTER TABLE "test" ALTER COLUMN "values" SET DEFAULT a,b; ...

Noahh

8/23/2023

Missing @opentelemetry/api module at runtime when upgrading to 0.28.4

Just upgraded drizzle-orm to 0.28.4, and running my project (after a successful typecheck) I get the error Cannot find module '@opentelemetry/api'. Here is the full stack trace: ``` Require stack: - C:\Users...\node_modules.pnpm\[email protected][email protected]\node_modules\drizzle-orm\index-b1dbb7ec.cjs...

focused_morning

8/23/2023

Invalid default value for 'updatedAt'

Running into this issue, oddly enough this once worked and now breaks. ``` Error: target: americana-db.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'updatedAt' (errno 1067) (sqlstate 42000) (CallerID: planetscale-admin): Sql: "alter table InventoryItem modify column createdAt datetime(3) not null default (current_timestamp(3))", BindVars: {REDACTED} at PromiseConnection.query (/Users/robmartin/Projects/americana-neue/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/index.cjs:34122:26)...

firxworx

8/23/2023

how to define field w/ postgres IDENTITY?

I am trying Drizzle out for the first time. I thought to flex the quick start with realistic production user table schema. I can't find anywhere (including searching GitHub for examples) how to define the following field?? ```...

DiamondDragon

8/23/2023

Check Constraint not working?

@Andrew Sherman fyi - this doesn't seem to generate the check constraint

elaranthedreamer

8/23/2023

Is there a --force option for generating migrations in CI?

Hey guys, thanks for building this awesome tool. Our team loves it. We are using Github Actions and Drizzle to run migrations on a Postgres Docker Container during CI. However, we got stuck at the following: When running the generate-migrations command, it prompts the user (which does not exist in CI) to select whether to rename a column or create a new one. Since we cannot provider an answer during CI, is there an option to provide a default answer or skip these questions? Any help is appreciated. Thanks 🙂...

mehaac

8/23/2023

schema types

for some reason in my schema.ts file i have an error ``` export const your_table_name = pgTable('your_table_name', {...

Ahmed

8/23/2023

Chain orderBy clause problem

I have a query that filters a table based on search params ```typescript const instructors = await db .select() .from(DBInstructors)...

tomeverson

8/23/2023

NeonDB: Migration Taking Long

Hi, I have been using dirrzle with neon DB, and it has been a great experience. However, once I changed my schema a lil bit and migrate again, it was taking extremely long time and query is never executed. db/index.ts ```typescript import { neon, neonConfig } from "@neondatabase/serverless";...

Suleman

8/23/2023

I am getting typescript error when creating schema

No matter what column type i use, i get error for every type of column i add.

Sean Cassiere

8/23/2023

Type errors with 0.28.3

When trying to move from 0.28.2 to 0.28.3 I'm getting the following type errors on the table (pgTable) fields/columns. Also attaching a .txt file of the error message....

AGill

8/23/2023

Automatically apply migrations on serverless deploy

I've got a basic Todo app using Turso DB and Nuxt: https://github.com/Amar-Gill/nuxt-todo I'm wondering if there is a way to automatically apply migrations when I deploy to Vercel? The build command is npm run build. Right now, I open a shell into my Turso DB and paste the migration scripts....

siim

8/22/2023

`migrate()` prints to stdout

When I run the migrate() function it always prints content to stdout, and I can't find a way to disable it. I'm using migrate in tests, and it's super annoying because it's polluting the console and making the test output difficult to read. Does anyone know a workaround for this?

Screw

8/22/2023

0.28.3 types issue

is there a new way to handle typings in 0.28.3 i get type errors on my table builders and on 0.28.1 i do not

DiamondDragon

8/22/2023

Custom type not inferring correct zod schema?

Shouldn't this return as an array of strings?

Anand

8/22/2023

Connection to SQL destroyed (after idle). Do I need to manually handle open + close for each query?

i deployed my SQL server and nodejs server on railway. The server is up and running, for some reason my SQL connection disconnected? I was wondering if I am missing something fundamental or what? ```database.ts import dotenv from "dotenv"; import { drizzle } from "drizzle-orm/mysql2";...

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!