3 ms·
> The query language breaks down almost immediarely. Agreed. We dropped an ORM completely and use SQL in functions (aka stored procedures). For models we use
by akbar501 12y ago
> The query language breaks down almost immediarely.
Agreed. We dropped an ORM completely and use SQL in functions (aka stored procedures). For models we use plain JS objects and for validation we use Joi (https://github.com/spumko/joi https://github.com/spumko/joi) from Walmart Labs.
Eliminating an ORM has been freeing. We did have to invest in upgrading our team's SQL skills, but we no longer run into limitations of an abstraction layer. Our queries are faster as there are fewer layers. Now that we're up to speed on SQL we find it to be expressive for our data access needs.