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

Infinite loading of queries

Hey! I am trying to use Drizzle with Neon Postgres. I made the migrations, ran them and the tables are there. Now whenever I select or insert data, the request just hangs and does not proceed. I am using serverless neon package since I will be running in Vercel Edge Functions. Here is the code: ``` import {drizzle} from "drizzle-orm/neon-serverless"; import {Pool} from '@neondatabase/serverless';...

bret_pat

8/9/2023

Share drizzle-zod schemas with the frontend

I'm wondering how I should use drizzle-zod generated schemas without leaking the actual implementation of my tables to the frontend? I'm assuming by exporting drizzle-zod schema's and letting the frontend consume them, I'm actually bundling the definitions inside of my FE as well. Is there a way to avoid this? Or frankly, should I not care?...

rushil1o1

8/8/2023

Suggestion: Add warning when adding breaking changes.

For example: adding a non null field without a default value

Andrey Los

8/8/2023

There is not enough information to infer relation. What am I doing wrong?

I have such a setup yet I'm getting There is not enough information to infer relation "users.organizations". What am I missing? (below are all my relations) It's a many-to-many relationship. I also registered all that stuff into the schema (below) ```ts...

wdbsb

8/8/2023

Baseline for introspected schema

I've used "drizzle-kit introspect" to get my initial schema and migration files. How do I now mark that initial migration file as applied (create the _drizzle_migrations table)?

Alex.dev

8/8/2023

Identifier is too long (should not exceed 63 characters)

Hello guys. I've got too long constraint id generated by drizzle kit in migration files. Is it safe to apply such migration? Maybe there is a way how I can set custom constraint id for some tables? Here is my schema ```TYPESCRIPT export const customerVehicleClaims = pgTable('customer_vehicle_claims', { claimsid: text('claimsid').primaryKey().notNull(), customervehicleid: integer('customervehicleid')...

azn4lifee

8/8/2023

How can I declare a relationship with a SELECT statement?

I have 2 tables, iot_device and iot_device_status, where the status table saves all current and historical statuses of each device. I like to join the tables together as so: ``` SELECT i.id, i.name, data.lost, data.created_at FROM iot_device i INNER JOIN LATERAL ( SELECT * FROM iot_device_status s...

ccabd

8/8/2023

Find IDs from a list which do not exist in table

As the title says, i'm trying to filter a list of given IDs (could be hundreds) into a list of IDs that do not exist in a table (could have multiple thousands of rows). My research suggests that I should be doing something like this: ```sql select *...

mr_pablo

8/8/2023

With condition

I am using db.query to fetch some data with a lot of related data. One of the with statements is only applicable if a column value from another joined table is a certain value. Does with support a where that uses another joined tables data? If so, what does the syntax look like?...

bombillazo

8/8/2023

Can Drizzle call RPC functions in the Database?

I could not find anything in the docs on the topic.

bombillazo

8/8/2023

How to integrate Drizzle into Supabase project

Hey there, we're using Supabase for our project an unfortunately, it doesnt support transactional logic using their DB client. We are looking for an ORM that is easy to integrate to the existing Supabase-managed schema so we can run transactions using TS from our edge functions. How easy is it to setup Drizzle with an existing schema? Im managing migrations myself so Im more interested in getting all the good TS intellisense and typing directly in our Deno functions without having to now manage 2 DB libraries. Are there guides on how to do this?...

azn4lifee

8/8/2023

How can I derive the database type with schemas without instantiating it?

In our data service layer, we are looking to require a drizzle db parameter for our functions to accommodate multitenancy. However, we still want this parameter to be typed with our schemas. How can I achieve that?

Ben Quan

8/8/2023

Simple relational query in sqlite

I am trying to follow the documents but using BetterSqlite3. I have the schema shown in https://orm.drizzle.team/docs/rqb: ``` import { integer, sqliteTable, text } from 'drizzle-orm/sqlite-core';...

anon64942495

8/8/2023

How to avoid Inserting invalid values into a table with relations with mysql?

Using planetscale so I cant reference other columns My schema: ```ts export const mainTable = mysqlTable("main",{...

skuse

8/8/2023

Cant drop key mysql

When adding a new key and pushing to DB, it will not allow you to drop the key and push to db.

barry

8/7/2023

Weird type errors when running code

https://gist.github.com/barrybtw/cf7dfd850172bcb6e0763f567bfd1c6f

Solution:

Disabled minifying and dts creation with tsup and it's not yelling anymore

tunisoft

8/7/2023

Typescript enum to pgEnum

I have this code ```ts export enum field_types { numeric = 'numeric', text = 'text',...

Ramazan

8/7/2023

Cast columns in relations

A great feature of drizzle's relational queries is that they don't actually require a foreign key, which provides a great amount of flexibility in querying your data. However, it doesn't seem like there is currently a way to cast the fields so that their types match. Something along the lines of ```typescript export const actionRelations = relations(actions, ({ many, one }) => ({...

tmcw

8/7/2023

Is there a simpler way to get an enum type than (typeof enumType)["enumValues"][number]?

Pretty quick question (and maybe quick answer) - we have this pattern in a few places and it looks a bit verbose.

Pillow

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

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!