I've a project where employees would have to report using the app so basically there will be following features in app login, reporting and only view the products of the company through app.
Now, the problem is that I need to import loads of employee data and that's where I am getting confused because I know how to import data from CSV files to SQL DB but I don't have any idea about how to do the same in firebase. Also I couldn't figure out the pricing difference between both which one would be more feasible in terms of price ?
If possible please try to generalize the answer in two parts :
So guys, which DB shall I use for it ? SQL or firebase as per my requirement ?
It would be really helpful of y'all if anyone can guide me through some insightful links to blogs or articles which can guide me in setting up a proper backend for my flutter app. Thanks !
Using firebase would reduce a lots of hard work, using firebase you can continuously listen to changes made in the database because it provides you a stream of data and subscribing would refresh your data in the UI automatically, futther more its price is reasonale and you can pay as much as you use.
But as per your requirement you should use SQL, because storing employee data in a RDB is much more maintainable than firebase or any other NoSQL db.