Nested Where Clause in Many-to-Many relation using Query
Hello, I have a many-to-many relationship between my events categories table.' As of now, I am trying to filter this data by joining my events table with the junction table (eventToCategories) and then the junction table with categories table. When attempting to use the where clause in the categories table so I could filter by certain events, typescript told me that the where clause was not allowed to be used here. I am not fully sure why this is the case, but I was wondering if anyone had a sol...
error: type "userrole[]" does not exist
So when I'm running db:push I'm getting an error that the enum userrole doesnt exist. I have the enum here and it shows in the supabase enums list as well.
This is the code
```
enum...
weird error in production (TypeError: Right side of assignment cannot be destructured)
I just checked the logs from my production server and saw this error, several times and can't understand why they may be happening:
I can't seem to reproduce it manually.
Here's the code "causing" it:
Any insights would be welcome....
unable to run drizzle studio
im uitlizing drizzle orm in next.js however when i run the drizzle studio using drizzle kit it seems to be stuck
here is my drizzle.config.ts file:
*import { defineConfig } from "drizzle-kit";...
using drizzle with .env.local instead of .env
I am using Drizzle with Next.js, can I use.env.localfile instead of.envor It will throw an error.
Solution:
If
/src/db/db.ts is only used from within the Next app, it should just be:
```ts
import { drizzle } from "drizzle-orm/neon-http";
import { neon } from "@neondatabase/serverless";
...
drizzle + turso config
im not able to migrate my schema using drizzle + turso
drizzle.config.ts
```ts
import type { Config } from "drizzle-kit";...
weirdness with sql`CURRENT
Here's my simple schema
```
export const sageTransactions = sqliteTable('sageTransactions', {
id: integer('id', { mode: 'number' }).primaryKey({ autoIncrement: true }),...
