Sequelize

Hey! I am actually in internship and have an app to create for my structure. It will be an intern app which will allow crud dashboard actions with some data provided by the use of an API of one of the structure partner and make a correspondence to data contained in a private database. Since it's an intern app, I thought about Electron for a desktop app because I did a lot of web with Laravel and the structure goes more for the desktop app. But it will be my first occasion working with this tech.

Is Electron a good choice? Wich ORM should be more complete and adapted to this between Sequelize and TypeORM? (Database will be MySQL) Some charts will be displayed in the app. Is there a library (preferably without jQuery) that suits this stack?

Thank you !

Hey Mohd. Those are pretty good areas to start with. For front end, focus on getting really good at JavaScript and React. Specifically, learn how to manage state in complex apps. You might want to learn Redux to help with this. Make sure you're using semantic elements in your JSX and get good at using flexbox in your CSS 3. I wouldn't necessarily use Bootstrap, it's good practice to build components yourself. A good exercise is to try to replicate a website like StackOverflow or ProductHunt from scratch.

On backend, ExpressJS is a good place to start. Learn how to build semantic REST APIs that pull data from a database. MongoDB is fine, but I would suggest using Mongoose along with it to avoid nesting objects too much. You could alternatively use a SQL database like PostgreSQL, with an ORM like Sequelize to manage the data.

Node.js is a great option for real-time applications, especially in conjunction with Socket.IO.

In terms of databases, I'd go with PostgreSQL. MongoDB has its benefits (schema-less, sharding, map-reduce), but for most CRUD-based apps, it makes sense to store the bulk of your data in a relational database (of which PostgreSQL is the best IMO). You can throw in MongoDB if you have a specific need for it. There's certainly no need to use both MySQL and PostgreSQL.

As for GraphQL, it can be nice to work with since you don't need to predefine specific data endpoints on your backend, instead shifting the power to your frontend in requesting the data it needs. It's also useful for public APIs, when you don't know what data users want (see Github's API). It can be useful at the early stage when you're prototyping and want to be able to fetch data quickly, but certainly isn't necessary.

At BaseDash we use Node.js, ExpressJS, Socket.IO, PostgreSQL, and Sequelize to fit our use case of database management and real-time operations.

React LoopBack Node.js ExpressJS Elasticsearch Kibana Logstash Sequelize Mocha Chai Visual Studio Code are the combo of technologies being used by me to build BestPrice Extension with all its micro-services & Web-based fragments

What is the best way to increase your income as a freelancer in 2019? What frameworks should be the best to learn? React Node.js Docker Kubernetes Sequelize Mongoose MongoDB ExpressJS hapi Based on trends I've picked up a JS full stack. If you need to work under startups you may replace React with Vue.js . If you want to work in outsourcing Angular 2+ may be better.

What is your opinion?

Appitr Run JavaScript ES6 with React Native in the browser built on Monaco Editor, Browserify Webpack Sequelize npm Node.js ExpressJS Babel Flow Type ESLint MobX GraphQL

Used it for full stack web application development, especially to interact with MySQL/ MariaDB / PostgreSQL server. Sequelize