Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Join

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

Join

404

9/6/2024

Error: connect ENETUNREACH when connecting xata

Gustavo Trapp

9/6/2024

Drizzle QB -> Can't utilize tables defined to query data

I'm getting this weird erorr, maybe it is something to do with my tsconfig.json or versions: typescript = 5.5.4 drizzle-orm = 0.33...

IkiTg07

9/6/2024

Weir bug image on db:push

Everything was doing great and all until yesterday when I tried to push some changes to my db using

bun run db:push"

bun run db:push"

a script that runs

drizzle-kit push

drizzle-kit push

I get a weird error like drizzle went to one of my image file : ``` No config path provided, using default 'drizzle.config.ts' Reading config file '/Users/ikbal/work/danaus/website/danaus_app/drizzle.config.ts' Using 'pg' driver for database querying...

ppppp

9/6/2024

column "foo" referenced in foreign key constraint does not exist

i got an error when i migrating, the error is this:

PostgresError: column "person_id" referenced in foreign key constraint does not exist

PostgresError: column "person_id" referenced in foreign key constraint does not exist

...

DiamondDragon

9/6/2024

Drizzle Zod refining not working?

Shouldn't this code for zod make an optional field firstName required? https://drizzle.run/t2zowcjw5f1xbb5ny7zq2j3n...

pato

9/6/2024

Accumulating connections

For the longest time, whenever I'm working (in dev) and my app restarts, more often times than not, I will get a connection error because I have achieved the max number of concurrent connections for my PostgreSQL DB (5). I have that limit because I use a free provider for the dev database. The only way to keep working, is to login to the DB's admin panel and kill all the connections. Problem here is, why the heck is it accumulating connections? It seems to happen randomly, I cannot track exactly when it doesn't close the connections, so I don't know what causes it. I might simply be editing a Handlebars view, which requires server restart, and once it does, there's a chance I've reached the number of connections. WTF is going on?...

flashoid

9/5/2024

Introspect doesn't detect tables in db

I'm porting my project from Prisma to Drizzle, and trying to auto-generate my schemas, tho introspect doesn't seem to work: ```bash ╰─> -_- % pnpm drizzle-kit introspect No config path provided, using default 'drizzle.config.ts' Reading config file './projectDir/drizzle.config.ts'...

colinshen

9/5/2024

Should I create a global drizzle instance?

1. a global drizzle instance with a global db client 2. a function that return drizzle database instance...

sbbu

9/5/2024

What's the difference between "planetscale" and "default" mode on mysql2 client?

There is already a planetscale driver, this is the mysql2 driver. What does mode: "planetscale" do here?

wemsamuel

9/4/2024

Use findMany or Select with Partial Types?

I'm currently trying to implement a findMany query where I can pass a partial object type (similar to how Prisma allows filtering with partial data) to dynamically construct queries based on the fields provided. Here is an example of what im trying to do ``` import { DBCredit } from './types';...

achesui

9/4/2024

PLEASE HELP WITH SQL OPERATOR DYNAMIC PARAMS

Hello, Im trying to execute a SQL query using SQL operator but it gives error. NeonDbError: syntax error at or near "$2" const treshold: number = 0;...

9/4/2024

unable to access drizzle studio on windows

Hi, I'm trying to launch studio for my project on windows machine. And I can't access the url of studio due to some firewall blocking by my company. I tried with localhost url with default port, but it gives 404 error. How can I see the studio with localhost without using the https://local.drizzle.studio ? Can someone guide me how to see studio?...

Karl

9/4/2024

Error when attempting to migrate on Windows

Hey, I am working on a project which uses Next.js, TypeScript and Drizzle, I'm running a local, freshly installed Postgres server on my machine, in which I have created a database and granted all permissions for it to user postgres. I am getting a connection URL from the environment variables (specified in a .env.local file) in the following format: postgres://postgres:postgres@127.0.0.1:5432/<db_name>. The error I'm getting is this: ``` Migration failed: Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string...

Haydz

9/4/2024

error: relation "X" does not exist

Hi I've been trying for awhile and can't seem to figure this out. I converted from prisma to use Drizzle. It works locally in my docker container but when I build my TS project then try run it or deploy it I get the following error... error: relation "tours" does not exist export const tours = pgTable("tours", {...

cosbgn

9/4/2024

generated columns reference another table

I have a table called users and another called teams. I would like to have users.plan be generated from teams.id === user.team_id and from that team get teams.plan. So pretty much user.plan is generated from the right team plan. Is this possible?...

EagleEyes

9/3/2024

PostGIS in a separate schema

I have seen it advised to install postgis in a separate schema, not the public schema. However, I am running into errors such as "error: function st_dwithin(extensions.geometry, unknown, numeric) does not exist" when trying to query using PostGIS functions. Does Drizzle support extensions installed in schemas other than public? If so, how do you set the search_path with Drizzle (I understand it's on a session basis)?...

Icestonks

9/3/2024

Maria DB?

Does anyone know when Maria DB will get supported? I haven't really looked into it, but it seems there's already a pull request, for support for Maria DB

https://github.com/drizzle-team/drizzle-orm/pull/1692...

dankenguyen

9/3/2024

Hello admin, please help me this error:

i can't push db

Big Duck

9/3/2024

terrible latency with simple sql statements.

main.ts ``` import { drizzle } from 'drizzle-orm/postgres-js'; import { migrate } from 'drizzle-orm/postgres-js/migrator'; import postgres from 'postgres';...

Big Duck

9/3/2024

drizzle studio blocked over http

I'm trying to access drizzle studio over a vps near my database location to test latency. I specified host using https://local.drizzle.studio?port=4322&host=<vps_ip>. However all I get when i navigate to local.drizzle.studio is a "connecting to the drizzle kit on <vps_ip>". When I go to the devtools I see this error appearing over and over again every second: index.js:13800 Mixed Content: The page at 'https://local.drizzle.studio/?host=<vps_ip>' was loaded over HTTPS, but requested an insecur...

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!