arborrow / montserrat

A retreat management application written in Laravel
12 stars 4 forks source link

Consider adding Adminer to Admin section #477

Closed arborrow closed 2 years ago

arborrow commented 2 years ago

In order to facilitate testing using Homestead or Sail, it would be nice to have a UI to the database that is not as tricky to configure for working with the virtual development environments.

https://github.com/onecentlin/laravel-adminer/ seems to provide a nice integration within Laravel and is being maintained. For additional security, we could consider making this a development only type of plugin but I sort of like the idea of having a simple tool for accessing the database within Polanco itself.

arborrow commented 2 years ago

For now, I am going to postpone including adminer until I can better figure out how to use existing roles to prevent who has access to the login page. The current code, allows any authenticated user to access the adminer login page and I would rather have stricter control by either role or permission as to who can see it.

arborrow commented 2 years ago

This might be a workaround to #439 - similar to how phpMyAdmin is currently used toward allowing some custom SQL commands to be exported. While it would be flexible, the limitation of Adminer would be not be able to save the SQL queries as phpMyAdmin allows.

arborrow commented 2 years ago

I'm thinking for now it is best to stick with phpMyAdmin.