Highlights of the new features in this version are: user management, table triggers support, custom query placeholder support including lists, custom query text macros and tab triggers, much improved custom query autocomplete including table and field names, an overhauled CSV mapping interface including defaults and updates, improved printing support, a 64 bit build, and much improved stability including the addition of a crash reporter.

Some of the changes in this version include:

Interface

• MySQL system databases (i.e. mysql and information_schema) are now visually separated from user databases at the top of the list.
• Fix for occasional overlapping alert sheets.
• Addition of inline table, view, procedure and function renaming.
• Further reduction in the number of sheets that are run in an application-modal fashion that would subsequently prevent access to other connections.
• Addition of a preference to set the font (and size) of all result set tables that display MySQL content.
• Fix an issue where the background colour of the table list search field would appear different to that of the rest of the list.
• Ability to display or hide the MySQL server version in connection window titles via a hidden preference.
• Addition of a ‘Filter Content’ menu item to the ‘Table’ menu which places focus on the table content filter field.
• Addition of a ‘Filter Tables’ menu item to the ‘Table’ menu which places focus on the table list filter field if visible or the first table if not visible.
• Addition of a ‘Keyboard Shortcuts’ menu item in the Help menu that links to the online documentation wiki.
• Addition of a new table triggers toolbar icon.
• Addition of a help button on the query favorites editor that links to the online documentation wiki.
• Fix keyboard tab behaviour when selecting connection detail fields (standard, socket and SSH) on the connection view.
• Addition of a contextual menu in the connection favorites table view allowing the deletion and duplication of the selected favorite.
• Addition of a gear menu in the connection favorites table view allowing the sorting of favorites by name, host and type as well as in reverse order.
• Addition of a contextual menu in the connection view allowing the user to edit the selected favorite.
• Addition of a new preference to control whether or not anonymous system information is provided when checking for updates.
• Add a ‘Show create syntax...’ menu item to the table list ‘gear’ and contextual menus.
• Display CREATE syntax's for tables and views with a trailing semi-colon for easier copying and pasting.
• No longer append semi-colons to console error messages.

Connection

• Improved handling of server variable requests from certain versions of MySQL (specifically 4).
• Fix the hanging of secondary SSH tunnels when running in 64-bit mode.
• Fix for failed connections caused by whitespace and newline characters in the host and SSH host fields.
• Significantly improved connection loss and reconnection behaviour.
• Improved connection timeout behaviour.
• Allow arbitrary questions from SSH in order to support keyboard-interactive authentication methods, such as those used by RSA SecurID.
• Improved SSH tunnel proxy behaviour.
• Improved SSH tunnel behaviour of connections that don’t have a password in the user’s keychain.
• Improved stability of disconnections when switching tables.
• Improved CPU usage of SSH tunnel question/password dialogs.
• Improved connection failure handling.

Structure Tab

• Improved error handling when adding, removing and editing table fields.
• Ability to reset the AUTO_INCREMENT value of primary key fields by right clicking the primary key index.
• Fix an issue caused by duplicating table fields that are yet to be saved to the database.
• Adding and removing table indexes as well as removing table fields is now performed on a separate thread allowing the user to cancel the operation.
• Fix an issue that prevented the addition of multi-column table indexes because of leading and trailing whitespace.

Content Tab

• Improve large InnoDB table loading by replacing the ‘Fetch correct row count’ preference with the option of specifying a new table row count query level in relation to whether additional queries should be used. Options are never, only for small tables (<5MB) and always.
• Fix an issue caused by selecting ‘Copy as SQL INSERT’ after a table content filter has been applied.
• Fix for incorrectly escaping MySQL special characters when applying table content filters.
• Improved speed and lower memory usage when loading very large data sets.
• Fix for incorrectly encoding BLOB and binary TEXT fields when copying.
• Table sorting, filter criteria, scroll position and row selection are now preserved when switching between tables.
• Addition of the ability to reset the AUTO_INCREMENT value when deleting all records from a table.
• Fix an issue that caused the progress indicator and bezel not to disappear once a table sort operation was complete.
• Fix an issue that caused the following of table relation links when the initial mouse click was not on the link arrow.
• Duplicating table content rows now correctly loads deferred BLOBs and sets auto increment fields to NULL.
• Fix errors when deleting content rows which are currently being edited.
• Fix errors deleting multiple content rows on certain servers.

Query Tab

