Choosing the best database for a mobile application

Question

So, I'm pretty new to mobile app development. Currently, design documents for a mobile application are being created, and I want to add some information about which database solution I should use.

1) mobile application → online only → communication with the database

2) I have several web servers and it works (mysql mainly), can I use?

So my question is simple :) What solution should I use for my mobile application database. - Configure mysql database on server? - Use some kind of cloud solution? - Any API ratings?

• should be "best practice" for Android and ios.

All suggestions are welcome! Thanks everyone! You are amazing!

Answer 1

Tom. If you need data that will be available offline without an Internet connection, then you should use the SQLITE database, which is part of android / ios.

If your application stores data on a server, which, in turn, is used by another portal or other devices (sharing), consider storing data through a web server and mysql database.

So it depends on usage and sharing requirements. Saving data locally is of great benefit because it is faster, no network is required, data is always available, and not using the network also increases battery life.

Answer 2

Tom,

The most common solution to this problem:

1) Your application receives data through a web service on your server. You can use Soap solution based on XML exchange or simple REST access (simple HTTP request in GET or POST method) and use your own choice: XML or JSON. Today there are many solutions based on REST GET / POST with JSON file association.

2) After you want your application to go offline or just be more responsive, you can store the old downloaded data through the webservice in a local database. For this, in Android you can use direct access to the sqlite database and in iOs, you can use the CoreData api.

I hope he helps you.

Fabecc.