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

Gary, el Pingüino Artefacto

8/7/2024

Get table definition?

How can I get a SQL to create a table based on a table. For example: ```typescript const files = pgTable(...

JUAL BELI HP SEKITAR KLATEN

8/7/2024

Tables not automatic created when running drizzle studio

Hey guys when i running drizzle studio my tables not automatic created but i have already create schema and drizzle migration using

npx drizzle-kit generate

npx drizzle-kit generate

Thanks 🙏...

Pupok

8/7/2024

Is this the right way of using relations ?

hi, this is my first project using drizzle, and I'm not that good at sql query as mostly i use ORMs, but now im using drizzle to learn more sql like syntax, This is the schema is question: ```ts export const repairOrder = pgTable(...

CrazyCroatKid

8/6/2024

Right way to make UpdatedAt column in Drizzle?

I'm trying to copy the way prisma was able to create a column that would update to the newest time when a row is changed. Is this a good implementation below or have people had issues with this that have tried to implement it? ```ts export const users = pgTable("users", { id: text("id") .$defaultFn(() => createId())...

ffraenz

8/6/2024

On inserting many, many rows

In the documentation, the following insert with multiple rows is described:

await db.insert(users).values([{ name: 'Andrew' }, { name: 'Dan' }]);

await db.insert(users).values([{ name: 'Andrew' }, { name: 'Dan' }]);

...

JUAL BELI HP SEKITAR KLATEN

8/6/2024

Error line in vscode when accesing env variable

Guys im get error when try configure drizzle config and use drizzle studio, im using vscode, nextjs 14, drizzle. But if i change the port using static string like "12edn2rjq" and not process.env.PORT the error is disapear. Thanks 🙏🏻....

Salumsu

8/6/2024

Where to define Postgres Triggers?

Hi guys, I am relatively new in using drizzle orm, and this is my first time trying to use postgres triggers with it. Where is the best place to define triggers? I can't find any related information in the documentation. Thank you in advance.

Solution:

👋 there is no builtin feature for that. Though, you can do a custom migration (https://discord.com/channels/1043890932593987624/1043890932593987627/1268521683023695992) and put your triggers here...

Coffee11

8/6/2024

Mysql Geo index

``` export const property = mysqlTable( "properties", { id: int("id").primaryKey().autoincrement(),...

sayuto

8/6/2024

DrizzleTypeError<"Seems like the schema generic is missing - did you forget to add it to your DB typ

Hello, I'm new to this. I'm using mysql + drizzle-orm + typescript in nextjs. I use next.js boilerplate when I use this

db.query.books.findFirst....

db.query.books.findFirst....

...

ivan

8/5/2024

sqliteTable infer optional vs required fields

I am trying to create optional fields on my model but no matter what I do the drizzle is inferring all the properties as required. See the example below: ```ts const example = sqliteTable("example", { id: text("id").primaryKey(),...

ivan

8/4/2024

How to get paginated result with the total count?

I want to show pagination in my frontend and calculate the total pages number. I am able to do the paginated query but I also want to select total of the filtered query without pagination. Is this possible within one query? Or do I need to do 2 queries?...

BubbleTrouble

8/4/2024

Get type from select object ?

Is it possible to get the type from my select object ? I know its inferred in the response, which gives me the correct type. But i want to be able also set the type myself so it can be used in other files. const SourceSelectFields = { siteCode: mapboxSources.siteCode, id: mapboxSources.id,...

Charledeon

8/4/2024

Constrain Numeric or Integer inputs

I've reached the point where I'm creating a Database Schema using Drizzle ORM with a Postgres SQL Database on a NodeJS backend. I read the Drizzle Documentation, but I still don't get the full details of really setting up connection to my Database. Then I watched all the possible Drizzle Videos on Youtube....

tzezar

8/4/2024

Is using zod for type narrowing fine solution?

Is using parse for type narrowing good idea with decent performance or should I make validation functions for objects? ``` let a = await dbDrizzle.query.document.findFirst({ with: { lines: true...

jrydberg

8/3/2024

How to get the type of transaction from a database?

I wanna pass a transaction to a function, how can I get the type for the function declaration?

Aidean

8/3/2024

useLiveQuery returns wrongly relations queries

I have such piece of code ```ts const queuedIssues = useLiveQuery( db.query.issueQueue.findMany({...

titongo

8/3/2024

limiting a join when filtering by an extra field.

I have a query which finds properties based on how far away they are from a certain point and then joins some other tables. ```typescript const sq = db .select({ ...getTableColumns(placeDetailsTable),...

imam_janjua

8/2/2024

Help with query

So I have slots table. Now I am trying to get the dates for the days where not even one slot has available_true. So days where all slots are taken -> unavailable dates Now I am trying that query, but always getting empty array and not even and error or so...

Pim de Wit

8/2/2024

`drizzle-kit migrate` errors

Hey all! I am trying out Drizzle for the first time, I am running into some issues on a fresh vite project w/ Supabase: I am following this tutorial: https://orm.drizzle.team/learn/tutorials/drizzle-with-supabase#applying-changes-to-the-database When I run npx drizzle-kit migrate it results in this:...

FND

8/2/2024

findMany conditional select one-to-one relation

Hello. I am switching to Drizzle from Supabase ORM and it's very good. However I got some issues, in findMany query like this: `return this.drizzleService.db.query.Client.findMany({ columns: CLIENT_QUERY, with: {...

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!