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!

12/20/2023

Validate schemas against DB

Hello, did a quick search in here and in the docs but didn't see a related answer, but please feel free to point me in the direction of somewhere else if this has been asked. In my application I am working on I have the limitation that I cannot use drizzle kit to manage the database via migrations, that is done externally to my app. So I am making schemas based off the existing tables in order to CRUD. I'd like to programatically validate that the schemas I have created (aka used drizzle kit to introspect the database) are actually valid for the database I query in my application. This would help avoid coding based off of invalid schemas. Any thoughts on features of drizzle or approaches I could take to achieve? Thanks!...

focused_morning

12/20/2023

Push without truncating

Is it possible to tell drizzle-kit not to truncate? Im in a situation that shouldn't truncate and it wants to.

BiffBaffBoff

12/20/2023

How to use the Batch API?

Hi, I am using Turso and have an array of people I need to insert into my database. I've tried via db.insert(people).values(peopleArray) but get an error about too many variables or something so then I looked into the batch API, but this doesnt work either: ``` db.batch(peopleArray.map(p => db.insert(people).values(p))...

Solution:

You could have a helper like this: ```ts function isTuple<T extends any[]>(array: T): T is [T, ...T[]] { return array.length > 0; }...

pKrepe

12/20/2023

Is there a CLI command to check if all relations on schema are correct?

I would like to emulate the behavior that we have when using drizzle-studio, where it checks if all relations are correct in your schema, but I don't want to get a client up for that, mostly because I wanna add this step as a Github Action on my product dev flow

oke

12/20/2023

How do detect if a Transaction failure occurs?

What is the return value of a transaction when it fails mid way, or does it throw an error? Example: ```ts const authorOrNull = await db.transaction(async (tx) => {...

Arun

12/20/2023

Drizzle Studio & Kit : Now working with electronjs project

Will drizzle-kit studio work for drizzle-orm installed on electron ? I am getting this below error

pnpm exec drizzle-kit studio

drizzle-kit: v0.20.4 drizzle-orm: v0.29.0...

philbookst

12/20/2023

push:sqlite error _old_push table with turso

is there any known workaround for this issue: https://github.com/drizzle-team/drizzle-orm/issues/1313 adding a column to a table and calling db:push gives a 500 error due to a _oldpushtablename being created causing some issues...

Dat Tran

12/20/2023

Drizzle-kit introspect:pg returned malformed schema.ts file

stackintech

12/19/2023

When using Supabase Auth, how do you relate to other tables using Drizzle?

Derock

12/19/2023

`no such table: main.__old_push_projects` after db push

Added the following to a table named service: ```ts (table) => ({ name_project_idx: index("name_project_idx").on(table.name, table.projectId), name_project_unq: unique("name_project_unq").on(...

PAdventures

12/19/2023

Dizzle Kit: Push altering unchanged column

``diff
CREATE TABLE

economy_profiles

member_id

 bigint unsigned NOT NULL,

guild_id

 bigint unsigned NOT NULL,

wallet` int unsigned NOT NULL,...

energistic

12/19/2023

Filter on relations based upon a WITH

I'd like to filter based upon a table that's in the with clause. ```ts db.query.myTable.findMany({ where: inArray(otherTable.id, [1,2]), with: {...

AlexVern

12/19/2023

Filtering

Hello) just got stack on filtering in this case it should not return invite witch has usedAd date and another one witch is expired already but my func still return all of them 🥺...

pedro77

12/19/2023

Can I use drizzle + mysql2 driver + middleware.ts (next.js)?

Is this combo possible? Is it edge compatible?

acronie

12/19/2023

Type error when passing schema to drizzle

export const db: PostgresJsDatabase = drizzle(queryClient, {
    schema: schema,
    logger: true,
})

export const db: PostgresJsDatabase = drizzle(queryClient, {
    schema: schema,
    logger: true,
})

I am passing my schema like this ...

Kryp Arnold

12/19/2023

Json table

Hello guys i have a json object like this; ```json { a: [], //<---- string list b: [],...

louis

12/18/2023

Best way to seperate environments

Hello, I use drizzle with cf workers and turso database. Whats the best way to split my project into a dev and prod database? ...

Zamiel

12/18/2023

How do I use NOW() in Drizzle?

Can someone explain how to write the following query in Drizzle? ```sql UPDATE users SET datetime_last_login = NOW()...

sam

12/18/2023

TypeScript type errors when running in PNPM workspace

I changed nothing about my code other than doing a full clean build. Working code now failing with type errors. I am on version: ```json "drizzle-orm": "^0.29.1",...

Alessandra

12/18/2023

Using drizzle studio with local d1

Hey, I'm trying to connct drizzle studio to my local d1 database. I'm able to connect remote just fine, but attempting to access locally is confusing me. I get the attached error message, and the hint of "To execute on your local development database, pass the --local flag to 'wrangler d1 execute'" is nice, but I can't find any location in the config to actually make it append that --local flag....

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!