Add support for sequelize

[DaftMonk]

We should be able to select between using mongodb with mongoose, or sql with sequelize.

That would be really awesome. For complex DB structures and JOIN queries Mongo is certainly not the best choice. Thank you for your great project.

[corporationsruleyourmom]

Can't wait!

I know it is a bad question, but do you have an idea of the release timeframe for 2.1.0?
I am starting a project with a mysql backend, and I don't know if it is sensible to start with Angular-Fullstack hoping in the near release of Sequelize support.

Unfortunately now I can just offer my best effort to test the Sequelize integration.
Thank you for your great job.

[dancancro]

Cleverstack already uses Sequelize. And if everyone worked together there'd be no need to make trade-offs . Please take a minute to do this survey.

[programming-kid]

it should be not either Sequelize or mongodb but option to add both if needed , i am using Sequelize for analytics & mongo for app data.

[kriswep]

+1 on this

[sigriston]

Is this being currently worked on?

If not, I'm thinking of submitting a PR for this in 1~2 weeks or so, would that be cool?

First question first: should we go with Sequelize 1.x or 2.x for this? I'm thinking 1.x (stable), which is what I've been using in projects, but maybe you folks know more than I do and have a really strong argument for going 2.x? I really don't know...

Next, I'm thinking the UX for this should be something along the lines of what @programming-kid describes, but let me flesh it out a bit:

1. First you choose if you want support for either mongoose, Sequelize, or both (or neither). This will cause the proper packages to show up in package.json and the code in server/app.js and places like that to instantiate mongoose/Sequelize, load models, configs etc.
2. Then you choose whether the default project's entities (Thing and User) are based on Sequelize or mongoose, and the generator will do the obvious and create them appropriately.
3. Finally, when you run the endpoint generator, have either an interactive prompt or a command-line argument like --sequelize or --mongoose to choose whether you want a Sequelize or mongoose-based model.

Do the above make any sense? Let me know, & thanks all contributors for the great job on this generator.

[programming-kid]

i agree with all points proposed by @sigriston , it llooks good

[pensierinmusica]

+1