4 ms·
It only saves development time for the first version in my experience unless it's being used by an highly capable team. The months lost to the clueless develop
by radicalbyte 8y ago
It only saves development time for the first version in my experience unless it's being used by an highly capable team.
The months lost to the clueless developers massaging their horrible ORM code dominates in time.
In the long term properly factored code wins; and lightweight ORMs have a place. Heavy ORMs (Hibernate, old Entity Framework) should only be used if you absolutely must have specific features and are incapable of building that into a more logical place in your code.
Use a light weight ORM for simple CRUD actions (one with a small dependency graph). For performance critical create/update operations use stored procedures (just be careful with complex business logic; if you implement it, remember to test it). Use light weight ORM for mapping efficient SQL views to api/frontend. Use a workflow/async/job processing for anything which has to be long running or crosses system bounds (think credit card processing).
- jlebrech 8y agoyou could start with an EASY query that's guaranteed to work, then AI could figure out a fast way as your app keeps running. it could be a module for postgresql for example.