SQL Buddy

General plugins (Local) ::: local_sqlbuddy
Maintained by Joseph Conradt
Integration of SQL Buddy for Moodle. Easy and secure MySQL database access and administration.
Latest release:
35 sites
23 downloads
9 fans
Moodle 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8

SQL Buddy: http://sqlbuddy.com

Lightweight and simple SQL Buddy allows you to manage your MySQL databases. You can create, update, and delete records from within Moodle with no external dependencies. No configuration necessary as it uses the database information in the Moodle config.

The database access is secure and limited to administrators only.

If you experience any issues, please submit an issue here.

**Please Note**  SQL Buddy currently only works with MySQL databases.

Screenshots

Screenshot #0
Screenshot #1

Contributors

Joseph Conradt (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Sun, Jan 11, 2015, 5:04 AM
    Hi Joseph,
    Thank you for the sqlbuddy plugin submission. Your plugin installed fine and appeared to operate as expected on my Moodle 27. I browsed a few db's on my test system and dropped a few tables without any problems. I have to admit I've been a long time phpmyadmin guy but sqlbuddy seems like an interesting alternative.

    The code checker plugin revealed a few minor style issues with the Moodle files in your plugin and a large number of style issues with the sqlbuddy code (mostly tab complaints). You should probably fix the style issues with the few moodle specific files version.php, settings.php etc.

    i tested this on my Moodle 27 that uses mysql. What will happen if someone tries to uses Moodle/postgres?
    Carl
  • Mon, Jan 12, 2015, 10:57 PM
    Hi Carl,

    Thanks for taking the time to review this plugin. I have made the necessary syntax changes and updated the plugin accordingly. Of course, I did not change the SQL Buddy source code, as that would have taken a while!

    SQL Buddy works with MySQL. I do not believe it works with PostgreSQL. I created this plugin for clients using MySQL needing a simpler database interface.

    Regards,
    Joseph
  • Tue, Jan 13, 2015, 12:22 AM
    Can we make it clear in the plugin description that this plugin works with MySQL sites please?
  • Tue, Jan 13, 2015, 12:34 AM
    Hi David,

    I updated the plugin description. Thanks for pointing that out!

    Joseph
  • Fri, Jan 16, 2015, 12:57 PM
    OK, so are we good for approval?
  • Anthony Borrow
    Sat, Jan 17, 2015, 5:31 AM
    Joseph - Many thanks for your work on this. I see nothing that would hold up approval. Since it is a tool for working with MySQL databases it makes sense that it will only work for MySQL installs. It reminds me of the https://moodle.org/plugins/view/local_adminer. I did a quick search to compare Adminer and SQL Buddy and found a note at http://www.adminer.org/en/phpmyadmin/ indicating that SQL Buddy is no longer actively being maintained so folks may want to keep that in mind. Peace - Anthony
  • Anthony Borrow
    Sat, Jan 17, 2015, 5:35 AM
    Joseph - One thing for us to consider before approving is whether you wish to rename the Github repository. When possible, I encourage folks to use the Moodle naming convention. So instead of https://github.com/CourseBit/local_sqlbuddy the better name would be moodle-local_sqlbuddy. This is not a requirement for approval but something I like to encourage just for consistency for those who do a lot of work with Git. Peace - Anthony
  • Sat, Jan 17, 2015, 6:12 AM
    Repository name has been updated to moodle-local_sqlbuddy.
  • Anthony Borrow
    Sat, Jan 17, 2015, 6:38 AM
    Joseph - With MDL-39840, it is now possible to include an environment.xml file with the plugin which could verify that the Moodle installation is using MySQL and if not prevent install on a Postgres database. The file would be ignored in versions prior to Moodle 2.8 but this may be a good way of testing that new functionality. Would you mind creating an environment.xml file and uploading a new version? If you prefer, you can just add an updated version for Moodle 2.8 with the environment.xml file. I'm going to go ahead and approve this but I think having the environment.xml file would be a nice addition and prevent someone from installing it if they are not using MySQL. Peace - Anthony
  • Tue, May 21, 2019, 12:48 AM
    HI Joseph:

    Thanks for the plugin! We had been using is in our Moodle 3.0, and now after upgrade to 3.6 this plugin gives an error : "Call to undefined function mysql_connect()". Would you please advise?
    Thank you!
    Leslie
Please login to post comments