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.
Sequel Pro now includes full SSH tunnel support built into the connection manager (which has also got a UI facelift).
There is a new Relations screen that lets you view and edit foreign keys for a table.
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.
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.
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.
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.