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!

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

theo (t3.gg)

9/3/2024

Consistent issues with `drizzle-kit push` on Turso

Hey y'all! Having some issues with drizzle-kit push when using Turso. Appears to be an issue since 0.23. Legitimately considering going down to 0.22.8 again. cc @Andrew Sherman https://github.com/drizzle-team/drizzle-kit-mirror/issues/500...

ansipedantic

9/2/2024

One to Many with composite primary key?

I am working on a transit-related application (not super important, but may provide context for mental model of the below tables). I am importing data that is conforming to the gtfs spec, so I am not doing any pre/post processing of the data provided in a collection of csv files, I am just importing them straight into a database. I have a table of "Shapes" (which really should be though of as points (lat/lon) along a bus trip). The primary key is a combination of the id and sequence fields. I also have a table of "Trips" which contains a shape_id in the table. Different trips may have the same shape_id (e.g. think of trips happening at different times). ...

Halil Han BADEM

9/2/2024

Defining relations of schemas in separate files

Hi, does anyone have any ideas on the following topic? https://github.com/drizzle-team/drizzle-orm/discussions/2577#discussioncomment-10522926 Here, imagine that you created each table separately with different files. Two tables that are related to each other (for Query) need to call each other for relations. This causes problems. How should relations definitions be made in separate files?...

jsingleton37

9/2/2024

What is the best way to get distinct values from a table?

I am curious what would be the best way to get distinct values from a table. I have ```ts export async function getYearsThatHaveVotes({ division }: { division: string }) { const yearsWithVotes = await db...

Tomathy

9/2/2024

No overload matches this call

I'm sorry that I'm already the 4th person with this sort of post, but the other posts didn't really help me out. I'm having an issue where it's sayig a certain attribute isn't in the type generated, but I don't see why not, and when I run the code it does work ```await db.insert(clients).values({ name: faker.person.fullName(), nif: faker.number.int({min: 100000000, max: 999999999}).toString(), password: faker.internet.password(),...

buckwheat

9/2/2024

Timeout while migration

Its not that connection error and all app is running file but when i run migration its not migrated in the db and it gets timeout, am using postgresql

Ilan Yehezkely

9/2/2024

How to use OVERRIDING SYSTEM VALUE with drizzle?

I want to use the GENERATED ALWAYS AS IDENTITY for identities but also for local dev I need to manually set ids', so how would I use OVERRIDING SYSTEM VALUE clause with drizzle and not raw sql?

Don Cezar

9/2/2024

Drizzle Studio stuck at 'connecting to localhost:4983'

I have a local Ubuntu server with Docker & Coolify running my websites. I'd like to install Drizzle Studio so I can have that nice interface with my databases instead of going at it through command-line (ugh, last time I messed with databases was like 15 years ago through phpMyAdmin). I'm a little bit confused on how to get it up and running on my machine, I was under the impression it would be just a simple web app that I throw into my docker and connect via the port. Need some guidance

🇨🇭 Marko Bolliger <cannap>

9/1/2024

Relation not working?

Hi the relations are on the screen the query output is ``` sql SELECT app.id, app.name, ...

9/1/2024

string.max message not respected?

How do I refine my createInsertSchema to override the message for the max length of a string? I have a mySqlTable defined named "tags". ``` export const tags = createTable(...

aspasht

9/1/2024

Vercel integration setup

Uncaught (in promise) VercelPostgresError: VercelPostgresError - 'missing_connection_string': You did not supply a 'connectionString' and no 'POSTGRES_URL' env var was found. I'm trying to connect vercel postgres in my nextjs project with drizzle orm. I've followed official documentation from vercel , also drizzle but still facing this issue. Did anyone ran into this issue before?...

Marcel Overdijk

9/1/2024

Using `$dynamic()` to enhance where clause

I have a function like: export const applyFilter = (qb: SQLiteSelect, paging: Paging, filter: string | undefined) => { .. } which adds limit and offset and also where using qb.where(..)....

Swart

8/31/2024

Invalid Byte Encoding with Postgres JSONB columns

I've been running a fairly successful website with drizzle-orm but have recently come across a problem that I cannot for the life of me figure out. Any insight into a solution, or even how to debug this further would be helpful. I have a pretty standard setup - - postgres16 [docker image] - Web frontend using nuxt. Data used for the backend API is provided by drizzle....

DiamondDragon

8/31/2024

Dynamic function get use typed column names using getTableConfig

I have both UUIDs and NanoIDs on every one of my tables. I am considering adding utils to map from uuid -> nanoID & vice versa. how would i make a dynamic function like this? basically under the assumption every table has a id and shortId column which is the nanoid ```ts...

Kuba

8/31/2024

Relations and inheritance mapping

Hello! I have a schema where a question can be polymorphic - that is there's a generalized (base) Question that can be specialized: TrueFalseQuestion, MultipleChoiceQuestion etc. Specialized types have their own attributes, that are unique to them (such as is_correct for true/false). I would like to know if there's a way to use Drizzle Query and don't nest the associated tables, but instead return the attributes within the object itself: ```ts...

oljimenez

8/31/2024

Drizzle ORM migrations on rename fields?

Hi, guys, in my company we want to use Drizzle ORM with Payload CMS, but we're searching for how Drizzle handle migrations. I know that Drizzle will generate automatic migrations using pnpm drizzle-kit generate, but i've never tested with rename fields? How Drizzle will behave on those situations? We're looking for automatic detecting of rename fields, similar how Django does. Will Drizzle be capable to detect rename fields? ...

Valentin W

8/31/2024

Numeric type returns number instead of string as defined in TypeScript

Hello, I'm trying Drizzle ORM with PostgreSQL and TypeScript. I've noticed a discrepancy between the TypeScript definitions and the actual runtime behavior for numeric fields. Schema definition: ```Typescript export const bankrolls = pgTable('bankrolls', {...

Mads

8/31/2024

notNull and Unique

Hi Whenever I use push:db I get that I am about to add a new unique constraint. I then checked and I don’t actually have the unique constraints set. Am I doing something wrong?...

sbbu

8/31/2024

drizzle-kit introspect on postgresql database hangs

When I run drizzle-kit introspect it successfully connects to my database and fetches some tables, but hangs after that and does not pull anything else

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!