I have a Scala 3 app running zio-http with zio-2 and I’d like to use it to query a Postgres database. The only library I got working with my project is scalikejdbc, but I’m just not a fan of the api. Also code generation would be nice - basically I want Slick for Scala 3.
I started going in the direction of a separate module that interacts with DB using Slick and Scala 2.13, and serves it via HTTP, but now I realize that it’s extremely redundant. I will consider changing the DB to Mongo or something, if that means I get Slick-like niceties.
What DB layer library could fit my needs?
Any input appreciated!