• Improved handling and stability of line selection for MySQL errors ending in numbers.
• Improved behaviour of editing query results.
• Ability to save the custom query history to disk as well as copy to the pasteboard.
• Ability to select filtered query history and favorite items using arrow keys.
• Significantly improved auto-completion for all database objects, including information about all tables and fields in any selected database.
• Ability to insert query favorites via user definable tab triggers.
• Ability to define nested snippets within query favorites (text macros).
• Ability to select predefined dynamic variables within nested snippets that are expanded upon use.
• Speed improvements when working with large amounts of text.
• Fix for partial syntax highlighting for very long lines.
• Fix for the synchronisation of query history lists if more than one instance of the same connection document (.spf) file is open.
• Ability to run any shell commands and scripts (Perl, Ruby, AppleScript, etc) within query favorite text snippet macros.
• Scroll position and selection are now preserved when editing custom query results.
• Option to enable auto-completion after a pause while typing in ‘Query Editor’ preferences and custom query gear menu.
• Option to specify the time delay of auto-completion.
• For untitled connections (non-SPF based documents) saving query favorites now defaults to saving them globally.
• Significantly improved thread safety when running queries.
• Fix an issue where selecting the ‘Clear Global History’ menu item would fail to do so in some circumstances.
• When switching to the custom query view always set the focus to the custom query editor.

Relations Tab

• Fix an issue when creating foreign key relationships with names that included reserved characters and names.
• Fix an issue that prevented the addition of foreign key relationships immediately after changing a table’s storage engine to InnoDB.
• Fix field relation referential actions not showing in certain circumstances.

Triggers Tab

• New triggers tab.
• Ability to add and remove triggers.

Information Tab

• Ability to reset or set to a specific value the primary AUTO_INCREMENT field of a table.
• Improve permissions error checking and handling when gathering various types of table information.

Import / Export

• Table triggers and functions are now included in MySQL dumps.
• Fix for save panel export options disappearing when exporting a custom query result.
• SQL import and export now correctly support the use of DELIMITERs.
• Procedures and functions are now included as an option when performing SQL dumps.
• Completely redesigned CSV field import mapper, allowing the choice of whether specific fields should be imported as well as the import method used, INSERT, REPLACE or UPDATE.
• Ability to set global variables in new CSV import field mapper.
• Fix for incorrectly displaying the read file size of CSV and SQL imports greater than 4GB in size.

Server Processes Panel

• Panel is now a separate window rather than a sheet on the current connection to enable active process monitoring.
• Ability to hide the process ID column.
• Ability to enable the use of SHOW FULL PROCESSLIST instead of SHOW PROCESSLIST.

User Manager

• New database user accounts manager.
• Ability to add and remove users and hosts.
• Ability to manage usernames and passwords
• Ability to manage global and schema privileges.
• Ability to manage resource limits.

Printing Support

• Significantly improved printing support, including:
• The inclusion of table names on print outs.
• If present the inclusion of table indexes when printing a table’s structure.
• The use of monospaced fonts in print outs to be consistent with user preferences.
• The inclusion of vertical grid lines in printed tables to be consistent with user preferences.
• Ability to print the table relations view.
• Ability to print the table triggers view.
• Ability to print the extended table information view.
• The inclusion of NULL values represented as the user’s NULL value placeholder when printing a table’s structure and indexes.
• Dynamic calculation of the size of page margins based on the paper size of the selected printer.
• The generation of print outs on a separate thread giving the user a chance to cancel the operation for large data sets.
• Present a warning to the user when attempting to print a large number of table rows. Current threshold is set to 1000 rows and can be changed via a hidden preference.
• Lots of print out style enhancements.

Other

• Sequel Pro is now fully 64-bit compatible on Intel systems running Mac OS X 10.6 (Snow Leopard).
• Restore default OS X behaviour of bringing the most recent window to the front when clicking the dock icon.
• Fix an issue where the renaming of a table failed when only the case changed.
• Bound three finger multi-touch right/left swipe event to trigger back/forward in table selection history.
• Restore the default standard shortcut of ⌥⌘H to hide all other applications.
• CHECK, OPTIMIZE, REPAIR, FLUSH, CHECKSUM and ANALYZE TABLE can now all be applied to multiple tables at once.
• Addition of in app crash and exception reporting to a new online repository viewable at http://log.sequelpro.com/ to improve the stability of Sequel Pro.
• Updated MySQL client libraries to version 5.1.44.
• Updated Sparkle auto-update framework to address a number of issues.
• Fix a stability issue caused when gathering table information and the user chooses to close the connection when the reconnect sheet appears.
• Fix an issue that prevented the addition of new tables with a CSV storage engine because of an initial nullable field.
• Lots of memory leak fixes.
• Lots of stability improvements and exception fixes.
• Ask for confirmation before deleting connection favourites.
• Allow .spfs to be saved with empty passwords or sockets.
• Fixed display of Growl notifications for long-running tasks.