Those in the know, like Michael Penney, Navicat is old news. And the head of our WBT committee recommended Navicat to me a while back but I did not get around to trying it. I wish I had followed his advice sooner.
Navicat is an offline Mysql database tool that displays the database like a lot of Excel files.
These can be edited and the changes are made to the database on the fly. One can aslo export in a variety of formats (such as an excel file) manipulate the database and then reimport. Scary stuff, and not recommended unless you know what you are doing.
But it is a lot faster than the online version (php mysql admin), it can do backups, it probably won't time out when doing a restore, and it has all sorts of other whizz bang functionality that I have not a clue about.
If only for creating quiz question categories, I think that it is going to be worth its $125, or $75 for the academic version price tag. More details here
http://www.navicat.com/education_license.html
Tim
It's probably worth mentioning that there are a great many similar programs available and while Navicat looks very slick and easy to get into for those who are less experienced with databases and is relativley inexpensive, people may wish to look at options that are free for personal/educational use or, even better, support open source alternatives.
On Mac OS X I've occasionally used CocoaMySQL which seems to be generally well reviewed.
I'd imagine that others have favourites and recommendations they could pass on too.
Dear David
Thank you! So there are free ones too? That sounds great. Why have I been using php mysql admin for so long, I wonder.
Has anyone tried
MySQL Control Centre for windows and Linux
http://sourceforge.net/projects/mysqlcc
which is recommended and perhaps affiliated to mysql
http://www.mysql.com/products/mysqlcc/
MySQL Administrator (this one on the mysql site too)
http://www.mysql.com/products/tools/administrator/
SQL Star in Java
http://sourceforge.net/projects/sqlstar
SQLyog with free edition (seems to do what I want it to do)http://www.webyog.com/
MyCon (also with a similarly endowed free edition)
http://www.scibit.com/products/mycon/features.htm
I may stick with the one used by my colleagues but, I am kicking myself for not getting one sooner. And some people, like you David, know that there is a lot of them around!
To other users labouring in PHP Mysql Admin land, run do not walk to the nearest MYSQL GUI Client download site.
Or is everyone else using a MySQL GUI Clients?
Thanks again,
Tim
Downloads and info on these at the MySQL developer zone at http://dev.mysql.com/.
I was thinking of purchasing Navicat when I found MyDB studio which works very well for me. I prefer it (so far) to Navicat and it is free, freeware.
Since it is free, and far faster than phpMyadmin, I recommend it to anyone who might need to adjust their database by hand one day.
Tim
These days I use HeidiSQL
Hi N
I know even less about ones for Postgres but a Google search yields....
http://www.sqlmanager.net/en/products/postgresql/manager
http://www.flex.ro/pgaccess/
http://www.datanamic.com/
http://www.quest.com/toad/
http://www.kazak.ws/xpg/
Tim
