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

Invalid type inference when using helpers

im using helpers for primaryKey and current timestamp column.helper.ts ```ts import { integer, text } from "drizzle-orm/sqlite-core"; ...

PicardyTheThird

12/28/2024

Table Abstraction

Hi all, I'm new to drizzle through sveltekit. I'm a big fan of declarative abstraction, and I would like to make a class to wrap around tables. Essentially, I would like it to apply default columns, like id, created, updated, archived, lifetime etc. so all tables have the same default structure, along with their other structure. (Obviously I wouldn't do this with linking tables and stuff). How could I do this with 100% type safety? My end goal is for it to communicate through websockets and update the front end model in real time for all clients, handle permissions, and have an event emitter system. It would handle the "updated" column, and would delete if it's passed the data's lifetime. I also would like to integrate my rust-like "Errors as Types" code on top, along with a lot of other features. However, I need to start with the fundamentals and see if this is even possible. Here's some pseudocode for what I'm thinking...

manikandan

12/28/2024

Is there any option to use Drizzle InferSelectModel value for annotating swagger response

As you can see in the screenshots, I'm trying to reuse the drizzle infer models for the swagger response Since the infer model is based of type I was not able to annotate it for swagger. Is there any alternative or easiest way to achieve this?...

Beck

12/28/2024

TypeScript reference cycles (`ts(7022)` errors)

Hello everyone, I’m running into a TypeScript error that causes my table schemas to become type any. Here’s a simplified example illustrating the problem: - There are two schemas, user and team. - A user may or may not have a team (i.e., teamId is optional)....

mattyp023

12/28/2024

Capital letter causes index error when running npx drizzle-kit push

if i have a users table ```export const users = pgTable( "Users", {...

12/27/2024

Exclude results with empty relation

I tried using isNotNull to filter out the results that doesn't has any value in availabilities relation, but didn't worked that way, I'm sure I'm missing an easier way of doing it.

andystevenson

12/27/2024

sqliteTable deprecated.

Looks like every declaration of sqliteTable is deprecated without the 3rd parameter. But typically this is just the default index or have I missed something?

pecko0326

12/27/2024

Run migrations programatically

Is there a way to programatically run new migrations? The use case for this would be in a testing scenario (if I'm not doing something completely wrong here): - When running my tests I'd like to drop all of my existing tables in my database designated for testing - Then I'd like to generate and push the migrations based on the existing schema to the database, which will create the empty tables...

luka

12/27/2024

Tried to create a role with a NULL password

using Next.js 15 , neon , drizzle trying to create role for Row-Level Security getting error : Tried to create a role with a NULL password ...

.frag

12/27/2024

ORM relation `where` does not exist in type

Can someone help me understand if I'm doing something wrong? The following code (adapted from Query/Select filters gives a 'does not exist' error on where: ```js export async function getItem(id: string, userId: string) { const result = await db.query.item.findFirst({...

Bhinder

12/27/2024

Facing issue with connecting to supabase postgresql

Hi! guys i'm getting this error while trying to connect or push changes to supabase using drizzle. ` ⨯ [Error: SASL_SIGNATURE_MISMATCH: The server did not return the correct signature] { code: 'SASL_SIGNATURE_MISMATCH', digest: '3918316498'...

Le Michel

12/26/2024

Get `CREATE TABLE ...` SQL from a schema

Is there a way to get the SQL to create a table based on the table's schema ? I am doing some tests with Drizzle-ORM, and I don't want to setup Drizzle-Kit and all the migrations stuff just for that. Given a table variable defined with const table = sqliteTable('table_name', schema);, is there a way to get the SQL to create the table in the db ? Something like db.run(table.getCreateQuery()). Thanks !...

TE Johan

12/26/2024

Column reference is ambiguous

Context Framework: Next.js Database: Postgresql "drizzle-orm": "^0.38.3" Error...

willm

12/25/2024

please install required packages: 'drizzle-orm'

I'm getting the following error when I run drizzle-kit push. I don't think I changed anything and drizzle-orm is definitely installed and working in my app. Any ideas?...

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 [email protected] with binaries:
 - drizzle-kit
installed [email protected]
installed @libsql/[email protected]

installed [email protected] with binaries:
 - drizzle-kit
installed [email protected]
installed @libsql/[email protected]

...

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

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!