Database Manager Addon
Permalink
I am thinking about making an addon that would allow you to manage your database from your dashboard. In essence, it would be a CRUD application that would basically work like this:
- Select a table from a dropdown menu.
- The table is shown in a CRUD editor
- Ability to edit / delete / create entries
The purpose of the addon would be for site administrators to debug or simply change default data as they see fit.
I realize something like this could be a rather "risky" addon, but it would really be intended for advanced developers.
Any ideas? What do you think?
- Select a table from a dropdown menu.
- The table is shown in a CRUD editor
- Ability to edit / delete / create entries
The purpose of the addon would be for site administrators to debug or simply change default data as they see fit.
I realize something like this could be a rather "risky" addon, but it would really be intended for advanced developers.
Any ideas? What do you think?
I like the idea, very much!
Thinking I will move forward with this. Again, if anyone has any ideas, post them here!
As you said it's risky so you might want to consider built in options to disable the most risky possibilities. For example, the user would have to check an option to be given access to core tables.
You could also make them set a separate password to get access to the tables to add a layer of security in case the dashboard is compromised.
Another good option would be to keep track of the latest few actions (like C5 does) to be able to revert them.
Anything you can think of to ensure security and avoid mistakes on the user side should probably be implemented.
Good luck
You could also make them set a separate password to get access to the tables to add a layer of security in case the dashboard is compromised.
Another good option would be to keep track of the latest few actions (like C5 does) to be able to revert them.
Anything you can think of to ensure security and avoid mistakes on the user side should probably be implemented.
Good luck
Remo already has an add-on that uses SQL Buddy to manage a database.
http://www.concrete5.org/marketplace/addons/database-manager/...
http://www.concrete5.org/marketplace/addons/database-manager/...
OH NO! I didn't know this! I just submitted mine to the PRB. Well... that's a lot of hours I just wasted...
Thanks for letting me know.
Thanks for letting me know.
