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!

4/19/2023

Alias in from() change? (SQLite)

Did something change wrt using aliases in from()? Until recently I've been using aliases to affect the resulting object, but it seems to have stopped working as it did before. Previously: ```ts const user = alias(User, "user"); const parent = alias(User, "parent");...

sevenwestonroads

4/19/2023

Table definition has 'any' type

I'm defining all of my tables in an index.ts file; but on some tables like visitor_events I get this errors;

'visitor_events' implicitly has type 'any' because it does not have a type annotation and is referenced directly or indirectly in its own initializer.

On other tables however, I don't have the error and the PgTableWithColumns is correctly infered. ...

Drew

4/18/2023

CTE query of hierarchical data

I'd like to drizzle-ize this query: ```sql WITH RECURSIVE Child(n) AS (...

Drew

4/18/2023

createInsertSchema wrong type (drizzle-zod 0.3.1, sqlite))

After upgrading to 0.3.1, all of the fields changed to ZodTypeAny

Meexa

4/17/2023

How do I get the values of an insert inside a transaction?

I have this transaction where I create a project and add variables and a history of those variables. I need the IDs of the variables for variables_history. How can I get those values? ```ts await db.transaction(async (tx) => { // Add project to DB...

AlcaponeYou

4/17/2023

Raw sql`` quoting issue

Hi, I doing a work around until Drizzle supports generated columns. I have a manual script that adds the generated column + its index. I'm dynamically building the sql query since there's no typings yet. ```...

Droutin

4/17/2023

Nuxt3 type error

Hello, is there somebody who used Drizzle in Nuxt3 project? I have problem with inheriting types from api, but only when I select specific columns from db. Server-side code shows correct types. Problem is on client-side, like you can see on photo. It gives mi correct type OR default type... Server-side ```ts...

Gerbuuun

4/17/2023

Syntax error mysql migration using composite primary key

``sql
--> statement-breakpoint
CREATE TABLE

member_to_address

member_id

 varchar(32) NOT NULL,

address_id` varchar(32) NOT NULL...

Jeyprox

4/17/2023

when using planetscale, using the `.$with()` and `.with()` clauses causes error

Is it not possible to use $with() and with() with planetscale? it gives the following error: DatabaseError: unsupported: with expression in select statement from the @planetscale/database package...

Cory

4/17/2023

Zod prototype mismatch

Even though the Zod object constructor name created by Drizzle is ZodObject, it is not an instanceof ZodObject. This is causing an error in another library I am using that accepts ZOD objects. Since I've got Zod as a peer dependency, it should be expected that drizzle-zod is using that version when it creates a Zod objects? I could be off here. It appears that drizzle-zod has ZOD as a peer dependecy, but drizzle-orm does not?...

thdxr

4/17/2023

unrecognized_keys

Getting the following error when running generate:pg ``` ZodError: [ { "code": "unrecognized_keys",...

mmurto

4/17/2023

Raw SQL / Postgres stored generated column in schema

Is it possibile to add raw sql, or more specifically stored generated columns to the schema? Trying to store a length field of a text column.

frozf

4/16/2023

I think i have found another bug

typescript complaining when there's no overriding

mattmsh

4/15/2023

Custom getter/setter for model's property

Hi, are there any plans for custom getters? (like in TypeORM transformer)

ysm

4/15/2023

drizzle-zod type infer

Looks there is problem in createInsertSchema type inference. 🤔 (+ need drizzle-zod tag in this post)...

Cory

4/14/2023

Why is drizzle-zod converting a string to enum?

It seems like it is converting mysql text() or varchar to enums<unknown>?

thdxr

4/14/2023

how to do ANY

need to do where 'myvariable' = ANY(mycolumn)

rushil1o1

4/13/2023

[BUG?] Postgres transactions throwing connection timeouts after a lot of queries

I think there's a syntax error in Postgres transactions ----> see screenshot cc: @bloberenober...

liyue

4/13/2023

Unique Key Schema

I am trying to create an unique key on a table using a custom schema, the generated sql migration file does not produce the correct output and when I execute it the error relation "users" does not exist is thrown. Here is the code: https://codesandbox.io/p/sandbox/competent-faraday-xk9b2q?selection=%5B%7B%22endColumn%22%3A72%2C%22endLineNumber%22%3A19%2C%22startColumn%22%3A72%2C%22startLineNumber%22%3A19%7D%5D&file=%2Fsrc%2Fdata%2Fmigrations%2F0000_military_la_nuit.sql...

Drew

4/12/2023

sqliteTable wrapper which modifies fields, with proper types

More of a TypeScript question, but I'm trying to create a wrapper for sqliteTable to add a set of standard fields (and keys) to the fields provided: ```ts import { sqliteTable, SQLiteTableFn } from "drizzle-orm/sqlite-core" ...

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!