1 reply

Drizzle + Neon postgres + NestJS setup help

Hello I have this setup working locally, I found a video setting up NestJS with drizzle but there was no neon. Everything works, but when making a couple of same requests from the frontend I get a NeonDbError: Error connecting to database: fetch failed, could someone help me with the cause of this issue?
I have a database provider -

export const DrizzleAsyncProvider = 'drizzleProvider'

export const drizzleProvider = [
  {
    provide: DrizzleAsyncProvider,
    useFactory: () => {
      const sql = neon(process.env.DB_URL)
      const db = drizzle(sql, { schema: schemas })
      return db
    },
    exports: [DrizzleAsyncProvider],
  },
]

export const DrizzleAsyncProvider = 'drizzleProvider'

export const drizzleProvider = [
  {
    provide: DrizzleAsyncProvider,
    useFactory: () => {
      const sql = neon(process.env.DB_URL)
      const db = drizzle(sql, { schema: schemas })
      return db
    },
    exports: [DrizzleAsyncProvider],
  },
]

Then I inject the provider in some service that I need the db for like this -

 constructor(@Inject(DrizzleAsyncProvider) private db: NeonHttpDatabase) {}

 constructor(@Inject(DrizzleAsyncProvider) private db: NeonHttpDatabase) {}

And a db query example just in case -

async findOne(id: number) {
    const query = await this.db.select().from(product).where(eq(product.id, id))
    console.log(query)

    return query[0]
  }

async findOne(id: number) {
    const query = await this.db.select().from(product).where(eq(product.id, id))
    console.log(query)

    return query[0]
  }

Drizzle + Neon postgres + NestJS setup help

export const DrizzleAsyncProvider = 'drizzleProvider'

export const drizzleProvider = [
  {
    provide: DrizzleAsyncProvider,
    useFactory: () => {
      const sql = neon(process.env.DB_URL)
      const db = drizzle(sql, { schema: schemas })
      return db
    },
    exports: [DrizzleAsyncProvider],
  },
]

export const DrizzleAsyncProvider = 'drizzleProvider'

export const drizzleProvider = [
  {
    provide: DrizzleAsyncProvider,
    useFactory: () => {
      const sql = neon(process.env.DB_URL)
      const db = drizzle(sql, { schema: schemas })
      return db
    },
    exports: [DrizzleAsyncProvider],
  },
]

Then I inject the provider in some service that I need the db for like this -

 constructor(@Inject(DrizzleAsyncProvider) private db: NeonHttpDatabase) {}

 constructor(@Inject(DrizzleAsyncProvider) private db: NeonHttpDatabase) {}

And a db query example just in case -

async findOne(id: number) {
    const query = await this.db.select().from(product).where(eq(product.id, id))
    console.log(query)

    return query[0]
  }

async findOne(id: number) {
    const query = await this.db.select().from(product).where(eq(product.id, id))
    console.log(query)

    return query[0]
  }

Drizzle + Neon postgres + NestJS setup help

Similar Threads

Drizzle + Neon postgres + NestJS setup help

Similar Threads

Similar Threads

Similar Threads