What database should I use for my App?

Iam currently working on an App for Android where you can see all available shisha tobacco, rate them and see other user reviews. For this I want to use a database where I store all the tobacco with its information and also the user reviews.

I already searched in Google for sites who offers databases (Playfab, Firebase, own sql server, ...). But Im so confused what to use and if its even the right move to do it with a database.

If you have any idea or expererience with things like this please let me know.

Thanks to all who help me.

 

Thanks for the fast response. I will have a look into it.

Edit : Are there any documentations about this? Because I only learned C# yet.

 

Some of your decision should come down to what kind of risk you're willing to tolerate. If you used a 3rd party database as a service provider, for example, they take care of some of the work for you but there is some risk that the service will eventually shut down which would require you to change to another service. If you instead host your own SQL database you'll eliminate the risk of a 3rd party service shutting down, but take on more risk regarding security or your own hardware failures. etc, etc

 

Completely agree with that. I would love to do it on my own server but as you said the security is the biggest problem because im new to php sql and all that serversided things.

 

Just use Sqlite and use a service like AWS, Yelp, Walmart. AWS requires you to have sales to use them now so probably not a good solution. Walmart has a free offering. Yelp is free. You wouldn't need to save local data that way.

If you're reall strapped for cash, find a web site that has this info, pull up the web view. Execute javascript calls and on load manipulate the Json ( or JScript ) out of it. A load event will fire.

If not Sqlite is your best bet and it's easy to export data or even the file.