Tuesday, May 8th, 2007

phpMyAdmin Query Browser

Category: JavaScript, Library, Prototype, Scriptaculous, Showcase

Dougal Matthews has created a phpMyAdmin Query Browser as part of a University project that he has been working on in Edinburgh, Scotland. This is a prototype system that he plans on continuing over the summer, adding cross browser support, reducing the library dependences and fixing problems.

The project using Prototype, Script.aculo.us, and xajax.

phpMyAdmin Query Builder

Posted by Dion Almaer at 6:01 am

2.4 rating from 66 votes


Comments feed TrackBack URI

Just to add a note about the requirements.

It uses canvas at the moment so only will work on supporting browsers.

There are a number of known issues that i’m working on too. This is my first ‘real’ use of JavaScript and I feel I learned allot. So i hope to do many fixes and upgrades over the summer and hopefully it will be useful to the phpMyAdmin team.

Thanks for the post :)

Comment by Dougal Mathews — May 8, 2007

The page (or even the server) is not avail…

Comment by phroggar — May 8, 2007

There is currently problems with the mySQL server.

Thanks for checking up on it, I’ve contacted my host to fix it.

Unfortunately being a student I had to go for one of the cheapest hosts I could find.

If you are curious about testing the UI the testing controls will still all work. For a quick example click the ‘add 3 fixed tables’ and you will see most of the functionality. creating joins by dragging rows etc.

Comment by Dougal Matthews — May 8, 2007

This development will be highly appreciated by many phpmyadmin users!

Comment by Bart — May 8, 2007

If you can iron out the bugs and make cross-browser compat, it should be a very useful tool indeed. Good luck!

Comment by johno — May 8, 2007

I agree that this effort will be a welcome relief to their current interface. They haven’t even tried to make it current from the looks of things. Even just navigating into a table to make a change to a column takes ages. Ajaxian methods would speed it up immensely and make it more like an application.

Fingers crossed for you Dougal!

Comment by Mike Ritchie — May 8, 2007

We think there will be a huge market for GUI interfaces such as this that call upon AJAX and other stylish techniques and libraries in a quest to simplify an otherwise tedious task will do extremely well, as are we certain that you will too Dougal.

We’re really glad that AJAXian picked-up on this story, good job all round.

Comment by NI-Limits — May 25, 2007

Just incase anybody is still coming through here. The demo is offline at the moment, I’ve currently been going through a server change and I have not gotten around to getting it back online yet.

Comment by Dougal Matthews — June 25, 2007

Leave a comment

You must be logged in to post a comment.