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

update multiple fields

Hi is there a other way to update multiple fields currently i do it like this ```js const updatePollOption = (option: PollOptionsSchema) => {...

╾━╤デ╦︻(▀̿Ĺ̯▀̿ ̿)

8/14/2023

Need help implementing one to many relations for a table on itself

```typescript const comments = pgTable("comments", { id: text("id").notNull().primaryKey(), parentCommentId: text("parent_comment_id").references(...

Shubham-Sinha

8/14/2023

How to dynamically select columns in relation query with proper type inference ?

```ts const result = await db.query.products.findMany({ columns: { id: true, title: true,...

LandSprutte

8/14/2023

Authjs extending user model for Role based auth trouble.

Recently started to use the new drizzle-adapter for Authjs. And I am having trouble extending the user-model for role based auth. I am not interested in getting the role from my provider (Discord) I want to manage the role in my own DB. Currently when I try to apply the role as shown in the docs (https://authjs.dev/guides/basics/role-based-access-control) TypeScript says that there are no "role"-property on the AdapterUser. How do I override the AdapterUser to include my role-property, so TypeScript isn't mad at me. 🙂...

dew

8/14/2023

Nested one to one relation shows [x:string]: never

I tried using the relational query similar to the example ``` const users = await db.query.users.findMany({ with: {...

DYELbrah

8/14/2023

table not being camelcased when using joins?

For some reason when I use the following query: ```TypeScript const getProductByIdResult = await db .select() .from(product)...

nickmazuk

8/13/2023

Invalid serialization of JSON blobs

Has anyone gotten default values of JSON blobs to work with SQLite? When I try using an empty array, the SQL migration does not have a default value (despite having the DEFAULT keyword). ```ts...

Pachimari

8/13/2023

Is drizzle edge compatible (noobie question)?

Hi, I'm new to drizzle. I tried to set up a drizzle client with turso in cloudflare workers and I get these errors: ```[ERROR] Could not resolve "node:buffer" ../../node_modules/@libsql/client/lib-esm/sqlite3.js:2:23: 2 │ import { Buffer } from "node:buffer";...

Nickolaki

8/13/2023

Query where clause with array.

How can I get something like this to work? ``` const products = ["subscription", "insurance"] ...

sik

8/13/2023

What's the best way to deploy migrations on production database?

I'm confused as to what is the best way to deploy migration on the production database. Locally when I test on my local database instance, I use the commands manually to generate and push the migrations But I want to automate this. Say, I'm using Vercel and I want to push the migration on every commit. In prisma to deploy the generated migrations I use the command prisma migrate deploy, I add this command to the build command like this: prisma generate && prisma migrate deploy && next build...

jakeleventhal

8/13/2023

Default values not working for insert

```ts await db .insert(Drizzle.User) .values({ email,...

jakeleventhal

8/13/2023

How to define types for jsonb

How do you provide custom type interfaces for jsonb columns returned via queries. for instance if i have a column: myfield: jsonb('data').notNull() i want to be able to define a type interface for myfield such that when i do const { myfield } = await db.query.myTable.findFirst({}), the type of myfield is customized instead of unknown...

toddgeist

8/12/2023

why is "<ref *1> SQLiteTable { ..." printed to console

The following code is all it takes to get the entire Table schema to be printed to the console. I have no idea why. It isn't very pleasant. ``` const table = db.update(deployments); const set = table.set({ final_result: "s" });...

Zamiel

8/12/2023

Does Drizzle ORM support CommonJS (CJS)?

I'm trying to use Drizzle ORM for the first time in a brand new project and I am getting this error:

jakeleventhal

8/12/2023

What exactly is the `check` command doing?

would the screenshot not constitute a failed "check"? when i run drizzle-kit check:pg i get the following output:

Everything's fine 🐶🔥

Everything's fine 🐶🔥

i would expect that this fails since it requires a migration...

nickmazuk

8/12/2023

SQLite: timestamp vs timestamp_ms modes

The SQLite column types docs mention there's multiple modes for integers. What's the difference between timestamp_ms and timestamp modes? ```ts...

jakeleventhal

8/12/2023

Is there a way to simply check if the current schema file matches the DB

I want to perform a check to the effect of "is my schema.ts file exactly the same as what is in my connectionString". What is the best way to do this (via CLI preferably)...

jakeleventhal

8/12/2023

Benefits of serverless drivers

Can someone please breifly explain the benefit of using neon serverless drivers for running serverless vercel funcs? My app is both serverful and serverless. Would it be bad to only use the serverless driver? If yes, are there recommended patterns for how to deal with this?...

jakeleventhal

8/12/2023

Drizzle equivalent of `findFirstOrThrow`

Is there an analgous way to do this code in drizzle?

const data = await prisma.appData.findFirstOrThrow({}));

const data = await prisma.appData.findFirstOrThrow({}));

...

jakeleventhal

8/12/2023

How do you get defined types for relational queries

If i have a relational query like this ```ts const post = await db.query.posts.findFirst({ with: { comments: true,...

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!