Monday, 27 July 2020

Alternative to Prisma for Postgresql

Prisma + Postgresql is the go-to solution for my apps. I find Prisma to be better documented and more easily usable than TypeORM or MikroORM.However, I had a particular feature that I needed for an app that isn't available on Prisma. Currently, it isn't possible to increase the value of a certain field by a certain value using update. I mean, there is no way to do this:update table set field = field + 10 where (some condition) without resorting to raw SQL.Is there any alternative that is comparable to Prisma? I use code-first approach, ie. I declare the models in the code and migrate them to the DB instead of designing the schema using SQL.

Submitted July 27, 2020 at 06:20PM by Mycroft2046

No comments:

Post a Comment