I'm somewhat new to NodeJS, I come from the traditional LAMP stack world, most of my apps were in CodeIgniter, and I was beginning to work with Laravel, which has an amazing ORM, Eloquent <http://laravel.com/docs/5.1/eloquent>.
I'm switching my primary project over from PHP/Apache to NodeJS/ExpressJS, and since I'm early enough in my project, I wanted to be sure I am choosing the best ORM for the job. The ones I have found so far, are SequelizeJS <http://sequelizejs.com>, BookshelfJS <http://bookshelfjs.org/>, ORM <https://www.npmjs.com/package/orm>, and ORM2 <https://github.com/dresende/node-orm2> Currently, I'm tinkering around with SequelizeJS, and thats the only one I've messed with so far. I was told that it's the best one out there, but the people that have told me that, haven't tried anything else, or researched anything else either, lol. I like SequelizeJS, it seems pretty good, but I've ran into a few limitations, all of which could be solved if it was setup so I could write plugins or extensions for it, but its just not setup like that. I do like the 'paranoid' feature (adds a timestamp to the deletedOn column, and excludes it from future searches, unless paranoid is disabled), which unless I overlooked it, I didn't see that in the other ORM's. Any topics or articles I've found online about any of these ORM's are pretty dated and review very old versions of the ORM's, so I was just hoping to get some input on what others use in their projects. *My Preferences* (But not required): - Good documentation - Plugin support - Something similar to the paranoid <http://docs.sequelizejs.com/en/latest/docs/models-definition/#configuration> setting found in SequelizeJS - Very good support for relationships - Support for Regex searching <http://www.sqlines.com/mysql/regexp_rlike> (RLIKE, REGEXP) - Support for both ENUM <http://dev.mysql.com/doc/refman/5.7/en/enum.html> and SET <http://dev.mysql.com/doc/refman/5.7/en/set.html> column types SequelizeJS seems to follow most of those, but I have to mess with some of the queries or models to get it to work right, if theres an ORM that does all of the above out of the box, that would be great! Thank you -J -- Job board: http://jobs.nodejs.org/ New group rules: https://gist.github.com/othiym23/9886289#file-moderation-policy-md Old group rules: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/nodejs/c52cbaff-97fc-4037-b239-46956a4d9de5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
