Prisma looks quite awesome but knex has three features we need in our software which I could not do with Prisma.
Run migrations programmatically without cli
Run different sets of migrations (we have to different database schemas)
Select the database connection dynamically on each api call
Those features are running rock solid with knex, in combination with Objection I have a good typescript support. Knex might look not as fancy as Prisma and feels more old fashioned, but I would not switch to Prisma in their current stage of development
We use exec to run migrations programmatically using the CLI, not perfect but works just fine
You are able to have multiple schema files and manage multiple migrations
You are able to select the database connection dynamically when initializing prisma client
Of course knex is not garbage, and it's been one of the most used query builders for ages, but in my company we are making the transition from knex to prisma because as i said in another comment, the advantages are greater than the drawbacks
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Prisma looks quite awesome but knex has three features we need in our software which I could not do with Prisma.
Those features are running rock solid with knex, in combination with Objection I have a good typescript support. Knex might look not as fancy as Prisma and feels more old fashioned, but I would not switch to Prisma in their current stage of development
Of course knex is not garbage, and it's been one of the most used query builders for ages, but in my company we are making the transition from knex to prisma because as i said in another comment, the advantages are greater than the drawbacks