As you say Sqlite is about storing in the device. .
It does depend on the complexity/scale of your database.. and also the expertise and learning curve that you or moreover your company are prepared to invest in.
Also where is it to be located? I have just been and am going through this myself and chose Microsoft Azure to host it. There you can choose what you want to do whether you choose a NodeJS approach and then go with something like Mongo DB or set up a ‘website’ with sql and all those good things.
If I were implementing a simple mobile only app with simple ie not complex storage I would take the former approach. The project I am doing also needs a website and my expertise happens to be sql so I chose the latter. That doesn’t mean I couldn’t have done the former if I had the time to invest in learning Mongo and node.. which is why it depends:-) Hope that helps.
Ps. Azure is worth a look though as you can get going really easy and it looks like it scales well. Of course there are others to consider.
solved Database for android mobile application [duplicate]