4 ms·
I went down the Prisma path investigating JavaScript ORMs, and... I have opinions. :) I feel that what we have would be useful within a Prisma context, but giv
by mattrobenolt 4y ago
I went down the Prisma path investigating JavaScript ORMs, and... I have opinions. :)
I feel that what we have would be useful within a Prisma context, but given their complexity and how Prisma works, it's likely not very practical with their "engine".
- joshstrange 4y agoThat’s fair. They are the only game in town, last I checked, that has full (good) TypeScript support which is a must-have for me. TypeORM is the other I know about and I’ve used it as well but I greatly prefer Prisma. Other than having to bundle the engine I’ve been very happy with Prisma + PlanetScale. I’m open to any other TypeScript ORMs if you know of them.
- mattrobenolt 4y agoI would not consider myself a member of the JavaScript or TypeScript communities. I just build the infrastructure and platforms to support these kinds of things. :)
- jacobwg 4y agoI haven't used them, but https://github.com/koskimas/kysely https://github.com/koskimas/kysely and https://github.com/RobinBlomberg/kysely-codegen https://github.com/RobinBlomberg/kysely-codegen are doing some interesting things with TypeScript, focusing just on generating SQL queries, quite a bit more lightweight than Prisma.
- LewisJEllis 4y agoI've also been following Kysely and am a big fan, having used Objection.js and Knex a lot in the past. I consider Kysely to be the TypeScript-native spiritual successor to Knex. For a theoretical new Node + TypeScript + SQL project, the three options I would consider are, from most-ORMy to least: - Prisma - Kysely + kysely-codegen (query builder) - slonik + @slonik/typegen (raw postgres driver with good types; not sure if there's a good MySQL equivalent)