Lightweight, performant ORM or database abstraction layers for postgresql? What about benchmarks for the big ORMs out there?

I'm looking for an ORM for a new project - it's starting off small, but is likely going to get pretty big down the road. I'm no stranger to SQL, having used it for quite awhile, but the nature of the project is so that some form of database abstraction would help a lot, and the minor performance impact that entails is acceptable.That's the key word though - minor, and that's where I'm running into a problem. I'm weighing my options - Sequelize, Bookshelf, Waterline, Objection.js, or just straight up Knex all seem fairly popular, but I can't find any benchmarks on them. I realize I could do my own, but I have no experience writing benchmarks in node and I'll likely forget something.Has anyone done any fairly thorough reviews on the node ORMs on the market? And on a related note - what's the performance impact of using something like objection/bookshell to build models, and knex to write the complex queries?

Submitted July 05, 2017 at 06:12AM by Geekuru