since i’ve been doing a lot o database maintenance lately (you won’t believe how many errors can be produced when 84 persons register themself…) i was looking for an easy way to do it.
The whole registration process for the suicmc04 runs on a MySQL database on the gna-server (thanks b. and chris for hosting us!).
Äbu, who did all the backend programming for us installed phpMyAdmin on the server, which is quite a good way to tinker with the database, but i didn’t like it that much. so i was looking for another way to get to the data. dbSuite Admin Tool is a well renowned Software to connect to your database which i used up to now. But yesterday evening i found the best tool up to now!
CocoaMySQL is the tool i’ll be using from now on. It’s available for free and under the GPL license which means the app and it’s source code are free (but you might want to donate a buck or two).
In addition to that it’s also a lot spiffier than dbSuite Admin and phpMyAdmin, you can browse the database very fast and managing the database and editing the values is a breeze. And because you can decide to show the console you learn all those MySQL-terms, so maybe once i’ll be able to do all this via the command line :-)
if you ever need to remotely manage a database (and need a GUI to do it, like i do) then you should give it a try with CocoaMySQL!
Not so far I have found new cool tool to work with mySQL – Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview
That seems like a powerful tool, nice.
I’ve switched to http://code.google.com/p/sequel-pro/ for my database admin stuff.