I want to build a simple ERP app for my company,i came from PHP MYSQL background, i left PHP and now moving to NODE.JS because it overmatches PHP in many ways, i thought i have to lea NODE.JS,
my company is a meat and poultry importer and has hundreds of product and since it is CATCH WEIGHT INVENTORY SYSTEM, each carton has to be recorded as an individual data, they can be millions of cartons, besides INVENTORY, my app must also has other ERP functionalities such as SALES,PURCHASING,HRD,LOGISTIC and many others.
what i already have in mind, i would use :
- -Node.js then
- -Express / Meteor as backend
- -Angular/React as template engine + D3js (i'm not sure) to visualize various reports
- -various DBMS (i think i caot rely onto just one DBMS, i have to haess the power both of RDBMS and NoSQL DBMS)
- MySQL for storing user data
- Key/Value pair DBMS (ElasticSearch / Redis) for storing hardly ever change data but used often and needs fast access such as data product
- Graph DBMS (Neo4j) for storing user relation, warehouse structure and product movement
- Document DBMS (MongoDB) for storing tally weight,product detail and many other document based data.
well chose the right tools and make a good plan is halfway to achieve goal, so i need enlightment from all of you Sir and Mam, give me suggestion what should/shouldn't i choose.