Drizzle Team

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

Join

Drizzle Team

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

Join

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).

yikkwong

10/28/2023

Broken query when parametized query is undefined

Postgres dialect generates broken query when one of the parametized query is undefined

sql`SELECT 1 FROM test WHERE a = ${true} AND b = ${undefined} AND c = {1}`

sql`SELECT 1 FROM test WHERE a = ${true} AND b = ${undefined} AND c = {1}`

generates

SELECT 1 FROM test WHERE a = $1 AND b = AND c = $2;

SELECT 1 FROM test WHERE a = $1 AND b = AND c = $2;

...

Nelson Sousa

10/27/2023

How to filter query based on children table?

Hi friends, first time using Drizzle so be gentle, this question may be dumb. I designed a model where I have a country table and a country_language table, as you can see in the attachment. Let's say that I want to return the country which has the slug (from the country_language table)="portugal-en". How can I write that expression?...

lolmaus (Andrey Mikhaylov)

10/27/2023

Acceptance testing practices? In-memory Postgres mock for high-speed acceptance testing?

Hi! I'm using Drizzle with SvelteKit and Vercel Postgres. I would like to do extensive acceptance test coverage. I want my tests to be: * very fast: Postgres speed is a drag when you have thousands of test cases; * very reliable: not prone to network hiccups, paywalls, etc;...

Hussein

10/27/2023

example on users table with followers and follows?

I need

lois

10/27/2023

Drizzle:push cannot read properties of undefined(reading 'name')

Database: Planetscale Hi team, I tried to run drizzle:push but it returns an error of TypeError: Cannot read properties of undefined (reading 'name') I have checked my tables and every columns has a name... Details of error be like ...

HuskForever

10/27/2023

Circular dependent table types.

How to solve typing issue here (it gives me ANY type in both tables). Also i need reference in order to do operation like (onDelete, onCascade)

PWSey

10/27/2023

Neon DB pooled connection prepared statement error

When using Neon DB with pooled connection it gives the following error: ``` - error node_modules@neondatabase\serverless\index.js (1539:47) @ execute - error NeonDbError: db error: ERROR: prepared statement "s10734" does not exist ...

Thogn

10/26/2023

How to define schemas for friendship table

Just wondering whether or not i should define friendshipsRelations table. Relation: A user can have many friends ``` export const usersRelations = relations(users, ({ many }) => ({ friendships: many(friendships),...

Cetus 🔛🔝

10/26/2023

drizzle-zod refine enum

Here's my users table and the schema generated with drizzle-zod that I want to modify. As you can see, the role column is an enum, but I want to modify the error message as I did with email and password. I've tried several solutions but nothing works, could you help me? ```ts export const roleEnum = pgEnum('role', ['USER', 'ADMIN']) export const users = pgTable('users', {...

CharlesCharlieCharles

10/26/2023

It seems that the libsql server is outdated

I'm sporadically getting this issue whilst connecting with turso. Sometimes call is successful and sometimes I get following error. Not sure if this is drizzle or turso issue LibsqlError: SERVER_ERROR: Server returned HTTP status 404. It seems that the libsql server is outdated, please try updating the database. at mapHranaError (/Users/rob/Public/Code/api_node/node_modules/@libsql/client/lib-cjs/hrana.js:287:16) at HttpClient.execute (/Users/rob/Public/Code/api_node/node_modules/@libsql/client/lib-cjs/http.js:84:48)...

Hussein

10/26/2023

"Seems like the schema generic is missing - did you forget to add it to your DB type?"

how to fix this... i need to use db.query

hachoter

10/26/2023

migrate function hangs without any result

I have this in my migrate.js file ``` // @ts-check ...

Yehuda Krupka

10/26/2023

Select with a join that returns eagerly loaded submodels

hey all, is it possible to do a select on a model using a join and return the model with eagerly loaded fk models. Something like this where I'm joing wharehouse to location to filter on location.city but i want the location to be returned nested in wharehouse not alongside ` getWarehousesInCity: publicProcedure .input(z.string()) .query(async ({ctx, input}) => { return await ctx.db.select({...

jack

10/26/2023

role 'postgres' does not exist

Hi, Trying to run db:push with a postgres db, gettign this error: ```No config path provided, using default path Reading config file '/Users/johnbogart/RCOOP/com/drizzle.config.ts' error: role "postgres" does not exist...

Samir

10/26/2023

How would I get 2 unique values?

I got my post likes table. ```ts export const postLike = sqliteTable( "post_like", {...

zendev

10/26/2023

Infinite scroll w/ Drizzle + tRPC

Has anyone implemented infinite scrolling/pagination using Drizzle? The example in the tRPC docs uses Prisma, which has a built-in cursor parameter for pagination. What would one use for Drizzle? https://trpc.io/docs/client/react/useInfiniteQuery...

LouieMartin

10/26/2023

HRANA_WEBSOCKET_ERROR: Unexpected server response: 404

```ts // ./drizzle.config.ts import type { Config } from "drizzle-kit"; export default {...

Dayblox

10/26/2023

URL_INVALID

The env variables are defined when using bun run push but not when using npm run push or pnpm run push, resulting in LibsqlError: URL_INVALID: The URL is not in a valid format because url is undefined?authToken=undefined ```TS export default { schema: "./src/db/schema.ts",...

Solution:

bun parsed the .env file automatically but node does not. You need you use dotenv or something similar when using pnpm/npm/yarn

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!