Create a node-postgres adapter

[gue-ni]

Description 📓

It would be very usefull to have a postgres adapter without having to install another package (like prism).

How to reproduce ☕️

Nothing here.

Contributing 🙌🏽

Yes, I am willing to help implement this feature in a PR

[balazsorban44]

Hi, we usually require you to install an ORM, like Prisma or TypeORM, even if you use an adapter. Do I understand that you do not want to install those?

[turtlestackdev]

Not the OP, but I avoid ORMs whenever I can. Is that a hard requirement or could an adapter be created which uses a DB driver directly or a query builder such as Knex?

[balazsorban44]

Totally possible, but probably a bit harder 😅. Here is an old attempt at a Knex adapter that might be useful: nextauthjs/adapters#194

Otherwise, just see any of the adapters in https://github.com/nextauthjs/next-auth/tree/main/packages to get an idea

[hparra]

@turtlestackdev checkout zapatos. I've rolled my own adapter and repos with it.

[statico]

Maybe it would be useful to include adapters specifically for Knex and Zapatos? (I'm a Knex user myself and will likely need to create my own adapter.)

[davidfaj]

Just curious, what would be some difficulties to create an adapter without an ORM (and without Knex, just using a MySQL driver, for example)? Thanks

[cymen]

If you do decide to use the Prisma-based adapter, be aware that the example/default one is not robust. See this issue for details:

#4495

I would not consider it to be production-ready. It's not hard to work around it but fair warning.