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

Reko

12/25/2024

Accidentally deleted my _journal.json file

How can I re-generate it?

McNugget

12/25/2024

db.insert not respecting order of rows

Having an issue where I'm inserting data into the db via a for loop. However the data gets inserted in a different order. Any ideas? ```await db.transaction(async (trx) => { await trx.delete(sessionTypes).execute(); console.log('after del', await trx.select().from(sessionTypes).execute());...

M Zeeshan

12/23/2024

nested select type issue

hello there... this code returns desired restuls but i have type issues ```ts await db .select({...

thomasls-lha

12/23/2024

How to connect to Oracle database?

Is there any documentation to guide users how to connect to Oracle? I can't find it anywhere.

andystevenson

12/22/2024

attach

suddenly getting CORS errors running studio in Chrome.

installed drizzle-kit@0.30.1 with binaries:
 - drizzle-kit
installed drizzle-orm@0.38.2
installed @libsql/client@0.14.0

installed drizzle-kit@0.30.1 with binaries:
 - drizzle-kit
installed drizzle-orm@0.38.2
installed @libsql/client@0.14.0

...

Forceres

12/22/2024

Is it possible to create generic schema proxy?

<TSchema extends Record<string, unknown>, TDb extends PostgresJsDatabase<TSchema>>

<TSchema extends Record<string, unknown>, TDb extends PostgresJsDatabase<TSchema>>

something like that should be ok, but I got errors in type: ```typescript...

David L. Bowman

12/22/2024

What's the best practice for selecting an item only if a nullable field is not-null?

In this case, I have a type Patient which has a nullable field called stripeCustomerId. I create the patient earlier, and when I collect customer information, I add to it. Although, sometimes, I want to getPatient but I want it to throw an error if stripeCustomerId or another similar field is missing. I'd also like to handle errors in my getPatient function, so I don't have to handle errors everytime I call it. I created this, but I'm wondering if there's a better way. I'm still a novice....

DiamondDragon

12/21/2024

Drizzle produces wrong branded type using Zod

It appears using brands with Drizzle Zod doesn't work correct? ```ts //? Files *// const fileIdSchema = z.string().uuid().brand<'FileId'>() type FileId = z.infer<typeof fileIdSchema>...

Baron_ThoughtEvolution

12/21/2024

Unable to use db.query... functions

Following is the documentation for performing queries:

import * as schema from './schema';
import { drizzle } from 'drizzle-orm/...';
const db = drizzle({ schema });

...

brynthrax

12/21/2024

Nested relation filtering

We have a user table (id, name, role…) and section table (id, name…), bridged by a user_section table (userId, sectionId). Hence, a many-to-many relationship. How can I accomplish in drizzle wherein I query for a section, including users (and its fields) under it, but only users with the role “Student”? Right now, I can only filter through userId and sectionId in the relational query API (see screenshot)....

Tomato

12/21/2024

Drizzle ORM - Query on the same file

const users = (name: string) => pgSchema(name).table('users', { id: serial('id').primaryKey(), name: text('name').notNull(), invitedBy: integer('invited_by').references((): AnyPgColumn => users.id), });...

devlsh

12/21/2024

`drizzle-zod` and `z.nativeEnum()`

struggling to get drizzle-zod to work with z.nativeEnum after upgrading - as per the image, if i provide z.nativeEnum during createSelectSchema, it overrides all other types generated by drizzle-zod (see last 4 lines)

jack

12/21/2024

[postgres] composite key does not result in constraint creation

i have this schema, and even though I've got a pretty basic composite primary key, whenever i go into a visual view of my db, no constraint is actually created. with other tables with single column pk's, it creates the constraint like ${tableName}_pkey, but in this case when i look on Neon there's no constraint here ```ts export const preferenceTable = createTable( 'preference', {...

12/21/2024

Self referencing composite primary key table

I'm trying to define a table where each organization can define a parent-child set of locations. Each location has a composite primary key (org, id) but i can't seem to get the self referencing foreign keys to work. Is there a way to accomplish what i'm trying to do? here's my code. Thanks! ``` export const locations = pgTable( 'locations', {...

WNH

12/20/2024

CORS error when trying to open Drizzle Studio with Supabase

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://localhost:4983/. (Reason: CORS request did not succeed). Status code: (null). https://localhost:4983/ just shows 404 Not Found I'm using "drizzle-orm": "^0.38.2" and "drizzle-kit": "^0.30.1". My browser is Firefox Developer and I'm on Linux. My Supabase database settings enforce SSL so not sure if that's related....

plurk

12/20/2024

query where condition on foreign key relation

i have a table with a foreign key (one relation) to another table: ```export const mapRegions = sqliteTable( 'map_regions', { id: integer('id').primaryKey(),...

Coder

12/20/2024

sqliteTable is deprecated

Apparently sqliteTable is deprecated and I couldn't find the replacement for it.

Desch

12/20/2024

Drizzle Kit Schema Diff?

Is it possible to use drizzle kit to detect if there are schema differences, without actually applying them? I'd love to create a CI/CD job that looks at the production schema and blocks merging new code in until any schema changes have been published.

wowzee101

12/20/2024

drizzle-zod is not sending custom message upon validation

I have created the following loginValidationSchema which I call in a validateData middleware inside my routes. I was expecting the custom error message to be sent to user whenever the user does not provide a value but it is not working \ zod-schema ```export const loginUserSchema = createSelectSchema(user, { email: (schema) =>...

cmrtk

12/19/2024

Driver error callback

I'm trying to upgrade to 0.3.4 with the new drizzle client and am wondering how you are supposed to access driver callback events like 'error' or 'end'. My current code looks like this: ``` const pg = new pg.Client(...); const db = drizzle(pg, { schema }); pg.on("error", () => ...)...

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!