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/19/2023

Drizzle typebox enum array not working

I am making this post to raise some attention to an issue I made around 2 weeks ago on GitHub. https://github.com/drizzle-team/drizzle-orm/issues/1345#issuecomment-1771082418 The typebox schema and types generated for enum arrays is wrong. It seems like it would be fairly simple to fix, I hope this can be investigated soon 😄...

cumironin

10/19/2023

Unable to use db.query but able to use reqular db.select

I had the problem with using Drizzle Queries, it isn't working but works with regular select my schema : ```js export const menuTable = pgTable('menu', { id: varchar('id', { length: 255 }).primaryKey(),...

Samir

10/19/2023

Issue with DOM element types

When I install drizzle-orm to my NextJS app (app dir). It ruins typescript types of DOM elements.

diegofariasm

10/19/2023

Dealing with type safety

I am trying to do something like this: if (result.length === 0) { throw new Error(No user with id ${id} found.); }...

Thomas

10/19/2023

How to filter by a column in a related table?

Example: list all recipes with a specific ingredient Also, I wish to include all ingredients of each matched recipe in the response...

d4mr

10/19/2023

Querying PG table by JSONB field

hi! I can't find any reference on how to query a Postgress table by a JSONB field. Eg: I have a table ```ts export const authMethods = pgTable( 'auth_methods', {...

pbochis

10/19/2023

drizzle-kit push:mysql drops unchanged primary key & introspect:mysql fails hard

drizzle-kit version: 0.19.3 database: Planetscale drizzle.config.ts: ``` export default {...

tenko

10/19/2023

Support for SKIP LOCKED in Postgres?

This feature would be really helpful. I wold love to know the best way to do this right now as well. Thanks

Mr Volcano

10/19/2023

VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString'

Hello everyone! So I'm getting the following error while trying to use the @vercel/postgres package with drizzle ORM ```txt...

3noix

10/18/2023

Transaction + prepared statement

Hi everyone. I was wondering how to correctly use a prepared statement inside a transaction with drizzle-orm. I obviously first looked at the documentation with no success then went to the github issues and found the issue #952 (https://github.com/drizzle-team/drizzle-orm/issues/952). I prepared an answer but eventually found that I was quite off topic and I came here. 1) In his code (issue 952), I don't see the point of using a prepared statement: he prepares a statement each time the function is executed then executes it right away. From what I understand / think, the prepared statement should be a global (with placeholders if needed), then executed in the function. ```ts...

DrX

10/18/2023

creating external types based on drizzle types

hey I'm trying to abstract some of my drizzle calls into seperate functions to refactor my code. How would I go about getting the type that my .values() enforces on the current table and replacing my data: any with that? ``` export async function createInvite(data: any) { const invite = await db...

m.skovgaard

10/18/2023

Drizzle-orm dependencies missing during build

Hi all, Im using Drizzle for the first time and finally made it work locally. But when I tried to build and push my code to a AWS Lambda it's missing a whole lot of dependencies ? This is my config: ```drizzle-orm: 0.28.6 pg: 8.11.3...

Valerio

10/18/2023

orderBy with variable column

Hey all! I'd like to explore the possibility to order a query by one of it's columns, but the column itself is inferred from a variable. What i've tried: ```ts // "categories" has 2 column, id and name...

Solution:

const sortField = 'name';

await db.query.categories.findMany({ orderBy: asc(sql.identifier(sortField)) });

const sortField = 'name';

await db.query.categories.findMany({ orderBy: asc(sql.identifier(sortField)) });

...

Mr Volcano

10/18/2023

VercelPostgresError - 'missing_connection_string'

Hello everyone, so I've been beating my head with this for a couple of hours I had managed to make it work initially but after changing some things up and setting up different DBs for staging, dev and prod it is no longer working When I run npm run dev the right env variables are loaded like ( DEV_POSTGRES_URL: 'postgres://defaul... but drizzle still gives me the error in the title....

Victj

10/18/2023

Problem with insert timestamp in postgres

Hello, i´m having problems with timestamp in postgres. When I save a timestamped date in the database the saved date is incorrect and also when i run a select query the selected date is wrong. If I run the insert query manually then the date is saved correctly, but when I do the select it still shows the wrong date. How can I solve it?...

Efkan

10/18/2023

Check Constraint Workaround

I know there's a work in progress for check support in Drizzle https://github.com/drizzle-team/drizzle-orm/issues/880 But, is there way to make it work now with the Drizzle's sql operator ? I couldn't find any examples...

Eternal Mori

10/17/2023

How to mimic the prisma cursor option for use with useInfiniteQuery

How to mimic the cursor option in drizzle with MySQL? This is the Prisma documentation: https://www.prisma.io/docs/concepts/components/prisma-client/pagination#cursor-based-pagination...

midi

10/17/2023

Drizzle relational query, filters

I'm trying to add some simple filters to my query, as according to https://orm.drizzle.team/docs/rqb#select-filters I've tried both where: eq(users.id, 1) syntax, and where: (users, { eq }) => eq(users.id, 1), - both result in

Type '{ where: SQL<unknown>; }' is not assignable to type 'true | { columns ?: ... 
Object literal may only specify known properties, and 'where' does not exist in type '{ columns ?: .....

Type '{ where: SQL<unknown>; }' is not assignable to type 'true | { columns ?: ... 
Object literal may only specify known properties, and 'where' does not exist in type '{ columns ?: .....

How do I add more filters to a relational query?...

dohn

10/17/2023

PostgresError: unrecognized configuration parameter "schema"

Hi everyone. I'm migrating a pretty large app from Prisma to Drizzle and its been great so far, but I'm having problems with my seed script: ```ts const client = postgres(DATABASE_URL!, { max: 1 }) const db = drizzle(client, { schema })...

SteveS

10/17/2023

How to get better errors?

On line 44 in the image, there is an error where I compared the userTable to the storedToken instead of the emailVerificationTokenTable. Since this would never work, shouldn't the error be more clear? The error it throws says that the column user.id does not exist. Of course, that column does exist, it just doesn't exist on the emailVerificationTokenTable. Is there any way to get errors that reflect this kind of mistake?

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!