Raspberry PI作为数据库服务器

Question

I have a question regarding my database and being able to use my db everywhere.

So currently me and some friends are developing an application for android, this application reads alot from his data from a MySQL Database.

Currently we are working on the database design and tought by ourself, how to keep this DB open(24/7) to the app(for the users) and still keep it safe.

My tought is as follow, lets try to run the MySQL database on a Raspberry PI 2.

In our opinion this was do able, but we don't know how to start this.

We can't let the APP give access to the DB because anyone who decompiles our application will get access to our DB. It has to be safe!

So there has te be some portal (php?) In front of the DB who handles the incoming query's

Any suggestions?

Answer 1

You can build a REST API on your Raspberry PI with PHP and let your app access the database through this API. To make sure that the API can only be accessed from allowed sources you can add a middleware to the REST API to use something like an API-key to control the access.

The data that you pull from the API could be formated as XML or JSON.

Here is a micro framework for a PHP REST API: SlimFramework