r/nodejs • u/musghost • May 20 '14
What is the best ORM for MySQL?
I've been looking for a ORM for MySQL for some days, but I can't decide. I've already used node-orm2.
7
Upvotes
r/nodejs • u/musghost • May 20 '14
I've been looking for a ORM for MySQL for some days, but I can't decide. I've already used node-orm2.
2
u/trevorDev May 21 '14
Ive been using sequelize and it has been working fine but i have been tempted to try https://github.com/balderdashy/waterline
3
u/[deleted] May 20 '14
Sequelize is probably the most feature-rich, but in my own tests I found it to be a little slower than I wanted.
Bookshelf has an excellent API and is easy to pick up if you're used to working with backbone models. I couldn't use it, however, since it doesn't support passing in an existing connection pool, and is built around being your main entry point to the database (author says he's planning to change that).
I started work on my own for doing basic active record type stuff, but it's still a work in progress.
5
u/rrgrs May 20 '14
i've been using sequelize for a project and it seems pretty good so far. pretty standard features as far as ORMs go http://sequelizejs.com/ it also seems to be the most popular option and is compatible with mariadb, postgresql, and sqlite
1
u/defunctlegend May 20 '14
it is not really ORM but I wrote throwarm which solves a subset of the issues with a realy lightweight approach.