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

Each element of array is a foreign key

Hello, I'm trying to figure out how to create a postgres schema that will hold an array of ids property, and each element of that array is a foreign key. Is this possible with Drizzle? Here's my implementation: ```typescript...

koshchei

8/29/2023

Buffer isn't defined

I use blob mode:json for my fields and run it on Cloudflare Workers. But I get that Buffers isn't defined. As I understand blob only compatible with Node.

Amur

8/29/2023

Is it possible to do lateral sub-query join without relational queries?

I'm trying to rewrite the same query that the relation query builder does behind the scenes but not sure if it's possible If i log the query this is what i get ```sql select "articles"."id", "articles"."title", "articles_keywords"."data" as "keywords" from "articles" left join lateral (select coalesce(json_agg(json_build_array("articles_keywords"."article_id", "articles_keywords"."keyword_value")), '[]'::json) ...

MarvinKR

8/28/2023

[Remunerated] Looking for help to switch my project from Prisma to DrizzleORM

Hi folks! Been building the MVP for my startup (https://CocktailAndDinner.com) using MongoDB & Prisma. Now, looking to switch to Planetscale + DrizzleORM. This can become an ongoing work, but for now I'm looking for a senior dev to mentor me....

Bozic0909

8/28/2023

drizzle studio tables are empty

Hi, I created app using Next.js, TRPC and next-auth and I setup auth logic with Discord Provider, everything works fine except when I run drizzle studio all tables are empty even tho I can login without problems, anyone had something similar? btw I'm using sqlite...

Guilherme Rosado

8/28/2023

Bug on custom type inference? Maybe I'm doing something wrong.

```ts export const timez = customType< { data: Date; driverData: string;...

roob

8/28/2023

JSON with PostgreSQL not serializing correctly

I have define my field like this:

  hostnames: jsonb("hostnames").$type<string[]>().default([]),

  hostnames: jsonb("hostnames").$type<string[]>().default([]),

...

koshchei

8/28/2023

hashing password in Cloudflare Workers

Can someone help me find function to hash password and verify it that works in Cloudflare Workers

cobite

8/28/2023

How to get the count of records? Here is my normal sql, trying to translate into drizzle

```.select({ id: comments.id, parentId: comments.parentId, // TODO countReplies: get the comment count where this id is listed as the parentId of other comments (...

tea bone

8/28/2023

Is there a way to create check constraint?

I need to have a check constraint in my schema. I know check function is currently not supported, but is there a way to hack our way into implementing it?

Morten

8/28/2023

is there any way to create related records with the main record together like this in prisma

cobite

8/28/2023

How to add to the database where the table has a many relationship to another table

I have a users table, which has a many relationship to to a posts table. I want to add a new user to the table, which I can do, but how do I go about adding new posts to that user? Does it add a full post object to the user? Or just an id to the new post which will be in the post table? `export const users = pgTable('users', {...

daniel

8/28/2023

Where clauses across multiple tables in relational queries

Is is possible to specify a where condition in a relational query that includes conditions from the primary table and one or more relations? e.g. ```ts {...

Geauser

8/28/2023

Prepared queries typings lost after export in monorepo

I'm using SST and I defined my prepared queries in a separate core package to be used across functions in the functions package. The prepared queries are defined like that: ```ts // packages/core/db/preparedQueries.ts...

dumbboy

8/28/2023

Nodejs - Typescript Project Build

I am stuck at building typescript node project, When I run tsc I get these errors because of drizzle.

DiamondDragon

8/28/2023

Column Unique name appears to be incorrect when spreading common fields to multiple tables

Came across this issue. Not sure if it's a big deal but i am spreading a common set of timestamp fields around to most of my tables and it looks like the unique name is incorrect. It looks like all my tables have this 'organizations_created_at_unique' naming convention on them with the unique field ```ts [ 'created_at', 'PgTimestamp', 'organizations_created_at_unique' ], [ 'updated_at', 'PgTimestamp', 'organizations_updated_at_unique' ],...

megmut

8/27/2023

Nested Relations Where has Zero Typings :confused:

Hey guys - first post so please let me know if this isn't the wrong place or I'm doing something wrong. Anyhow, I'm trying to order a simple nested relation in a query: ``` await db.query.channel.findMany({ with: {...

Fabian B.

8/27/2023

on every `migrate()`: schema "drizzle" already exists, skipping

Hi there! I have setuped a postgres DB. Everytime I call migrate(), it works and migrates, but returns these two warnings: ```bash { severity_local: 'NOTICE',...

Matoslav

8/27/2023

onConflictDoUpdate() ID entry

How to get ID of entry in onConflictDoUpdate, where conflict appeared?

bkyerv

8/27/2023

Strugling to use composite key in schema

How do I represent composite primary key in drizzle way (sqlite) below migration query? I red the docs but failed miserable in trying to implement it. ```CREATE TABLE QuestionSetMapping ( SetID INTEGER, QuestionID INTEGER, PRIMARY KEY(SetID, QuestionID),...

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!