apioo / fusio

Open source API management platform
https://www.fusio-project.org
Apache License 2.0
1.87k stars 223 forks source link

Backend database management #553

Closed chriskapp closed 4 months ago

chriskapp commented 6 months ago

Currently at Fusio it is not possible to manage a database (change the schema), we only provide a readonly view with our connection inspection feature, there you can see all tables and columns s.

image

This means a user needs to either use an external database client like the mysql workbench or install i.e. an app like phpMyAdmin. In the past we have argued, that Fusio is not a database management tool and it should focus on the API management part. Also if you use Fusio as framework you use migrations to manage the schema and there is no need to manage the schema at the backend.

On the other side if users use Fusio in the cloud it would really help them having a direct way to change the schema. For example if you look at providers like Supabase they also provide a database management tool s. image

In general we could also integrate such a management tool directly into the Fusio backend so that every user can manage the schema at the backend. Maybe we can also add a config flag to indicate whether this feature is active.

chriskapp commented 4 months ago

Implemented with the 5.1 version