PostgreSQL + drizzle-orm

[kingyue737]

Describe the feature

It seems that only sqlite is supported when using drizzle integrator from db0.

db0/src/integrations/drizzle/index.ts

Line 2 in fde26b5

BaseSQLiteDatabase,

Is there a plan to support other databases?

I also have some questions. Since the discussion tab is not enabled, I post them here by the way.

What's the recommended way to integrate drizzle in nuxt server routes? Like following?

// server/utils/db.ts
import { drizzle } from 'db0/integrations/drizzle/index'

export function useDb(name?: string) {
  return drizzle(useDatabase(name))
}

and then call useDb in every event handler?

I'm already using drizzle and pg in my nuxt project. What extra benefits does db0 bring? Moving config from a utils module to nuxt/nitro config? Seamless switching from one database to another as now we have a uniform config interface?

Thanks in advance

Additional information

• Would you be willing to help implement this feature?

[amandesai01]

For usage with Postgres, it is already supported. It may seem like it works only with SQLite, but I believe only dialects or something were used. I just wrote a passing test case for postgres to verify myself and it works like a charm.

b59e7db

[kingyue737]

It seems that type is not correct.
Type PgColumn is not asignable to SQLiteColumn

[kingyue737]

Sorry I forgot the reproduction:

https://stackblitz.com/edit/nuxt-starter-uxpj3c

[kingyue737]

Tried v0.2.1, type still not correct

reproduction: https://stackblitz.com/edit/nuxt-starter-agnsks