External mobile database

Question

I’m new to mobile programming.

I use sqllite as a database. However, I can only create and use a local database. I wonder if there is another database or sqllite option to be doing a CRUD.

For example, for web development, there is Mysql, where you have a CRUD and any web page can change.

I would like in the mobile app, a way for several smartphones to connect to the same bank.

I was taking a look at a tutorial, in which the developer uses a web application, and shoots "get", then inserts...

But thinking of a scenario where I have an app that I register my portfolios, and then the app displays them.

I will then have to have an Area made in web, where register the portfolios, and then recover by the app through json.... The problem that will always need internet...

Or else to each new portfolio need to release an app update.

Answer 1

The most widely used current methodology consists of two applications: a Restful application, commonly API, hosted on a conventional web server that accesses a conventional database (Mysql for example). And an APP that consumes data through this API.

With respect to needing internet, not necessarily operations that do not consume data (like creating a new item) can be recorded first in a local database and only then, when there is internet, be sent to the api.

If you program in PHP a good Restful framework to get started is the http://www.slimframework.com/.