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

Relational queries: many-to-many

How to exclude xId fields from findFirst | findMany method or i just need to use "Magical sql operator" :D. And can I get rid of the usersToStudios field? ```js...

tea bone

8/7/2023

After upgrading to 0.28.0 from 0.27.2, it is unable to infer the array type

Here is my schema definition: ```js const badgeTable = pgTable( "badge", {...

binajmen

8/7/2023

Is it possible to have nested values when doing a leftJoin?

```ts // returns nested results export async function getLoans(spaceId: string) { return db.query.loans.findMany({ where: eq(loans.spaceId, spaceId),...

moroshko

8/7/2023

How to separate Dev data from Prod data with one Postgres instance?

I'd love to use Drizzle with Vercel's Postgres Storage (Neon). On the Hobby plan, Vercel offers only one Postgres instance. I realize it's not a Drizzle specific question, but would love to know what's the easiest/best practice these days to separate Dev data from Prod data if all I have is a single Postgres instance? Any references to publicly available code examples would be hugely appreciated 🙏...

Chris Pratt

8/7/2023

One-to-one relations

So, uh, I can't figure out why i keep getting this annoying message:

ERROR:  could not identify an equality operator for type json at character 716.

ERROR:  could not identify an equality operator for type json at character 716.

...

Oreki

8/7/2023

relations help

how can i have a many-to-many relation for example a user can have multiple followers and can follow multple users ```js export const users = pgTable( 'users',...

roob

8/7/2023

Do I need to close the DB connection after running a script using drizzle?

I have a very simple script to import some CSV data: ```typescript import { System } from "@foo/core/system"; import { readFileSync } from "fs"; ...

PizzaConsole

8/6/2023

Error introspecting Supabase auth schema

When trying to introspect the Supabase auth schema I get this error: ``` C:\app\node_modules.pnpm\[email protected]\node_modules\drizzle-kit\index.cjs:12431 name: tableCompositePkName[0].primary_key,...

pandareaper

8/6/2023

Issues with timestamp precision with postgres

Hi, I posted the other day about a bug with the date, but it seems this issue runs deeper. https://discord.com/channels/1043890932593987624/1043890932593987627/1136224592764080268 I am also using timestamp which has a similar issue, when using mode string drizzle is returning a Date instance (conflicting with the generated types)...

Fyzz

8/6/2023

Relations not building into type

Im having an issue where the relations types are not correctly being tied to the table

``ts
const todaysVisits = await db.query.visits.findMany({
    where: sql

DATE(${visits.date}) = ${date.format("YYYY-MM-DD")}`,...

gmaclennan

8/5/2023

JS API for generating CREATE TABLE sql?

I saw a message that a JS API is coming for drizzle-kit, which will be great. In the meantime is there an existing method to generate the CREATE TABLE sql from table schemas? My use-case: I'm writing tests, for which I would normally use an in-memory sqlite database, but I need to generate the tables in the DB as I would with drizzle-kit push....

lizarddapp

8/5/2023

Dont throw error if the relations is not correct

const posts = await db.query.posts.findMany({ with: { comments: true, }, });...

tea bone

8/4/2023

tsc fails to build due to errors

When I run tsc to compile the project to javascript, I am getting the following error: ``` Found 4 errors in 2 files. Errors Files...

rubberduckies

8/4/2023

trying out neon.tech should i use "Pooled Connection"?

the title says it all, i'm going to try moving to Neon database (postgres) but i'm not sure if i should use a pooled connection or not. Thank you...

bkyerv

8/4/2023

Discrepancies Between Raw SQL Queries and ORM Operations: Why Might They Behave Differently?

What could be the potential reasons for a query executed using the execute method to function correctly, while the same query using an ORM approach (i.e., db.insert().values(), etc.) doesn't produce the expected results or doesn't work properly? First screenshot doesn't work, while second one works properly

hachoter

8/4/2023

I need help generating a query for a schema

Hi guys I have the following schema ```ts export const companies = pgTable('company', { id:serial('id' as string).primaryKey(), name:varchar('name' as string).notNull(),...

DominusPrime

8/4/2023

Best way to omit a field (e.g. password) after findMany from schema?

Let's say we have the following: ```typescript export const User = pgTable( 'user', {...

nqhtrung

8/4/2023

How to implement interface for table?

Say I have an interface of User ``` interface User { id: string,...

skuse

8/4/2023

onDuplicateKeyUpdate

Is this the correct way to use this method? Can't find documentation ```db .insert(schema.item) .values({...

Toavina

8/3/2023

drizzle weird error message on database operation

I am getting this weird error when doing database operation

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!