DT
Drizzle TeamDerock
ts: Object literal may only specify known properties except the property is known
D
Derock•18d ago
nvm im dumb its wanting an array not one object
just noticed the little
[]
at the end
nevermind again, its not expecting an array
oh turns out webhook.token
is of string | null
but ive created it as a non-nullable column. dont know why the ts error was so misleadingThe official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
7.3KMembers
View on DiscordWant results from more Discord servers?
More Postserror: no schema has been selected to create in while running push commandtrying to setup drizzle with local postgres database, DB_CONN_STRING is 'postgres://postgres:passworNavigating through multiple many-to-many relationships in a single query?Hi all! I've been racking my brain unsuccessfuly on how to accomplish my desired behavior with a queCircular Reference Error when Using Self-Reference in Table Definition with Drizzle-ORMI encountered an error while defining a PostgreSQL table using Drizzle-ORM. The issue arises when atSQL many statements?Any ideas on how to debug this?
```Task migrations deno run -A src/lib/db/migrations.ts
error: UncaQuerying a materialized view: relation does not existI define a materialized view as such:
```
export const usersMv = pgMaterializedView("users_mv").as(
default to empty object for sqlite text field with JSON modeHow can I default a `mode: 'json'` text type to an empty object in sqlite?
The following in a `sqliConverting a field from X type to Serial causes errorsI'm attempting to convert a field from type `text` to type `serial`.
Here's the error I'm seeing:
`Return type is only "with" types, ignores "columns" typesNot sure if I'm using it wrong but the return type of a relational query is just the columns from thonUpdateupdatedAt: timestamp('updated_at', { mode: 'date', precision: 3 })
.defaultNow()
.$onUpdate(Struggling with subqueriesI want to basically do this query in drizzle:
SELECT o.id, o.date, t.currency
FROM "Operations" o
LE