Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Node.js doesn't have a good ORM for managing MySQL schema/migrations...so can I use SQLAlchemy to manage it?

Node.js doesn't have a good ORM for managing MySQL schema/migrations...so can I use SQLAlchemy to manage it?

Problem

I need to use Node.js, but it doesn't have a good ORM for MySQL. So I'm planning on using SQLAlchemy to define my schema. And then use node-mysql to do low-level queries (of course, I wouldn't be able to use SQLAlchemy's query language coz it's in python.)

What do you guys think?

sequelize seems to be the best one...but it doesn't seem that many people are using it. Also, what about migrations? How would I handle that?

node-orm doesn't seem very active either.

Thoughts on this?

Problem courtesy of: user847495

Solution

Sequelize is pretty good ORM for MySQL and has excellent documentation. You can use node-migrate for migrations.

Solution courtesy of: alessioalex

Discussion

View additional discussion.



This post first appeared on Node.js Recipes, please read the originial post: here

Share the post

Node.js doesn't have a good ORM for managing MySQL schema/migrations...so can I use SQLAlchemy to manage it?

×

Subscribe to Node.js Recipes

Get updates delivered right to your inbox!

Thank you for your subscription

×