7 Comments

Summary:

The open-source project team that released Sequel Pro 0.95 three months ago has just released 0.96. The update adds polish to the application, making working with it more pleasurable — if you can ever call working with databases pleasurable. They’ve also added some new core functionality […]

The open-source project team that released Sequel Pro 0.95 three months ago has just released 0.96. The update adds polish to the application, making working with it more pleasurable — if you can ever call working with databases pleasurable.

They’ve also added some new core functionality and optimized the backend. To me, this feels like more than a 0.01 update. With every update of Sequel Pro, the open-source project continues to close the gap between itself and commercial competitors such as Querious.

New Features

Sequel Pro now includes full SSH tunnel support built into the connection manager (which has also got a UI facelift).
SP096-ssh

There is a new Relations screen that lets you view and edit foreign keys for a table.
SP096-FK

Enhancements

By far one of my favorite new enhancements is the ability to filter the database’s table list. When the list gets larger than the displayed area, a filter box appears at the top, enabling you to quickly find the one you’re looking for. I’ve been using this a lot already.
SP096-tablefilter

When running custom queries, the results used to be presented in a static table. Now you can sort the results on the fly by clicking the column titles. Even better, for supported queries you can edit the results directly.
SP06-query

Browser-like table history navigation has been added, allowing you to go back to previous table views, which is great for flicking back and forth.
SP096-tablehistory

Significant Update

There are also plenty of smaller enhancements. Another favorite is the ability to select a record (either in the content view or after running a custom query) and then select “Copy As INSERT Statement”. This is so handy, I don’t know why it wasn’t there before. There are plenty of small changes like this, and almost every part of the application has had numerous bugs fixed.

In addition to all the new features, enhancements and fixes, this release is significantly snappier, and very noticeably so. The memory overhead is also greatly reduced. The developers have done some serious optimizing, and the results have paid off. See the full release notes for Sequel Pro 0.96 for a complete list of changes since 0.95.

  1. What’s wrong with using the MySQL GUI Tools?

    * MySQL Administrator 1.2
    * MySQL Query Browser 1.2
    * MySQL Migration Toolkit 1.1

    http://dev.mysql.com/downloads/gui-tools/5.0.html

    Share
    1. MySQL Administrator is capable as a server monitoring tool. I use it about once every twenty years—you can’t run a query with it!

      MySQL Query Browser is one of the worst products ever! It could not run multiple queries at once. Took me 30 minutes before realizing its quirky behaviors and after that, it went straight to my Trash.

      I’ve never used the Migration Toolkit but it sounds like only a one-time thing when you migrate from older databases.

      Share
  2. [...] more at The Apple Blog Categories: theAppleBlog Tags: Comments (0) Trackbacks (0) Leave a comment [...]

    Share
  3. MySQL Query Browser for the Mac is extremely buggy.

    Share
  4. MySQL QB constantly crashes.

    Share
  5. Thanks so much for the informative review.

    Share

Comments have been disabled for this post