Varun Sharma

Hi Jjx003, I will recommend you to go for Node.js with Mongodb. I have been working with the both from long time. Node.js is very good for implementing things which require fast I/O system. I have developed the whole inventory system in React Node.js MongoDB and it is working very fine even after the product database has been so heavy. Apart from this, it will be easy for you to go for one language while developing the frontend and backend i.e. Javascript.

Socket.io with Node.js and socketio client for Reactjs would be perfect for this as Nodejs is very good in two way communication. I would suggest you to deploy the socket backend api on different server so that it does not slow down the I/O operations. In addition to this, you can use Redis if you want to enhance the application performance.

Well, I will personally recommend to go for React Native as I have worked in both of them. React native has big community and it is easy to opt as compared to Flutter. There no doubt about the fact that Flutter is a great framework for developing both Android/IOS apps. However, you should have some experience to go for the same. Both will require prior knowledge as for React Native you have to go through Javascript first with which you are already familiar and for Flutter you need to go through Dart. So being familiar with Javascript you should go for React Native. You can go expo which has lot of inbuilt functionalities for the React Native developers.

HI Shivam, If you the only person who is going to develop the full application then I will suggest you to go for Node.js because you will have to deal with one language only i.e. Javascript. And if you are thinking about scaling then do not worry. Nodejs with mongodb make good application. Capital One bank, Paypal, Linkedin and so on companies shifted themselves to Nodejs. Even if you go for Ruby, it has GVL which again makes it work in single thead. If you want to manage concurrent requests in Ruby then you have to manage by introducing Rubinius/jRuby. If we talk about the deployment of Nodejs, it require less resources as compare to other. I have deployed inventory solution right now using Reactjs with Node.js stack and it is pretty much good. I have also deployed apps in Ruby as well. However, node is fast as compare to Ruby and you can scale it easily. I am not saying Ruby is bad. I work in Ruby as I told you above. But these are the real facts.

You can checkout this link :- https://softwarebrothers.co/blog/companies-that-use-node-js/

Well I would suggest you to go for Redis. I have used Redis in my inventory solution application with mongodb. I kept my all the data in mongodb and made copy of small information in redis. So that, I can get information after particular set of interval without querying the original database. And you need to update the last updated record in redis when there is any update in mongodb or sqlite.

As you mentioned that you are going to deal with lot of JSON or XML format in your app. Then I would suggest you to go for the MongoDB. It is very easy to maintain JSON records in mongodb and you can store XML as a string there. MongoDB will help to traverse lot of JSON/BSON records within fraction of seconds.