Raúl Santos
I went to phpmyadmin.net to consult their documentation on how to achieve something with phpMyAdmin.
I saw the announcement of phpMyAdmin 2.10.02 and, entertaining my usual and rather odd curiosity, I wanted to know when 2.10.0 came out. I checked a couple of announcements below and there it was. But then something caught my attention…
There is a new graphical relation manager, called Designer, available in database view.
Now, I have been trying to get DBDesigner 4 or MySQL Workbench working on Ubuntu for ages (without success), so when I saw the words “graphical relation manager” I automatically drooled on the keyboard.
While I was downloading the latest release of PMA, I recalled how previously today I was thinking that a graphical DB editor built with one of the nice Javascript/AJAX frameworks that are now so popular, would be a really cool thing. The problem is that such an editor would probably be unusable for databases with lots of tables. Well, now I have the chance to see for myself!
With a simple 7 table database, it works like a charm, instantly recognizing all the relations between the tables. I’m curious to see how it behaves with databases spaning dozens or even hundreds of tables.
Anyway, this probably means that I won’t be needing to lose countless hours, trying to get DBDesigner to work correctly or MySQL Workbench to work at all and stop contemplating the possibility of shelling out some heavy $$$ for a graphical DB design tool.
Thank you, phpMyAdmin! :)