I’ve been using Adminer on a project and think it’s a great solution for those looking for a quick CRUD and not too worried about the visuals or permission system.
It supports multiple databases, including MySQL, MariaDB, PostgreSQL, SQLite and MS SQL - essentially everything that Wappler supports.
Adminer itself is something comparable to phpMyAdmin or a database editor you might use. However, there’s also Adminer Editor which aims to be more like a CRUD with a separate set of login credentials different from the real database user and password.
Because it’s just a single PHP file, it’s very easy to drop into a Wappler website. For NodeJS, it’s a bit more tricky, but this project can serve as inspiration:
It would start a PHP server on a specific port just to serve Adminer.
Ideally, Adminer Editor authorization would be locked behind Wappler’s permission system, for a specific role (e.g.: admin). As far as I can see, it’s not appropriate to lock different table permissions into different roles - either you have access to the whole DB or not
https://www.adminer.org/en/extension/
Last updated: