r/PHP•
EUreaditor

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

27
Compizfox•

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?

4
EUreaditorOP•

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)?

1
Compizfox•

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.

3
LtAramaki•

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.

2
aRandomNameHere•

For this approach, I'd use something like an api Middleware that you can pass your json to both your mobile and web platform in the exact same format. Lumen is a nice, light and clean piece of software that will do it for you. You definitely need something that you can build your own rest queries on top of though.

3
maus80•

I wrote an (open source, MIT license) script in PHP that may help you. It adds a full-featured (including file-upload) REST API to a MySQL database. You can call it from Java in your Android app or use the examples that may be used in an Ionic/React app.

2
EUreaditorOP•

Looks nice, not really what I'm looking for though. The part I'm struggling with at the moment in xataface is getting it to validate inputs without rewriting all the logic myself. But I'll definitely look into yours and see if it can help me in case I have to continue with xataface

1