General plugins (Local): Moodle Adminer
local_adminer
Maintained by 
Andreas Grabs
Andreas GrabsThis plugin is based on the great tool adminer.
The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL.
1164 sites
781 downloads
36 fans
This plugin is based on the great tool adminer.
The main advantage of this plugin is, it can handle different types of database. So it works with MySQL, PostgreSQL, Oracle and MSSQL.
Here are some of the key-features:
1) you can define trigger
2) you can change the order of fields
3) you can easy create or alter views
4) you can create stored procedures
5) if you rename a database so the database is altered and not copied like phpMyAdmin it does
6) you can define foreign key with referential integrity
To install it you only have to copy it into the "local" folder in your moodle-installation and running the notification-page.
After the installation you will find a new link "Moodle Adminer" below "Site administration -> Server".
Screenshots
Contributors
Please login to view contributors details and/or to contact them
I must admit a security issue did come up, but I am hoping it can be fixed so that only the Admin User has rights to access it, if it can be done that way. If it can then I am going to have a discussion with a number of people about how useful it can be. I am thinking here of just how much easier it will be to restore deleted users. Thank you.
Mi, 19. Nov 2014, 00:01
Sorry for the long waiting. Now I updated the adminer plugin. The moodle part has no big changes. The adminer now is based on 4.1.0
Please check and fix it if appropiate.
Thanks.
Yet you can simple integrate it in your repository by merging it. Use the steps below:
1. Go into your moodle repository
2. # git remote add adminer git://github.com/grabs/moodle-local_adminer.git
3. # git fetch adminer
4. # git merge adminer/v_27
That's it.
Best regards
Andreas
Do you plan to make Adminer officially compatible with Moodle 2.9, so that it can be installed/upgraded via the build in installer?
Best regards Andreas
Thanks for adminer; for my I prefer it to tools like MySQL workbench for my limited needs to interact with the database directly.
I've just come across an issue where adminer showed a blank page when launched. Debugging showed that run_adminer.php could access adminer.php. Our anti virus solution had decided that adminer.php was a 'hacking tool' and quarantined it. I suspect it interpreted the name as 'ad miner'. Just in case someone else has this issue.
Christoph
Adminer is a really great and useful tool!
Do you plan to make it officially compatible with Moodle 3.0 and 3.1, so that it can be installed/upgraded via the build in installer?
I am sorry for the long running. I am very buisy and I wanted the plugin compatible with php7. So it is now.
Best regards
Thank you