Opinions about laravel with phpGrid for building back-office for mysql DB?

[curious-anonymous]

Hello everyone.

I am prospecting solutions for implementing a back office for managing a mysql database that contains over 50 tables and some tables have over 10 million rows.

Criteria:

• security
• total cost (including delivery time - which should be ASAP)
• complex filtering, grouping and aggregating
• dashboard with graphs and KPIs
• CRUD
• permissions
• total control over allowed operations
• UI

Until now I found phpGrig that is supposed to work with Laravel, that seems to offer in the paid version what I seek.

Can someone give me some feedback about them?

I noticed they work with raw query, which I don't like.

Inspired by this I also analyzed api-platform so far, but it is not an out of the box solution.

[macropay-solutions]

Hi.
From our experience mysql will not handle fast enough the aggregations needed on a dashboard with graphs etc. so, you will have to use a search engine or cache the data using long running crons that could block the DB.

If you don't find an out of the box FE + BE solution and want to build a FE solution, you could use our BE cruFd lib suite (which lacks the FE part). Also we saw phpGrid supports json data so maybe you could use their FE + our BE that gives results as json.