5

I want to create a node.js and MySQL based application. Google and Stack Overflow give many options for Javascript ORMs:

However, I could not find an perfect ORM that supports subqueries, joins, transitions, stored procedures, is compatible with MySQL cluster, and has good documentation and community support.

Are there other options? What considerations should I take into account in making a decision?

Mikael Lepistö
  • 18,909
  • 3
  • 68
  • 70
ohm
  • 140
  • 1
  • 5
  • Dont know if it fits all your needs, but https://github.com/felixge/node-mysql works really well. – jmingov Jan 23 '14 at 13:23
  • node-myql is pkg for mysql connection i am searching orm when we can use association object – ohm Jan 23 '14 at 13:27
  • 1
    This questions should be marked as off topic – srquinn Jan 23 '14 at 13:45
  • Possible duplicate of http://stackoverflow.com/a/7646459/1520671 – Salman Jan 23 '14 at 16:00
  • It's been my experience that ORMs make initial development easy, but lead to unnecessary complexity and clumsy database structures later on. If you're working with mysql, use the node-mysql module (it's very very good) and deal with SQL. It's not so hard and much easier to scale and maintain down the line. – qubyte Jan 25 '14 at 03:36
  • I think in this case I would prefer [sequelize.js](http://sequelizejs.com). Great documentation ! – Anuj Jun 26 '14 at 09:26
  • http://sailsjs.org is a great tool – Travis Webb Apr 02 '15 at 23:04

2 Answers2

2

You should try Sequelize. It is a quite different, but still really easy to use. The best I like on it, is their auto synchonizer, which it is quite like Mongoose.

Victor Queiroz
  • 123
  • 1
  • 10
0

Use light-orm and mysql. Light-orm is wrapper around any relational db and mysql is best mysql driver for node.

https://npmjs.org/package/light-orm

https://npmjs.org/package/mysql

Oleksandr Knyga
  • 625
  • 9
  • 9