express-session store
Hi, I'm a new user of Kysely.
I'm wondering if there is a way to connect kysely with
express-session
. For example, to use in combination with passport
.
For example, I was wondering if Kysely somehow exposes a pg
compatible pg.Pool
, which would allow me to use something like connect-pg-simple
to have an adapter from the Kysely world to the pg
world.
I couldn't find anything around online or in this Discord, so I'm wondering if the Kysely ecosystem is mature enough to have this stuff around yet? Or any ideas as to how I could go about this without too much pain? 🙂Solution:Jump to solution
I just realized that I can reuse the
pg.Pool
that Kysely uses when I added the Postgres dialect, so that solves that problem 😄2 Replies
The unfortunate alternative is to have a second postgres library in my node app if kysely can't support this.
that would entail me using kysely for all my business logic, but for my authentication I create a new
pg.Pool
and use that inside express-session
Solution
I just realized that I can reuse the
pg.Pool
that Kysely uses when I added the Postgres dialect, so that solves that problem 😄