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

on every `migrate()`: schema "drizzle" already exists, skipping

Hi there! I have setuped a postgres DB. Everytime I call migrate(), it works and migrates, but returns these two warnings: ```bash { severity_local: 'NOTICE',...

Matoslav

8/27/2023

onConflictDoUpdate() ID entry

How to get ID of entry in onConflictDoUpdate, where conflict appeared?

bkyerv

8/27/2023

Strugling to use composite key in schema

How do I represent composite primary key in drizzle way (sqlite) below migration query? I red the docs but failed miserable in trying to implement it. ```CREATE TABLE QuestionSetMapping ( SetID INTEGER, QuestionID INTEGER, PRIMARY KEY(SetID, QuestionID),...

Hugo

8/27/2023

Get database informations inside 'use client' component

Hello, i would like to display categories from my database in my 'use client" component, how can i do ? i don't understand why i have this error when calling database: Module not found: Can't resolve 'net'...

thomasmol

8/27/2023

Running migrate() in Sveltekit project

I have a migrate.ts file with the script for running migrate(), how would you typically execute this in a sveltekit project? I tried adding it to a npm script: "migrate": "ts-node src/lib/server/database/migrate.ts" but I get errors here (ERR_UNKNOWN_FILE_EXTENSION). Any ideas?

Jaxwn

8/27/2023

Reference to auth.users?

i was following ben davis video about sveltekit + supabase/drizzle. in his video he mention that he want to use sql file in supabase/migrations as a source of truth and then rewrote it in schema.ts, ``` create table profile ( id serial primary key, first_name varchar(100),...

firxworx

8/26/2023

Are postgres CONSTRAINTS supported when creating a table schema?

In the column builder types I see there's a general assumption of name, dataType, columnType. In contrast the actual Postgres CREATE TABLE syntax is very rich: https://www.postgresql.org/docs/current/sql-createtable.html...

rykuno

8/26/2023

Optional/Default value for Relational `Extras`

I have a couple cases where a default/optional value for "extras" in the relational query builder could come in handy. I only really want to run this if the user is logged in. ATM I have the following solution ```ts extras(fields, operators) { return {...

sik

8/26/2023

import { PostgresError } from "postgres" - build error?

I'm getting build error when i try to import PostgresError from postgres It says The requested module 'postgres' does not provide an export named 'PostgresError' during build but I am getting no typescript error on my code. I have code like this ```ts...

cobite

8/26/2023

How to do this query in one step instead of two?

Is there a better way to do this than having two different queries? // gets all posts for a specific user with only a users name passed in. `export default async function getAllPosts( userName: string...

cobite

8/25/2023

How to query from a many to many relationship?

Hi all, I am trying to get all the posts by a user. My schema has a many-to-many relationship set up for posts and users. ...

Cambaru

8/25/2023

Correct way to deal with MySqlRawQueryResult

What is best practice to check if the data was created and how to get the newly added data? ``` db.insert(user).values({ firstname: data.data.firstname, lastname: data.data.lastname,...

koty6998

8/25/2023

Unknown option schemaFilter for drizzle-kit introspect

The documentation https://orm.drizzle.team/kit-docs/commands#introspect--pull states that there is a schemaFilter option to specify the database schema parameter. I have installed the newest drizzle-kit: ```...

hacktographer

8/25/2023

How are you all seeding your database?

I see a question from back in March (5 months ago -- https://discord.com/channels/1043890932593987624/1088404663344316476 -- ) answered that it 's planned for in-code custom migrations. IMO seeding from within migrations isn't great, and is actually warned against in some other stacks (eg: Rails). I've fiddled around a bit this morning, trying to get a basic "hello world" ts-node script to run and load my ''src/lib/db" to get connection and schema, but had no luck. It seems like this should be an easy thing, to simply have a stand-alone script that could load up the drizzle-orm connection and schema, and use them to insert some data. Can I get a pointer in the right direction? Thanks!!...

aquarazorda

8/25/2023

Why it's not possible to use `where` here?

I'm trying to make a PoC for drizzle and I'm converting some sequelize to Drizzle, but I don't really have experience with databases to be honest with you. I can't understand, why using where is not possible in this case. Seems like I don't quite understand how to describe BelongsTo with Drizzle and that might be a problem. Can you guys help? Thanks...

cobite

8/25/2023

optional parent child relationship on same table

Hi all I have a table called 'comments' Some comments will have a parent comment, while others will not....

Craig

8/25/2023

Converting drizzle custom type to Postgres composite type fails for arrays

I have a postgres composite type in my database consisting of three fields, accountNumber, beneficiaryName, bankId. I have overridden the toDriver implementation to try and handle insertion of this custom type as follows: ``` type BeneficiaryAccountSqlValue = [ account_number: string,...

mr_pablo

8/25/2023

Cannot drop primary key

I needed to change a table from a single field PK to a composite PK, using the following syntax ``` , (table) => { return {...

charlesbcraig

8/25/2023

InferSelectModel vs. InferInsertModel

I couldn’t find any documentation on what the differences are. My best guess is maybe the insert type might not require auto incremented primary keys and other generated fields since you don’t have them on insert?

enalmada

8/24/2023

parameterized insert and update

How does one do parameterized inserts and updates? When I try and do something like this: ``` const preparedUpdate = db...

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!