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/15/2024

Error in mysql migration

using "drizzle-orm": "0.31.2", "drizzle-kit": "0.22.8", drizzle.config.ts file, it is in root folder of project ```import {defineConfig} from 'drizzle-kit' ...

xxxxx

7/15/2024

How to make one object have 2 different relationships with another object.

I have 2 tables Product and Media. The product has a thumbnail and also images of the product. The thumbnail is one media and images are many media. So in short I have to have one-to-one relation between Product.thumbnail and Media, and a one-to-many relation between Product.images and Media. My code follows the docs about relations but it does not work (my guess because of circular references)....

Rorsch

7/15/2024

How to Normalize Database using Drizzle?

I previously have made my Order Table to only support one service/line item back then (based on the business logic back then). Now, I need to normalize my database, so that it supports multiple services/line items in a single order. I have tried to write the migration file but it's not running.

Solution:

Node can’t execute ts file. You can try to run your script with tsx. npx tsx path/to/your/file.ts...

mus

7/15/2024

Call Custom Function onConflict

How to handle custom function or update other table when there is a conflict? so we don't need to handle like this

ak4zh

7/15/2024

Column name different in drizzle magic sql vs drizzle-orm

I use camelCase column names for the ORM and snake_case for the databse columns. Queries run through ORM returns camelCase columns but if I use drizzle.execute(sql``) it results in snake_case columns any workaround ?...

xxxxx

7/14/2024

How to get good at Drizzle?

Hello I am currently having a huge problem with Drizzle, and relational databases in general. I start writing my schema, but after finishing a few tables (5-10) I get overwhelmed by the amount of objects and relations happening between them and don't know what to do, and how to properly connect them together. At this point I just delete my entire schema and start writing it from scratch, in hopes of implementing it correctly this time. This process repeats a few times and I never actually finish the database....

nick22985

7/14/2024

Accessing local.drizzle.studio on another machine due to having to ssh

Hey, I am trying to port forward / access the instance of Drizzle Studio from another machine on the same network. - What I have tried. Manually port forwarding the port that drizzle local uses to another machine 4983 - doing what the docs say npm drizzle-kit studio --host 0.0.0.0; however, this only connects to the DB, and if the schema is also on the server, this does not work....

Timo

7/14/2024

Overwriting Schema Defaults

```ts await database.insert(users).values([ { name: ADMIN_NAME!, slug: ADMIN_SLUG!,...

hkg

7/14/2024

`drizzle-kit push` trying to remove drizzle's own sequence causing errors

``` $ bunx drizzle-kit push drizzle-kit: v0.23.0 drizzle-orm: v0.32.0 ...

GamerZero

7/14/2024

Stack overflow when trying to insert many values at once

I'm using drizzle with nextjs so the code is chunked into separate bundles by nextjs it seems, but there are mentions of SQL in the stacktrace and i'm not using any ORM other than drizzle in my project. Here's my code:

await db.insert(table).values(largeListOfValues)

await db.insert(table).values(largeListOfValues)

...

Pure

7/14/2024

Issue with constraint primary key when using drizzle-kit push 2 times.

Hello! I am facing an issue where if I use drizzle-kit push 2 times without making any changes on a schema with a table with a constraint primary key. First push. Works as intended. ``` $ drizzle-kit push...

metowo

7/14/2024

db.query returns empty object

I'm using commonjs for swapping out the query builder from knex and bookshelf with drizzle and am seeing that logging db.query returns an empty object which I found because db.query.users.findFirst was giving me a can't call findfirst on undefined error. this is my schema ``` const users = mySchema.table('users', {...

JustCodeItAll

7/13/2024

studio dosnt connect, stuck on the launch screen, neon websock, then something about .pem file.

I’m getting the error of: ``` no such file or directory, open '/Users/MYCOMPUTER/Library/Application Support/drizzle-studio/localhost-key.pem' ...

ak4zh

7/13/2024

Infer date values in jsonb column as Date object

I used $types<>() to provide the type for my jsonb column but the returned value is date string not a js Date object. ```ts type InvoiceSchema = { invoiceNumber: string;...

solomangrande

7/13/2024

Am i correctly created a unique email input for my form?

```export const inquiries = createTable( "inquiry", { id: serial("id").primaryKey(), name: varchar("name", { length: 256 }),...

xxxxx

7/13/2024

How to create this kind of relation

I have a prices table which stores a price object, with some info such as currency_symbol, currency_amount and some more. The thing is this price should strictly have a one-to-one relationship with whatever is priced. For example in my taxes table the tax should have a relationship with price and in my products table the product should have a relationship with price and so on... My current solution would be to create a few helper tables like tax_price and have it store a price and be in relationship with tax and the same for product. Is this necessary or is there a better way to implement something like this?...

Pure

7/13/2024

bit type goes to postgresql as a string

Hello! I was recently creating my schemas for a project (I am using postgresql) and I set a column as bit(10), but drizzle-kit push passes it to postgresql as a string so that postgresql gives an error. ```ts export const users = pgTable(...

Helix

7/12/2024

Data Retrieved As Same Data

I am retrieving some data using an api, and I'm only getting the same number in one column even though the data is different in the database. My database has a column that is default uuid_short(), is this the correct way to do the schema?

``export const auditsTable = mysqlTable("audits", {
  AUDIT_ID: varchar("AUDIT_ID", { length: 255 })
    .primaryKey()
    .$default(() => sql

(uuid_short())`), DATE: date("DATE").notNull(),...

html_extraordinaire

7/12/2024

Reset database

I'm using Vercel Postgres and once, a while ago, I reset the database using some command like drizzle-kit push, maybe? IIRC, there was some sort of conflict and it was like, "Sorry, gotta start fresh." Which was fine with me. Sometimes I want to just reset the database but there doesn't seem to be an easy way to do it. How can I force a reset?

Solution:

There is nothing builtin :/ With postgres I do that: https://github.com/rphlmr/drizzle-vitest-pg/blob/main/test/setup.ts#L28-L32...

Matoslav

7/12/2024

Date (de)serializing

Hi, how can I achieve that for data type "date" in postgresql I will be able to insert dates in string and they will be deserialized as Date data type when selecting? In Drizzle v. 0.29.3, this behavior was common: I could input dates as strings, and they would be deserialized into Date objects. However, now it seems that Drizzle requires me to either: Serialize the date as a string and deserialize it as a string, or...

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!