ORM suggestions if any
Unanswered
Red-crowned Parrot posted this in #help-forum
Red-crowned ParrotOP
Hello I was curious on what some best
- ways of using ORMs
- Different types (Prisma, drizzle etc)
My background is in backend engineering and using an ORM feels strange to me (but I understand the importance of them)
Database mySQL
- 25 tables
- planet scale
What the hell is kysely about?
- ways of using ORMs
- Different types (Prisma, drizzle etc)
My background is in backend engineering and using an ORM feels strange to me (but I understand the importance of them)
Database mySQL
- 25 tables
- planet scale
What the hell is kysely about?
10 Replies
Red-crowned ParrotOP
Some other good reading I found
https://blog.logrocket.com/node-js-orms-why-shouldnt-use/
https://blog.logrocket.com/node-js-orms-why-shouldnt-use/
Asian black bear
When I quit Java I quit JPA and ORM forever
kysely looks cool though
yup, Kysely looks nice. i prefer query builder over ORM.
@Asian black bear When I quit Java I quit JPA and ORM forever
Red-crowned ParrotOP
Glad we are all on the same page
Bumble bee
Knex is also a really good query builder
Asian black bear
I always found the barrier between ORM and SQL to be limiting and a source of bugs, but the idea of getting objects from a database is pretty good sometimes. Object/document databases like Mongo are another alternative option. Not really applicable to your existing app though.
if you really want to use an ORM I would say Drizzle, but I recommend not using them. I prefer query builders, knex is very good but it lacks type-safety, so my recommendation is kysely
@Rafael Almeida if you really want to use an ORM I would say Drizzle, but I recommend not using them. I prefer query builders, knex is very good but it lacks type-safety, so my recommendation is kysely
Red-crowned ParrotOP
Trying out drizzle now so far it is okay.
It's kind of funny how this abstraction even exists and I am trying to respect it as much as possible and keep on moving
It's kind of funny how this abstraction even exists and I am trying to respect it as much as possible and keep on moving
kysely is inspired by Knex.In general there are many ways to deal with DB depending on use cases. say, for CRUD oriented db maintenance systems for internal use, C# ASP.NET EntityFramework works fine. In contrast, Rust low level byte stream processing is performant.