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

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";...

jrandeniya

8/22/2023

I can't create a simple table..

What am I doing wrong? ``` import { pgTable, serial, text, varchar } from "drizzle-orm/pg-core"; ...

Elv

8/22/2023

Prepared statements with TRPC

Hi, I just read that to use prepare statements properly with a serverless environment I need to put my statements outside the scope of the handler. However I use TRPC with NextJS so all my queries are in the router of TRPC which end up in the handle, my question is:

Where should I put my prepared statements considering I'm using the db connection from the context of TRPC ?...

Elv

8/22/2023

Conditional insert

Hi, Is there a way to do an insert only if the result of an exists statement is true ? I would like to do it in one query instead of having to check with another query before the insert. ...

Amur

8/22/2023

DB connections hangs after successful execution in Lambda locally

I'm testing my lambda functions locally with sls invoke local -f hello. after returning a success response, my execution doesnt end attached a video that shows the behaviour if i remove the db query then it works fine...

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!