Tuesday 31 October 2017

Which ORM do you recommend for SQL databases?

Context: I've been using Knex to fetch data from databases for quite a while now and while it's a great tool, I am now looking to try something more opinionated like an ORM.The built-in features I am looking for the most are:Schema definition;Schema validation;Migrations;Support for underscore table/column names;Easy way to write Raw Queries or Raw Where statements when needed.Things I don't mind/don't use much:Slow learning curve;Difficult setup;Transactions;Hooks/Events.From what I saw the options are very limited. Sequelize seems to be the standard but a lot of people complain of its bloat. Bookshelf seems nice but it's going through some problems and development has slowed down. No opinions on Objection.js yet (please comment if you have some!).What do you guys and girls use and recommend these days and why? Any opinions will help.

Submitted October 31, 2017 at 02:15PM by xenopticon

No comments:

Post a Comment