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!

7/5/2023

PostgreSQL RQB truncation

I have a fairly nested query using the RQB and I'm running into issues where PostgreSQL truncates the identifiers used to 64 characters (as it normally does). In wondering if it makes sense/if there is a way to make the identifiers used in the RQB always fit into the 64 character limit because the truncation results in duplicate identifiers and makes the query fail. I am happy to send an example schema/error if that makes anything easier.

Liam

7/5/2023

Drizzle Count # of Records

What would be the best way to count records in drizzle? Thanks!

Mikey

7/5/2023

Spatial Query in Drizzle using MySQL

I'm not able to find an example of how to create a Spatial Index as explained in this tutorial. https://www.endpointdev.com/blog/2021/03/spatial-queries-with-mysql/ Can I please get some help with how to do the following in Drizzle ORM?...

patochem

7/5/2023

drizzle-orm doesn't compile

I've just created a blank typescript project for nodeJs and installed the library as specified in Drizzle doc. In the index.ts file of the project, I have the following code: ``` import { integer, pgTable, text } from 'drizzle-orm/pg-core';...

Toavina

7/5/2023

drizzle migration on nextjs

I am getting this error while using drizzle migration as show in the documentations. I have already set my compiletarget to es2017 and enabled topLevelAwait feature but still giving this error NB: everything works if I comment out the migration code on my drizzle db connextion setup...

mgarf

7/5/2023

findmany doesn't easily allow gte or lte?

When looking at the typescript definition of the operators in the findmany where clause I see: ``` declare const operators: { sql: typeof sql;...

cvr

7/4/2023

How to set a default timestamp_ms for sqlite

How do I make a default timestamp_ms? ```createdAt: integer("createdAt", { mode: "timestamp_ms", })...

dandadan

7/4/2023

Migrations not being applied (drizzle-orm/node-postgres/migrator)

im kind of struggling with migrations... i have the following migration index.ts which i run whenever i generate a new migration ```ts import { drizzle } from "drizzle-orm/node-postgres"; import { migrate } from "drizzle-orm/node-postgres/migrator"; import pg from "pg";...

makaron pelnoziarnisty

7/4/2023

Delete limit

Hi, how do I delete just 1 row from a table?

// Example:
db.delete(dogs).where(eq(dogs.breed, 'husky')).limit(1)

// Example:
db.delete(dogs).where(eq(dogs.breed, 'husky')).limit(1)

...

miigaarino

7/4/2023

Many to many - Planetscale

Anyone here has an example of declaring many to many relationship when using Planetscale? https://orm.drizzle.team/docs/rqb#many-to-many When using Planetscale this section doesn't work at all...

Liam

7/4/2023

Inserting with Relation

Hi, What is the way of inserting a new record with a relationship in Drizzle. I understand that Prisma abstracts this away as if you are inserting everything as once but under the hood it breaks it up into multiple queries. Is there anything like this in drizzle?...

.deini

7/4/2023

sql escaping on where

Trying to do the following:

where: sql`unaccent(${users.fullName}) ILIKE unaccent('%${input.query}%')`,

where: sql`unaccent(${users.fullName}) ILIKE unaccent('%${input.query}%')`,

...

Eternal Mori

7/3/2023

Broken typescript in select

Whatever I put inside the select function. it will generate this typescript error: I am using the lastest ts- and drizzle versions....

jakeleventhal

7/3/2023

Why is introspecting creating tables that didn't previously exist

More context here: https://github.com/drizzle-team/drizzle-orm/issues/847

James

7/3/2023

Passing SQL functions to insert

Is there any way to pass a SQL function like gen_random_uuid() to the insert function, for a specific (non-primary ID) column? Something like concat('foo_', gen_random_uuid()) for example.

Gerbuuun

7/3/2023

Drizzle-kit database push connection error

When trying to run drizzle-kit push:mysql to push my schema to Planetscale, I get the following error. Am I missing something? ```sh drizzle-kit push:mysql...

Zee_008

7/3/2023

Typescript error when importing the planetscale-drizzle db instance.

my db is hosted on planetscale and im trying to do the setup as explained in the drizzle docs but when I import db instance i get the following error. My code ```js import * as schema from './migrations/schema';...

Jérémie

7/3/2023

Mapped column name and relation with the original name

Hi, I am taking over an old project and have found an issue, I'm not sure if I should file it as a bug: I have two MySql tables here is the oversimplified version: ``` events - id...

interdrifter

7/2/2023

How to properly do foreign keys in schema with PlanetScale?

I'm aware that foreign key constrains aren't supported, but foreign keys themselves are. push: ```json sqlMessage: 'VT10001: foreign key constraints are not allowed'...

Hegar

7/2/2023

Typescript path alias not working properly

I'm new to Drizzle, but I'm not able to use the path alias on schema files. Using absolute paths on the imports works without a problem, but when using any @/... path everything breaks. Right now I'm working around this problema by denying @/ imports wit ESLint but that is not a good solution long term....

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!