Suggestion for an open-source MySQL frontend
I'm looking for a frontend for my MySQL database written in PHP.
I'm using Xataface at the moment and I'm trying to do an Android app that connects to it, but its rest API lacks support for file uploads, I started to customise it to add the functionality, but it's looking more complicated than expected; so I was wondering if there was something better around.
Any suggestions?
Posted Apr 7, 2017, 1:27 PM UTC
Shouldn't you build a server/backend for your application (which uses ORM for communicating with db and provides a REST API that your Android app consumes) instead of using a "MySQL frontend"?
Or am I misunderstanding your question?
maybe I didn't express myself correctly or I misunderstood your question.
Wouldn't what you suggest mean I need two php application on my server (1 for web and another for mobile)?
It can be the same application. But usually you have a backend that provides an API to your mobile client. This is not a generic thing but a custom written backend.
ORM can help you with easy database access.
You and u/EUreaditor are using alternate meanings of the the words "front-end" and "back-end".
You understand "front-end/back-end" as "client/server", web devs are used to using those as synonyms, but they aren't. They mean different things. The former is about the code's business responsibility, and the latter is about where the code runs.
If your MySQL is the back-end, a front-end for it would be an application that's intended to provide UI and access to the database for users in a simplified, streamlined way. Say like Microsoft Access. It's a front-end for databases.