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!

10/25/2023

`sql.join` with `ODER BY` leads to syntax error while the sql query seems correct.

I am conditionally sorting the results from a database query ```ts const sortSqlChunks: SQL[] = []; if (sorting.length > 1) { const customSort = sorting.shift();...

Nelson Sousa

10/25/2023

How to run migration script?

I am looking into this doc (https://orm.drizzle.team/kit-docs/overview#running-migrations) regarding running migrations and you provide a script that we can call. My question is how can we call this script outside our app. Maybe through the bash/terminal?

Satvik S Nayak

10/25/2023

Cannot get id field in the next-auth session.

I am currently working on the drizzle nextjs project. I am using neondb postgresql as database. I am currently facing this issue where i cannot get userId in the session of getServerSession(). I have posted the code that i have worked on currently in this post. If i try to console.log(user) in session or jwt callbacks it returns a undefined value. The token doesn't have a id field. ...

auth.ts

Nelson Sousa

10/24/2023

How to express "children" or "parent" relation with typescript?

Let's say I have a country and region tables. A region belongs to a country, so on the regiontable, there's a foreign key country_id to the country table. The question is if it is possible to have a Country type generated like this: ```...

kstulgys

10/24/2023

'token' used in key specification without a key length

Apparently I need to use token: varchar("token", { length: 255 }) because token: text("token") giving issues when pushing. Why? I'm using drizzle with planetscale....

kstulgys

10/24/2023

ER_TABLE_EXISTS_ERROR

Can someone explain me what is the proper workflow? 1. change schema.ts (add another column to table) 2. generate migration 3. migrate...

benjick

10/24/2023

column "summary" cannot be cast automatically to type jsonb

Hello! I'm getting this error when running my migrations, I used to have a text field and now it's a jsonb ```ts...

untitled.

10/24/2023

how to use in deno

im trying to use it in deno but there are errors

Mr Volcano

10/24/2023

Postgres timestamp that will be the same across regions

Hello everyone, So I have a statement like the following: ```sql...

Matan Nahmani

10/24/2023

is there a way to wrap a column select with ST_AsText or any other sql statement?

I've created a custom column type but the column return by default a binary data, instead i want to wrap the select automatically with ST_AsText to human readable text.

CharlesCharlieCharles

10/24/2023

inferring the column information from the imported schema

is there anyway to get the column information from the imported schema information. When I dump the schema I can see that there is [Symbol(drizzle:Columns] property but not sure how I'd access it. Does drizzle provide some sort of API for extracting this data?

Olli

10/24/2023

Drizzle tries to import mysql2/promise even though I want to use postgress.

I got:

node_modules/drizzle-orm/mysql-core/db.d.ts:1:38 - error TS2307: Cannot find module 'mysql2/promise' or its corresponding type declarations.

1 import type { ResultSetHeader } from 'mysql2/promise';

...

Dgirth

10/24/2023

Filter for articles with at least one comment

I am trying to migrate to Drizzle from Prisma and I am having issue with being able to query for all Articles that has at least one Comment as the title says. Here's a simplified version of my schema: ```typescript export const articles = sqliteTable("Articles", {...

PWSey

10/23/2023

How to get a similar result of db.query but with extra aggregation and using select

I have the following drizzle query which works correctly but the results is not what I expect since we are grouping votes as well by their ids. ```js export const mostUpvoted = await db .select({ id: feedback.id,...

Pioter

10/23/2023

Next 13, Next-Auth with Neon Postgres and Drizzle vs Prisma 5

I am trying to set up Next-Auth with Neon Postgres and Drizzle, but failing miserably. I set up a repo with several branches, including configurations for: 1) Next 13, Next-Auth, Neon Postgres, Prisma 5...

janosch.hrm

10/23/2023

error: column "x" is in a primary key

I'm getting the following error, when trying to push my schema to my remote db: error: column "x" is in a primary key The weird thing is that everything works fine, when I drop all tables and run it for the first time, but if I try to re-run drizzle-kit push:pg, this is the error I get, even if the schema has not changed at all. Does anyone know what might cause this?...

DieZitrone

10/23/2023

postgres error: type "serial" does not exist

I want to migrate my my changes but i get this error: type "serial" does not exist. This is my schema: ```ts...

Liltripple_reid

10/23/2023

planetscale cache error

not sure if the issue is from drizzle or trpc, but trying to query the db via the RSC api fails with this error ```log result: { data: { secret: null,...

Whooopps

10/23/2023

MySql 8 - How to use onDuplicateKeyUpdate with array?

as the title says, how do i use onDuplicateKeyUpdate with arrays? I can pass an array to .values() function but after that i have no idea how to handle duplicate. Help would be appriciated. thanks

Alexandru Comanescu

10/23/2023

Postgres json_agg

How can I create this equivalent using drizzle? ```sql select p.id,...

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!