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

Populating a relational database

I've been over the docs and cant find anything regarding to populating relational databases. See attached images of my current setup. Eg when data is created, the columns where the relation should be is empty (the users "notifications" column is empty when a notification is created. Is this done automatically of do I need to set this up manually when the data is created?

focused_morning

10/31/2023

How do I write a trigger??

Not sure how this might happen, but If I needed to write a trigger how would I do this in Drizzle?

focused_morning

10/31/2023

How can I accomplish this in a schema?

I'm trying to make it so only one record with this itemId can have the status "ACTIVE" at a time. Something like this: ALTER TABLE ItemMintPermission ADD COLUMN ActiveItemID AS (CASE WHEN status='ACTIVE' THEN itemId ELSE NULL END) VIRTUAL; ...

Aboud

10/31/2023

Drizzle with NextJS 13/14 revalidateTag ?

Hey everyone, has anyone tried passing tags to Drizzle db client to work with NextJS 13/14 revalidateTag ? I'm querying in an RSC. It works with fetch API calls, but was wondering if Drizzle or an clients (I'm using neon serverless) have fetch under the hood and a way to pass { next: tags: ['mytag'] } options in...

Septatrix

10/31/2023

`SqliteError: near "(": syntax error` when using `notExists`

It seems like queries with notExists clauses add a pair of parentheses too many:

``ts
db
    .select({ foobar: sql<number>

1` })...

danecando

10/31/2023

Issue filtering by date equality

I'm running into an issue where I don't get any results for a value with matches in the db. Example query using date string directly from db gives me two results: ``` SELECT id, starting_at...

VictorTimi

10/31/2023

Infinite scroll on Drizzle ORM not working

Please I haven't gotten the solution on how to solve the Cursor issue on Drizzle ORM. I was able to use a custom limit by using the Slice method on Javascript, however for the cursor scroll I still dont know how to add a cursor here: ``` const selectedMessage = limitUserMessage.map((_message) => ({ isUserMessage: _message.isUserMessage!,...

BaNuni

10/31/2023

Using Query Syntax to filter by FK's field

hey there, I have a schema of users and their pets name and type. a user can only own one pet, and a pet could have several owners. how would I use query syntax to get all the users that own a dog (type === 'dog')? ```ts export const users = pgTable('users', { id: serial('id').primaryKey(), petId: text('petId'),...

hugo

10/31/2023

[SOLVED] How to add new column?

Hello! Any ideas how to add a new column to an existing table? What I did so far: 1. Updated the schema to add a new column: ```...

ang

10/31/2023

nextjs, mysql2, await is only valid in async functions error

Hi, I'm new to nextjs and drizzle and I'm getting this error when trying to insert and delete from a mysql db on a client connection. All my other await calls are wrapped in async functions so I'm fairly certain this is the cause of the error. When I switch to using a pool connection I no longer run into the issue but I'm not sure if that's the best way to go about doing it. Like I said I'm really new to this so if I could get some help/explanation for how this is supposed to work I'd really app...

algoguy

10/30/2023

How to create jsonb attribute index in drizzle

Suppose I have a table ``` Books author: varchar extra: jsonb...

francel

10/30/2023

yesterday, I tried to migrate from prisma to drizzle, but ultimately, I went back to prisma

yesterday, I tried to migrate from prisma to drizzle, but ultimately, I went back to prisma, because when I try to retrieve a list of things with its include relationships, it doesn't work.

Poulet

10/30/2023

Can't use ts alias in schema related files with drizzle-kit

Hey 👋🏿 I have a @ -> src path alias setup in my tsconfig. I made use of it in one of my schema files: ex: import { tableA } from '@/lib/entities/tableA/schema whenever I run drizzle-kit generate:XX, I get this error: ...

PWSey

10/30/2023

Using db. causes the whole app to hang forever.

drizzle.config.ts ```ts import type { Config } from "drizzle-kit" import "dotenv/config"...

Screw

10/29/2023

Using arrayContains with a jsonb postgres type

arrayContains(matches.teamA, [id])

arrayContains(matches.teamA, [id])

teamA is a jsonb type of string[] i want to see if the id exists inside whats the best way of doing this...

10/29/2023

FK identifier will be truncated... how to specify my own?

Im running into a warning because the FK constraint identifier is too long and will be automatically truncated. I would prefer to specify my own indentifier instead of it getting truncated... Is there a way to achieve this? any help is appreciated! ❤️...

Mark L

10/28/2023

How are you supposed to do multiple filters with Drizzle?

I've been using Drizzle for my project for a few weeks now. But I have run into a nightmare trying to use multiple filters with Drizzle. I have a table "events" I need to filter based on: - Event name (if a search query is provided) - Dates...

Scai

10/28/2023

Query only one item from Many-To-Many

I would like only to take one stat not all the arrays. Is there a method to replace limit with something which returns only one item. ```ts const res = await ctx.db.query.servers.findMany({ with: { game: true,...

Scai

10/28/2023

Error on db:push

Incorrect table definition; there can be only one auto column and it must be defined as a key

peli

10/28/2023

Column name alias

Is there a way to create column name alias in SELECT queries ? like (name as petName).

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!