rc3.org

Strong opinions, weakly held

Overpowered

I’ve never been entirely happy with CocoaMySQL, and after a mishap last night our relationship is at an end. Like most database clients, CocoaMySQL enables you to run queries, browse tables, and view the structure of your database. It has its problems (like hanging and locking the database when I run custom queries that return a lot of data), but for the most part, they’re avoidable.

Last night, however, I found that it just puts too much power in the hands of its users to be safe for everyday use. When you’re viewing the structure of a table in CocoaMySQL, you can modify the schema as well as view it. In fact, it makes modifying the schema really easy. You can just click on the data type for a column and change it from, say, varchar(255) to tinyint. In fact, it’s rather easy to make such a change accidentally. Needless to say, doing something like that results in losing every bit of the data in that column. Any sane person writing a database tool would ask for confirmation before applying such a page, perhaps even two or three times, especially when a schema change will result in data loss. CocoaMySQL doesn’t.

Time to find another database client.

6 Comments

  1. You might check out YourSQL – it’s being actively maintained, and may handle potentially destructive changes better.

    Personally, I’m mostly using PostgreSQL with Ruby schemas these days. I will admit that I wish there was a nice, graphical database client for Postgres on OS X, though.

  2. There’s an HTML error in this post that messes up its rendering for me.

    The link tag in the body starts with an single and ends with a double quote:

    <a href=http://cocoamysql.sourceforge.net/>CocoaMySQL

  3. Navicat is also a great product, but it’s not free — $99 for regular users, $75 for educational users. I’ve used it in free trial mode, but never pulled the trigger on a purchase…

  4. Is there something off about phpMyAdmin and phpPgAdmin keeping people away? I’ve been phpMyAdmin for years and love it. phpPgAdmin is in the same vein.

    http://www.phpmyadmin.net/home_page/index.php http://phppgadmin.sourceforge.net/

  5. i hope you at least submitted a bug report on the way out the door…

  6. I’ve been using the MySQL Query Browser for some time now and haven’t run into any issues.

    http://dev.mysql.com/downloads/query-browser/1.1.html

Leave a Reply

Your email address will not be published.

*

© 2024 rc3.org

Theme by Anders NorenUp ↑