The latest stable version of Sequel Pro is v0.9.7, which was released on Decemeber 21, 2009.

If you have trouble with the update, try downloading a copy manually.

Highlights of the new features in this version are: a new server processes panel, a query favourites editor, a filter editor, improved tooltips including image previews, a pagination interface for the content view, much faster and more stable import and export, early support for document-based connections, the ability to stop custom query and content loads, and the introduction of threading for some tasks.

Once again this version contains too many changes to mention in depth; a selection of the changes includes:

Interface

• Improve Growl interaction, only Growling if in the background or for long tasks.
• Addition of a new about panel.
• The default view can be set in Preferences; by default the last used view will automatically be selected.
• Addition of new tooltip methods, including multiline previews and image previews.
• Save the status of “Check spelling while typing” in field editor sheets.
• “NULL” and “(not loaded)” placeholders are displayed in grey.
• The preferences interface has been tweaked.
• Allow insertion of the NULL value via the Edit menu.
• The monospaced font preference will now apply to more views and use Monaco as the default font.
• Addition of a new server processes panel (available via the ‘Database’ menu).
• Ability to kill queries and connections from the server processes panel.
• Ability to filter and save server processes.
• Addition of a number of menu items to the Dock menu.
• Follow the OS X user interface guidelines and make the Cancel button the default on destructive tasks.
• Addition of keyboard shortcuts for the non-default confirmation button on destructive tasks - ⌘D for Delete, ⌘R for Remove, ⌘T for Truncate.
• Make a number of warning and information dialogs clearer.
• Make a large number of sheets and dialogs non-modal, allowing use of other windows (eg Add New Index, Add New Database, Create Table syntax, Server Variables, Add Relation, Table editing sheets)
• Thread initial database loads.
• Thread view switch loads.
• Sequel Pro is now an editor for .sql files, opening them in the Custom Query view or offering to import depending on size.
• Addition of basic procedure and function information in the Table Info pane.
• Addition of a “Provide Feedback” menu item in the Help menu.
• Allow copying server variables from the server variables sheet.
• Addition of Copy and Save buttons to the Create Table Syntax sheet.
• The view History can now be navigated using entries in the View menu, including keyboard shortcuts.
• Clicking and holding the history buttons will now show a list of history states to select.
• Improve window cascading, especially for large windows.
• Allow use of the Return or Enter key to edit some lists and tables, including the table list.
• Display the name of the field being edited at the top of the field editor sheet for context.
• Add ⌘-Return as a shortcut to save and close the field editor (in addition to Enter/FnReturn).

Connection

• Allow the OS or users’ preferred SSH agent to handle public and private keys.
• Add ControlMaster compatibility to SSH tunnels.
• Offer to reconnect directly to the old SSH tunnel if another tunnel is already bound to the remote port.
• Preserve the ‘host’ field when switching to and from Socket connections.
• Addition of support for saving connections as “.spf” connection files.
• Save window state within .spf connection files, including history.
• Add Open and Open Recent support for .spf connection files.
• Improve connection stability on connections with high packet loss or a tendency to drop.

Structure Tab

• Allow the deletion of fields which are parts of foreign keys and indexes by deleting dependencies automatically, after prompting the user for confirmation.
• Allow default values in BIT notation when creating BIT fields, eg b’1′.
• Addition of support for adding BINARY and VARBINARY fields.
• Preserve any comments and column details unsupported by the interface when editing or moving columns.
• Fix checkbox display on Mac OS X 10.6.

Content Tab

• Addition of a new pagination interface, replacing the old LIMIT text box.
• Allow easy jump to deep pages and control of pagination preferences by clicking on the pagination text.
• Content loads, content filters, and content sorts can be stopped during loading.
• Content loads, content filters, and content sorts are threaded and show progress where data is available.
• All content loads are faster and use less memory.
• A content filter editor is available via the Filter comparsion dropdown, allowing the creation of custom filters which can be saved either globally or per-document in .spfs.
• Placeholder support in the custom filter editor, including up to two arguments.
• Addition of a BETWEEN filter operator and fixes to other filter types.
• Correctly display content within BINARY/VARBINARY fields.
• Improve the display of the row count and update row counts as table contents change.
• Vastly improve deletion of large numbers of rows.
• Fix crashes when switching tables after re-sorting the content view.
• Columns with “on update CURRENT_TIMESTAMP” now have the timestamp inserted when performing GUI edits.
• Improve ‘(not loaded)’ deferred loading text/blob placeholder usage.
• Maximum field lengths are now respected in the interface to improve usability and reduce double entry.
• Fix double content reloads in some circumstances (including filtering).

Query Tab

• Custom queries can now be stopped during execution.
• Custom queries are now threaded, allowing the use of other windows and displaying results incrementally.
• Custom query loads are faster and use less memory.
• Improve error highlighting.
• Addition of a query favourite manager, allowing naming of favourite queries, filtering by name, and much improved editing of favourite queries.
• Allow the query history list to be filtered within the menu.
• Add options to allow history and favourites to replace editor content or to be inserted.
• Fix crashes on certain types of queries.
• Correctly quote database names when saving edits of custom query result rows.
• Fix issues when running multiple queries when the last query is empty.
• Allow saving the contents of the custom query field to a SQL file.
• Custom query error text is now selectable.
• Improve custom font saving.

Table Relations Tab

• Support foreign keys within the same table.
• Improve ON UPDATE and ON DELETE lists and support.
• The table relations table view will now observe the monospaced font and vertical gridlines preferences.

Import / Export

• Exports are now threaded, allowing interaction with other windows during export.
• Exports can now be cancelled.
• All imports and exports have been rewritten to work in streaming fashion, resulting in much lower memory usage and the ability to work with very large datasets without crashing.
• Make all imports and exports much faster.
• Improve speed and stability when setting Field Mapping before CSV imports, and display the Field Mapping much earlier in the import.
• Improve progress reporting for import and export for both feedback and accuracy.
• Improve parsing of CSV and SQL files.
• Fix crashes caused by the connection disappearing during imports.
• Improve SQL export of views.
• Fix a syntax error in exported ER dot files.
• Addition of the UTF-8 BOM to exported SQL files to improve editor compatibility.

Query Console Log

• The query console now includes an optional connection column.
• Table headers are now displayed.
• Console columns can be reordered and observe the vertical gridlines preference.
• Timestamps are now shown using the format set in System Preferences.
• Logging can now be controlled in the Preferences to work at different levels (Interface, Custom Queries, Import & Export, Errors) with Import & Export logging disabled by default.
• Make copying large numbers of queries from the Console Log window much faster.

Other

• Addition of some AppleScript support, fixing compatibility of standard commands and adding some Sequel Pro commands.
• Correctly support editing in “UTF-8 via Latin1″ connections
• Improve compatiblity with table definitions.
• Reset the AUTO_INCREMENT value when duplicating tables without their contents.
• When duplicating tables duplicate foreign key references correctly.
• Fix Quick Look in the field editing sheet on Mac OS X 10.6.
• Table renames, duplicates and additions perform more error checking and handle errors more gracefully.
• Improve deletion of multiple tables including much better error handling.
• Handle very large table sizes, row counts, and free space.
• When error occurs when saving items to the Keychain, alert the user and suggest a keychain repair.
• Fix a bug in the field editor sheet causing changes to not be saved if the content length never changed.
• Improve undo in the field editor sheet.
• Added code signing - all future releases of Sequel Pro will be signed to avoid keychain access prompts.