Drizzle Team

DT

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Join

Argument of type 'SQL<unknown>' is not assignable to parameter

I have the following: ```ts const projects = await db .select()...

Stream select

Hey! I'm doing a large select and I'm wondering how to stream the responses for MySql

documented types for the return of `drizzle()` and the return of `mysqlTable()`

my most pressing need is documented types: https://github.com/drizzle-team/drizzle-orm/issues/273 Specifically the 2 that are holding me up right now are how to pass a the mysql2 version of drizzle() (aka a db reference) and a model reference (the result of mysqlTable()) around through my app...

.andWhere()

I know that .andWhere() isn't a function, but I'm wondering if there's a way to start a query in one function, and return it. And then have the receiver be able to continue to add to the where clause? Something like: ```ts...

Example failed to run: `pg` does not provide an export named `Pool`

I'm trying to run the example from the README file. I made a minial version, installed pg, @types/pg, drizzle-orm and drizzle-kit and tried to run it via tsx. This is my stripped down example: ``` import { drizzle } from "drizzle-orm/node-postgres";...

how do you pass a query in a typesafe way?

Let's say i want to paginate a query, so I'm going to pass a query such as this to a pagination function
db.select().from(users).where(like(users.email, '%@gmail.com'))
db.select().from(users).where(like(users.email, '%@gmail.com'))
...

help with column builder types

As I play around with learning drizzle, I wondered if I could generate a drizzle schema from a master schema. I'm very close to being able to do that. As you can see in this repo I created: https://github.com/rizen/drizzle-icing/blob/main/user.ts The code works perfectly, but problem is that when I try to use InferModel to get the column types from my schema, I'm getting ```ts...

migration on mysql errors

I've written this migrator: ```ts import { migrate } from 'drizzle-orm/mysql2/migrator'; import { drizzle } from 'drizzle-orm/mysql2';...

error: there is no transaction in progress

I created a drizzle table: ```ts export const passwordTypeEnum = pgEnum('passwordType', ['bcrypt']); export const useAsDisplayNameEnum = pgEnum('useAsDisplayName', ['username', 'email', 'realName']);...

Having a problem just connecting with drizzle

Howdy, I just found out about drizzle and thought I might give it a try, but unfortunately I'm having trouble just getting the example working from the documentation. I've created this sample file: ```ts...