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!

11/13/2023

Omit fields on "$inferSelect"?

Let's say I have a table with 5 columns, I want to do type TableType = typeof theTable.$inferSelect; but omit some fields. How do I do that?...

itsyoboieltr

11/13/2023

Full-text search on jsonb column

Hey, I was experimenting with full-text search and drizzle. I saw in the docs an example for full-text search https://orm.drizzle.team/docs/sql, but this seems to only work with text columns. How would I convert the where statement to make it work with jsonb? @Angelelz

Sadra

11/13/2023

Connecting Remote Drizzle Kit Studio to a Server

Since the studio moved to a local HTTPS address, I can't access it on my Ubuntu server. Previously, I used a port to access Kit Studio, but now it's a local address. What should I do?

CharlesCharlieCharles

11/13/2023

Error [ERR_PACKAGE_PATH_NOT_EXPORTED]

I'm getting the following error using node / nodemon / ts-node. Just started happening, never had this issue before: ``` Error [ERR_PACKAGE_PATH_NOT_EXPORTED]: Package subpath './index' is not defined by "exports" in /Users/bob/Public/Code/api_node/node_modules/drizzle-orm/package.json at new NodeError (node:internal/errors:387:5)...

nochs

11/13/2023

Define a index with condition

I'm trying to define index with where but migrations generated in index without where condition. Is there an ETA of when this feature will be supported?

davydabeast

11/13/2023

Cloudflare D1 TypeError: Cannot read properties of undefined (reading 'prepare')

Trying to query a D1 sqlite database and seem to be running into this error, sounds like the parser is tripping up on itself I have been debugging for a few hours and can't seem to figure out what is wrong has anyone seen this before?

Emerson

11/13/2023

Error Parse BigInt

When I've a blob big int column and I try to select or returning the data, my bun execution is terminated because the parsing is crashed. https://github.com/emersonlaurentino/drizzle-bigint...

Martacus

11/12/2023

Having trouble writing my sql statement in drizzle. Want to join two variables

I am trying to execute this sql statement with drizzle ``` SELECT er.*, e1.name AS entity_one_name, e2.name AS entity_two_name FROM "public"."relation" er JOIN "public"."entity" e1 ON er."entityOneId" = e1.id...

Paul

11/12/2023

How to implement Row Level Security in Postgres?

In my chat app, I have chats and messages. There are multiple messages in each chat. I'm trying to prevent user1 from editing user2's messages. ChatGPT suggests row-level security like the following ```sql...

TheStockBroker

11/12/2023

Get the result raw sql

I love drizzle and everything it does, but it cannot integration with a certain tool I'm using in a comfortable way.. I wanted to know if it's possible to create a query or whatever and reach the inner final sql as raw string?

Alex.dev

11/12/2023

Set onDelete while using foreignKey function

Hi. I'm trying to set onDelete action with new "custom name" foreign key config. The problem is that I can not find such option. While FK defined through references it's possible as a second argument. Any ideas?

BaNuni

11/12/2023

Upsert Multiple using EXCLUDED

hey there - I want to upsert multiple values and overwrite certain fields in case of conflicts. using plain SQL it'd be something like this: ```sql insert into "surveil" ("id", "last_seen", "name") values...

-TheG-

11/12/2023

defineConfig, Cannot find module 'drizzle-kit/utils'

when using the new way to define drizzle config get error Cannot find module 'drizzle-kit/utils' or its corresponding type declarations.ts(2307) using drizzle-orm: 0.29.0 drizzle-kit: 0.20.1...

Penners

11/12/2023

SQLite composite primary key error.

I'm trying to add a composite primary key for the following table but I'm getting a type error. I've referenced the docs and this looks to be the correct syntax so I'm just a little confused. https://orm.drizzle.team/docs/indexes-constraints#composite-primary-key

    "drizzle-orm": "^0.28.6",

    "drizzle-orm": "^0.28.6",

...

myles

11/12/2023

WITH RECURSIVE support… or suggestions for how to approach?

Hi. I'm absolutely loving Drizzle after a little while in both Prisma and TypeORM and 15 years of Rails + ActiveRecord. I have the following query that uses WITH RECURSIVE. I'd love to use Drizzle's query builder but I cant see how I might tackle that. Am I right in thinking that this is going to need to be supported in the select helper https://orm.drizzle.team/docs/select#with-clause ? ...

cssetian

11/12/2023

How to implement a 'check' constraint

I'd like to implement a 'check' constraint that implements these psql table constraints below. What is the best way to add this constraint in native SQL alongside my drizzle table definitions if it is not yet supported as a native Drizzle piece of functionality? -- User Table CREATE TABLE "User" ( UserID UUID DEFAULT uuid_generate_v4() PRIMARY KEY,...

roman910

11/12/2023

Add descending indexes in mySQL schema

I do not find how to add a descending index from a schema in mySQL. I know I could always execute the following line manually:

ALTER TABLE tablename ADD index col_desc_idx(col desc);

ALTER TABLE tablename ADD index col_desc_idx(col desc);

But I'd really like to be able to include it in the drizzle-kit push command because I know I will forget at some point otherwise....

roman910

11/12/2023

Duplicate indexes when using `serial('').primaryKey()`

I have observed than whenever I use serial('id').primaryKey() in one of my tables, the primary key index gets duplicated. ```text mysql> SHOW INDEXES FROM tokens; +--------+------------+--------------------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+...

11/11/2023

Multiple .where() calls with $dynamic not working

When adding multiple .where() calls to a query created with .$dynamic() only the last .where() call gets applied to the resulting query. I put together the following example that adds two .where() calls but only the last one is applied. You can see the resulting query in the console. https://codesandbox.io/p/sandbox/charming-herschel-8c9rk6?file=%2Findex.js%3A7%2C11...

potato

11/11/2023

Can't figure out this simple one-to-many relationship

Hey, so i have two tables, a patient one and a village one. I just want to define a simple one-to-many, one village for many patients, what am I missing here? My villageRelations is throwing type errors `export const patient = mysqlTable("patient", {...

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!