Softpedia >Mac >Internet Utilities >Sequel Pro >  Changelog

Sequel Pro Changelog

What's new in Sequel Pro 1.1.2 Build 4541

Apr 3, 2016
  • Fix an issue where Sequel Pro would randomly crash when checking connections (#2186)
  • Fix an exception that could occur when trying to view a damaged table
  • Fix an issue (affecting mostly Russian & Asian users) where Sequel Pro would error if the mysql server truncated a column name (#2150)
  • User Manager: Fix an issue where changing a password and adding a host at the same time resulted in query error (#2427)
  • Potentially fix a random crash (#2436)

New in Sequel Pro 1.1.2 Build 4532 RC 1 (Feb 26, 2016)

  • Add comprehensive locking to SPDataStorage.
  • Experiment with #2163 (unloadedColumns not loaded). This commit may cause performance issues for some users - please file a bug.

New in Sequel Pro 1.1.1 Build 4529 (Feb 21, 2016)

  • Change a while() to do while; to help code analysis
  • Add log message (possibly related to #2258)

New in Sequel Pro 1.1.0.1 Build 4500 (Jan 29, 2016)

  • Fixes a security vulnerability involving the Sparkle Updater reported by Radoslaw Karpowicz (CVE-ID in progress)

New in Sequel Pro 1.1 Build 4499 (Dec 17, 2015)

  • NEW FEATURES:
  • Favorites can now have a color (eg, RED for production databases)
  • Emoji are now correctly supported in the query editor 🎉 (#2044)
  • The table list context menu now allows opening tables in new Windows when holding down the Option key (#2015)
  • There is now a fast, keyboard based way to switch between databases (Menu: Database > Go to Database
) (#1857)
  • Added an option to disable backticks when doing code completion (#764)
  • The selected database can now be shown in the Query Console (#1938)
  • The name of the connection favorite can now be used as an export filename token
  • Added basic support for MySQLs reworked DATETIME time in 5.6.5+ (#1867)
  • Added support for TLS/SSL over SSH forwarding.
  • Added support for sorting columns in custom query results (Thanks to @miroslav)
  • Binary columns can now optionally be displayed in HEX encoding
  • Added support for fractional seconds (MySQL 5.6.3+) (#1515)
  • Updated mysql client libraries to 5.5.42:
  • Can now use SHA-256 client certificates with TLS connections (#2071)
  • SSL2.0/3.0 connections are no longer supported, upgrade to TLS.
  • Preferred cipher suites can now be configured in Preferences.
  • utf8mb4 can now be selected as connection encoding:
  • utf8mb4 is now also put at the top of charset lists (along with utf8)
  • IMPROVEMENTS:
  • Favorite groups can now be exported and imported again
  • Improved support for HiDPI (Retina) screens
  • Columns to show/hide in Structure view can now be picked by ctrl-clicking on the table header
  • Preferences will now display a little help text regarding Growl and Notification Center
  • Updated Growl framework to 2.0.1
  • Background Threads will now show their purpose in Xcode, spindump and crash reports
  • The pagination popover will now use the native OS feature on OS X 10.7+
  • Disabled OS X' (not so) "smart quotes" in the Bundle Editor (Thanks to @uxp)
  • ctrl+H (Help for MySQL keyword) can now be reassigned like any other command (#1974)
  • Performance and memory improvements (especially for data loading)
  • Disabled some unsupported UI functions when the CSV storage engine is being used. (#1546)
  • Added yet another option to disable the field editor mode for those accidentally triggering it (#1579)
  • SQL files opened with Sequel Pro can now be saved back to disk again (#1805, #1011)
  • The arrow button to follow a foreign key relation is now disabled on NULL values (#1790)
  • Updated look for OS X Yosemite 10.10:
  • Fixed the cog menus positioning being off
  • FIXES:
  • Disable "smart" substitutions for field editor sheet (fixes #2154)
  • Fix an issue where Sequel Pro added a NUL byte to the end of every query (fixes #2184)
  • Fix an issue where LIKE filters were changed to BINARY if reloading a table via cmd+R (fixes #2179)
  • Fix an exception when trying to remove a query favorite via its context menu (fixes #2161)
  • Fix a rare exception when opening a session via "Open Recent"
  • Fix an exception when trying to sort favorites by "host" or "type" while groups are present (fixes #2151)
  • Fix a crash when the database popup was removed from the toolbar (fixes #2147)
  • Fix an exception when no database was selected and the user tried to export a query result with the "database" file name token (fixes #2145)
  • Fix a crash when displaying the server process list (fixes #2114)
  • Fix a popular exception when a user tried to edit a field with a lost connection and then chose "disconnect" when Sequel Pro asks to reconnect (fixes #2137)
  • Fixed a rare crash when SSH connections failed (caused by a race condition) (fixes #2132)
  • Fixed an issue with resetting auto_increment to a value > 1000 (#2130)
  • Fixed a data corruption issue when editing custom query results and certain conditions were met (#2113)
  • Fixed helpful messages for FK creation errors no longer being shown for MySQL 5.5+
  • Fixed an issue where copying text from the query console could result in an exception in some scenarios (#2111)
  • Fixed tooltips being placed on the wrong screen in some multi-monitor setups
  • Fixed a case where Sequel Pro was not able to handle invalid characters for the selected charset (#1207) (Thanks to @liuteng)
  • Partly fixed an issue where the SSH inputs might be cut off on the connect screen
  • Fixed some runtime console warnings which were caused by changing the interface files
  • SSH Forwarding did not work with OpenSSH 6.7 and newer (#2050) (Thanks to @chn42)
  • Fixed a crash when selecting an SSH key (#2042)
  • Fixed a crash related to "Display binary data as hex" and closed tabs
  • Fixed an issue with escaped mirrored snippets in Query Favorites (#2049)
  • Fixed a minor UI issue when cancelling an SSH connection attempt
  • Fixed Import not working for new users on OS X 10.6
  • Fixed some cases where the UI was updated from a background thread
  • Fixed the CSV field mapping dialog being horribly slow on 10.10 for some users (#2025)
  • Fixed a crash that could happen when selecting "Overwrite existing files" (#2010)
  • Fixed an issue where changing the query favorties/history would cause an UI inconsitency when the list was filtered before (#2040)
  • Updated some outdated URLs to our website
  • Fixed the pagination popover on older versions of OS X.
  • Changed some width calculations in split views that caused a ...left the subview frames in an inconsistent state: console warning
  • Fixed a crash when closing the User Manager (#1961)
  • Fixed an issue where duplicating a database would cause fields with value 0 and auto_increment set to be assigned a new id (#1978)
  • Fixed import of bzip2 compressed files (issue introduced after 1.0.2 release) (#1983)
  • Fixed an issue for SSH users who have configured the ControlMaster feature (Thanks to @schmurfy)
  • Fixed an exception on export if certain conditions where met (#1968)
  • Quickly switching between tables would cause a "Query execution was interrupted" for some users (#1902)
  • Importing new Bundles by opening them in Finder or dragging them onto the Sequel Pro icon was broken (issue introduced after 1.0.2 release) (#1909)
  • Fixed an issue where CSV imports could not be started if a zero-length field was set to not be imported
  • Fixed a multithreading issue that could cause crashes when loading table data (#1884)
  • Fixed an issue where the Relations view would display outdated data (#1591)
  • Relations across database boundaries were displayed wrong (#1369)
  • Fixed an issue where SQL exports might cause invalid SQL if database contents changed during export (#1726)
  • Fixed a possible exception related to the display of line numbers in the query editor
  • Fixed an exception related to tabbing through fields in Structure view
  • Fixed some possible exceptions when adding new fields to a table
  • Fixed an exception on 10.6 when clicking on a certain point in the table list
  • Fixed an issue with row counts when reloading tables (#1789,#1788,#1787)
  • Fixed a hang when there was a query error (#1783)
  • Fixed an issue with graphic artifacts on certain graphic cards and reduced CPU usage along the way (#1678)
  • Fixed hangs when adding columns to large tables after the table has been viewed already (#1710)
  • MORE:
  • Field Editor now uses the newer "find bar" instead of the "find panel" on supported OS X versions (#2148)
  • Allow to select a custom SSH binary (which we totally do not support, but hey, a feature is a feature) (#2083)
  • Updated copyrights to 2015
  • Removed use of an Apple private API method, blocking App Store compatibility (Thanks to @origsun)
  • Updated the Xcode project to use the 10.8 SDK
  • Fixed runtime and compiletime warnings due to deprecated functions
  • Fixed some memory management issues
  • Internal changes due to the migration to git and GitHub
  • Updated handling of several "Save" dialogs to newer OS X SDK
  • General code refactoring:
  • Unified some duplicate code
  • Replaced some "magic numbers" in code with constants
  • Replaced NSArray/NSDictionary initialization and access with the ObjC literal syntax where safely possible
  • Replaced boxed integers, bools with ObjC literals
  • Updated some code to use NS_ENUM
  • Fixed lots of clang compiler warnings

New in Sequel Pro 1.0.2 Build 4096 (May 8, 2013)

  • Interface:
  • Fix blurry text in a number of SQL text views
  • Always run on Integrated Graphics on machines with both integrated and discrete to improve power consumption
  • Correctly restore the tab bar label when cancelling a connection
  • Fix high CPU usage when displaying certain blocking alerts
  • Improve menu items’ enabled state following a connection
  • Fix display of information when using the Navigator
  • Connection View:
  • Fix crashes when importing favourites on the connection view
  • Scroll to and select newly created favourites after import
  • When selecting a favourite with no password, don’t set the focus on the password field at once, but set it as the next responder for the tab key
  • Fix a crash if duplicating a favourite and denying keychain access
  • Fix odd behaviour when trying to edit or autogenerate the name of SSH connections
  • Support favorite imports from old preference .plists
  • Connection Handling:
  • Fix a range of crashes related to SSH connections in certain network/server conditions
  • Fix occasional invalid connection details loaded from .spf and .spfs files suring startup or when duplicating connection tabs
  • Fix the “Add to Favorites” menu item’s appearance and functionality
  • Translations:
  • Fix support for export path tokens containing spaces, including fixes for the French translation
  • Improve localisation support across the interface
  • Fix and update translations
  • Add a Spanish localisation – with many thanks to Juan Pablo Atienza MartĂ­nez, with help from Pablo Oneto, Jaime Martin, and Samuel Abraham de Vega GarcĂ­a
  • Tables List:
  • Fix error dialogs when selecting tables with double dashes inside field names
  • Add an option to “Force delete” tables in the table deletion confirmation dialog to disable foreign key checks, and display a more helpful error message when deletion fails due to foreign key checks
  • Structure Tab:
  • Fix handling of BINARY properties when reordering and editing fields
  • Fix unsetting of BINARY properties on fields
  • Fix errors editing or reordering fields on server versions which do not support character sets or collations
  • Improve interface handling and query generation on server versions which do not support character sets or collations
  • Fix errors when converting some string types to blob or binary field types
  • Content Tab:
  • Change ‘=’ and ‘!=’ filters to be case- and collation-insensitive by default, allowing the Shift key to trigger a BINARY exact match
  • Fix escaping of backslashes when using the ‘=’ or regex content filters
  • Fix handling of primary keys using both multiple keys and specified field lengths
  • If deleting a date or time field which allows NULL, set the cell value to NULL
  • Import custom content filters into the Global group by default if no saved document is available
  • Scroll to and select newly imported custom content filters
  • Fix display truncation of the value of BINARY string types to 256 characters
  • Fix crashes when displaying certain types of BIT data
  • Query Tab:
  • Combine the “Run All” and “Run Current/Previous/Selection” buttons into a single button
  • Add a dropdown menu to the single button to allow setting the default action and use of the alternate action
  • Move the Run commands from the “gear” button to the Run button dropdown for easier discovery of shortcuts
  • Fix SQL parsing inside unterminated delimiter statements
  • Import custom query favourites into the Global group by default if no saved document is available
  • Scroll to and select newly imported query favourites
  • Apply the theme background to the query favourites SQL editor
  • Set text entry focus to the custom query editor if the view is active when the window is opened
  • Adjust the keywords list to fix autocapitalisation of “ON”
  • Fix query execution timing for queries with no result sets
  • Update the query status results to no longer always suggest an error has occurred
  • Relations Tab:
  • Support basic display of all the fields in composite foreign keys
  • Import / Export:
  • Fix errors that could occur when generating new tables from CSV imports
  • Show a clearer error message if a target export folder is no longer available
  • Fix errors when exporting views with timestamp fields allowing NULL
  • Server Processes Panel:
  • Fix process list kill query and kill connection actions on filtered process lists
  • User Manager:
  • Improve user manager data loading to significantly speed up opening the user manager
  • Fix support for schema permissions for the Anonymous user
  • Add support for displaying ‘%’ and ” databases if already specified
  • Highlight databases in the user manager that already have permissions specified for the selected user
  • Fix crashes in the user manager when fields don’t validate but the record attempts to apply changes anyway
  • Improve data sharing for further speedups
  • Other:
  • Fix database creation to correctly use specified database encodings
  • Display the server’s default character set when creating a database
  • Ensure that switching databases without selecting tables updates the connection encoding correctly
  • Fix errors when deleting custom content filters or query favourites while editing them
  • Add a spotlight comment to allow easy location of Sequel Pro with search terms other than the name
  • Improve upgrades from previous preference versions

New in Sequel Pro 1.0.1 Build 4004 (Jan 30, 2013)

  • Fixes crashes on launch some users were experiencing.

New in Sequel Pro 1.0 Build 3991 (Jan 29, 2013)

  • License change:
  • Sequel Pro has been updated and where necessary rewritten to allow us to relicense the code as MIT (previously GPLv2).  Many thanks to all the contributors who agreed to this license change, including Lorenz Textor, Tristan O’Tierney, Kotaro Funakoshi, David Buxton, Stuart B. Glenn, Carsten BlĂŒm, Greg Hulands, Abhi Beckert, Matt Langtree, Ben Perry, Mark Townsend, Rowan Beentje, Stuart Connolly, Marius Ursache, Jakob Egger, Hans-Jörg Bibiko, Jim Knight, David Rekowski, Max Lohrmann, Stefan SchĂŒĂŸler, Aaron Linville, and contributors who have requested they remain anonymous.  Thank you also to MCPKit developers Serge Cohen and Bertrand Mansion for making their code available to previous versions of Sequel Pro.
  • Interface:
  • Add a delicious new icon by Kenichi Yoshida (with many thanks to Panic, Inc)
  • Add Retina versions of some connection icons and elements
  • Display multi-line table content and query cell values on a single line, displaying visible line break characters
  • Automatically enter sheet editing mode for multi-line cell values
  • Allow up/down arrows to navigate within multiline cell display instead of automatically moving row
  • Enable the encoding used to view databases to be changed on all tables
  • Fix find/replace usage within edit sheets
  • Automatically resize edit sheets that are larger than the current screen
  • Improve opening of windows when the application is opened in the background
  • Improve a number of split view resize errors by rewriting all split view handlers
  • Add a menu item and the standard keyboard shortcut (^⌘F) for taking a window fullscreen
  • Connection View:
  • Merge the favourites editing preferences interface into the connection interface
  • Add support for managing and grouping favourites into folders in the connection view
  • Save the state of expanded and collapsed groups across sessions
  • Add a Quick Connect entry at the top of the interface for a blank connection interface
  • Mark edited favourites appropriately and allow them to be saved as new favourites or update the existing favourite
  • Fix and improve password handling
  • Improve favourite sorting
  • Add support for testing edited connections
  • Improve favourite name generation when one is not provided
  • Fix display of an active SSH/SSL key field
  • Add remove item, rename item and duplicate items to the connection interface gear menu to match the context menu
  • Improve cancellation of SSH and MySQL connections
  • Add Zend Server CE compatibility to the default socket search list when left blank
  • Allow hidden files to be viewed in SSH/SSL key selection dialogs
  • Translations:
  • Added a Swedish translation (many thanks to Peter HĂ€ggstrand)
  • Added a French translation (many thanks to MichaĂ«l Gallego, with help from Dominique Guardiola, FrĂ©dĂ©ric Latour, SĂ©bastien Guy and Lou Ferrand)
  • Added a Japanese translation (many thanks to 掟 èȘ , with help from 橘 ゆり驙)
  • Updated German and Russian translations for more of the interface
  • Made more strings and interface components localisable
  • Improve localisation spacing
  • Tabs:
  • Fix animation errors when hiding and showing the tab bar
  • Fix drawing errors when dragging tabs around
  • Fix display of the tab bar in certain window states
  • Bundles:
  • Improve stability when using bundle contextual menus
  • Tables List:
  • Added a “Copy Create Table Syntax” to table contextual menus
  • Fix scroll-ability of very long table CREATE syntaxes in the display sheet
  • Display the table engine in the table info panel
  • Give the table list focus on initial connection and when switching databases
  • Improve the row count in the table info panel to always correctly show accurate row counts for InnoDB tables when the preference value is set
  • Structure Tab:
  • Display column default encodings and collation when available
  • Fix some exceptions during index creation
  • Improve visibility of fields in the add index sheet depending on selected field
  • Improve handling of required sizes when adding indexes
  • Update the indexes view to respect the vertical table view gridlines preference
  • Clearly show the default encodings selected and used when creating new tables, and improve default detection
  • Content Tab:
  • Use primary keys to preserve table content selection when refreshing or filtering tables where possible
  • Improve query used when deleting all rows to lessen the chance of accidentally deleting rows added outside the application
  • Rename “is” filters to “=” to make their purpose clearer, and make it perform a binary equality check
  • Move the LIKE filters to just below the new “=” filters
  • Add support for “matches RegExp” and “does not match RegExp” default filters
  • Add new custom filters to the Global list rather than untitled connection favourites, preventing their loss
  • Improve validation of FLOAT type data against maximum lengths
  • Speed improvements, especially when loading large data sets
  • Reduce flicker when refreshing the content view
  • Fix undo and clearing of the table content filter field having unexpected effects
  • Fix errors when cancelling sorts of table content
  • Reduce the number of queries used for certain operations
  • Reset pagination when a table is filtered
  • Alter keyboard shortcuts and menu items: ⌘F now sets the focus on the table filter field and ⇧⌘F displays the advanced table-based table filter.
  • Rework and improve the advanced table-based table filter
  • Query Tab:
  • Exchange the positions and shortcuts for the “Run All” and “Run Current/Previous/Selection” buttons
  • Prevent query results from being exported when they are still being downloaded
  • Improve line number drawing
  • Improve editing of the custom query strings while the view is being syntax highlighted
  • Improve custom query placeholder insertion and value replacement
  • Improve autocomplete popup position and handling
  • Set the enter key and the right arrow key to select an active autocompletion suggestion
  • Improve autosizing of the query error area
  • Fix query selection changing after a query finishes executing
  • Improve help search updates and links in help results
  • Add new query favourites to the Global list rather than untitled connection favourites, preventing their loss
  • Add four more default Query Editor custom themes: Monokai (thanks to Wimer Hazenberg), Nemo, Pixely Night, and The Pixel
  • Fixed display issues when reordering custom query results when the results view was scrolled horizontally
  • Triggers Tab:
  • Add the Triggers button to the default toolbar set
  • Fix clearing of the new trigger dialog after use
  • Re-open the add/edit trigger window if a trigger can’t be saved
  • Work around some MySQL versions appending null bytes to statement results
  • Fix issues on 10.8
  • Fix problems losing edit state when editing a trigger caused a syntax error
  • Improve interface consistency when performing certain combinations of actions
  • Remove the unnecessary "Table name" field from the display
  • Display NULL values for trigger information in grey and with the value specified in Preferences
  • Relations Tab:
  • Fix the interface hanging for a long time when adding a new relation on some servers
  • Improve progress display
  • When an error is encountered adding a relation, re-open the sheet with the previous values populated
  • Improve error display by using ‘SHOW InnoDB STATUS’ output for constraint errors
  • Information Tab:
  • Display a dialog when changing storage engine to warn of potential data loss
  • Sort the table engines alphabetically
  • Import / Export:
  • Save the last used import and export locations between sessions
  • Default CSV imports to a new field escape setting supporting both backslash and double-quote escaping types
  • Improve input of field separators for CSV import
  • Fix invalid export of duplicated table constraints in .dot exports
  • Fix CSV exports of query results or filtered table views to include the full content of BLOB fields
  • Fix a problem that could cause NULL values to be quoted when exporting custom query results as CSVs
  • Improve use of the table name token when exporting multiple tables
  • Fix interface lockups and crashes that could occur in certain export situations
  • Fix table creation syntax when creating a table based on selection of some columns in some CSVs
  • Improve handling of binary string field types during exports
  • Fix incorrect export of comments for tables not being exported
  • Fix null field exports for XML
  • Significantly reduce memory usage during large exports
  • Connection Handling:
  • Add MySQL 6 support
  • Add Drizzle support using their MySQL API
  • Significantly improve stability when MySQL drops the connection unexpectedly
  • Improve automatic reconnection handling
  • Improve handling of servers with short default timeouts, improving specified timeouts on connection and reconnection
  • Don’t display connection lost prompts for background connections until re-used
  • Reduce the number of helper connections used to one, preventing firewalls blocking users accidentally after too many connections in short timespans
  • Improve detection of table encodings on MySQL

New in Sequel Pro 1.0 RC 1 (Jan 14, 2013)

  • Interface:
  • Add a delicious new icon by Kenichi Yoshida (with many thanks to Panic, Inc)
  • Add Retina versions of some connection icons and elements
  • Display multi-line table content and query cell values on a single line, displaying visible line break characters
  • Automatically enter sheet editing mode for multi-line cell values
  • Allow up/down arrows to navigate within multiline cell display instead of automatically moving row
  • Enable the encoding used to view databases to be changed on all tables
  • Fix find/replace usage within edit sheets
  • Automatically resize edit sheets that are larger than the current screen
  • Improve opening of windows when the application is opened in the background
  • Improve a number of split view resize errors by rewriting all split view handlers
  • Add a menu item and the standard keyboard shortcut (^⌘F) for taking a window fullscreen
  • Connection View:
  • Merge the favourites editing preferences interface into the connection interface
  • Add support for managing and grouping favourites into folders in the connection view
  • Save the state of expanded and collapsed groups across sessions
  • Add a Quick Connect entry at the top of the interface for a blank connection interface
  • Mark edited favourites appropriately and allow them to be saved as new favourites or update the existing favourite
  • Fix and improve password handling
  • Improve favourite sorting
  • Add support for testing edited connections
  • Improve favourite name generation when one is not provided
  • Fix display of an active SSH/SSL key field
  • Add remove item, rename item and duplicate items to the connection interface gear menu to match the context menu
  • Improve cancellation of SSH and MySQL connections
  • Add Zend Server CE compatibility to the default socket search list when left blank
  • Allow hidden files to be viewed in SSH/SSL key selection dialogs
  • Translations:
  • Added a Swedish translation (many thanks to Peter HĂ€ggstrand)
  • Added a French translation (many thanks to MichaĂ«l Gallego, with help from Dominique Guardiola, FrĂ©dĂ©ric Latour, SĂ©bastien Guy and Lou Ferrand)
  • Added a Japanese translation (many thanks to 掟 èȘ , with help from 橘 ゆり驙)
  • Updated German and Russian translations for more of the interface
  • Made more strings and interface components localisable
  • Improve localisation spacing
  • Tabs:
  • Fix animation errors when hiding and showing the tab bar
  • Fix drawing errors when dragging tabs around
  • Fix display of the tab bar in certain window states
  • Bundles:
  • Improve stability when using bundle contextual menus
  • Tables List:
  • Added a “Copy Create Table Syntax” to table contextual menus
  • Fix scroll-ability of very long table CREATE syntaxes in the display sheet
  • Display the table engine in the table info panel
  • Give the table list focus on initial connection and when switching databases
  • Structure Tab:
  • Display column default encodings and collation when available
  • Fix some exceptions during index creation
  • Improve visibility of fields in the add index sheet depending on selected field
  • Improve handling of required sizes when adding indexes
  • Update the indexes view to respect the vertical table view gridlines preference
  • Clearly show the default encodings selected and used when creating new tables, and improve default detection
  • Content Tab:
  • Use primary keys to preserve table content selection when refreshing or filtering tables where possible
  • Improve query used when deleting all rows to lessen the chance of accidentally deleting rows added outside the application
  • Rename “is” filters to “=” to make their purpose clearer, and make it perform a binary equality check
  • Move the LIKE filters to just below the new “=” filters
  • Add support for “matches RegExp” and “does not match RegExp” default filters
  • Add new custom filters to the Global list rather than untitled connection favourites, preventing their loss
  • Improve validation of FLOAT type data against maximum lengths
  • Speed improvements, especially when loading large data sets
  • Reduce flicker when refreshing the content view
  • Fix undo and clearing of the table content filter field having unexpected effects
  • Fix errors when cancelling sorts of table content
  • Reduce the number of queries used for certain operations
  • Reset pagination when a table is filtered
  • Alter keyboard shortcuts and menu items: ⌘F now sets the focus on the table filter field and ⇧⌘F displays the advanced table-based table filter.
  • Rework and improve the advanced table-based table filter
  • Query Tab:
  • Exchange the positions and shortcuts for the “Run All” and “Run Current/Previous/Selection” buttons
  • Prevent query results from being exported when they are still being downloaded
  • Improve line number drawing
  • Improve editing of the custom query strings while the view is being syntax highlighted
  • Improve custom query placeholder insertion and value replacement
  • Improve autocomplete popup position and handling
  • Set the enter key and the right arrow key to select an active autocompletion suggestion
  • Improve autosizing of the query error area
  • Fix query selection changing after a query finishes executing
  • Improve help search updates and links in help results
  • Add new query favourites to the Global list rather than untitled connection favourites, preventing their loss
  • Triggers Tab:
  • Add the Triggers button to the default toolbar set
  • Fix clearing of the new trigger dialog after use
  • Re-open the add/edit trigger window if a trigger can’t be saved
  • Work around some MySQL versions appending null bytes to statement results
  • Fix issues on 10.8
  • Relations Tab:
  • Fix the interface hanging for a long time when adding a new relation on some servers
  • Improve progress display
  • When an error is encountered adding a relation, re-open the sheet with the previous values populated
  • Improve error display by using ‘SHOW InnoDB STATUS’ output for constraint errors
  • Information Tab:
  • Display a dialog when changing storage engine to warn of potential data loss
  • Sort the table engines alphabetically
  • Import / Export:
  • Save the last used import and export locations between sessions
  • Default CSV imports to a new field escape setting supporting both backslash and double-quote escaping types
  • Improve input of field separators for CSV import
  • Fix invalid export of duplicated table constraints in .dot exports
  • Fix CSV exports of query results or filtered table views to include the full content of BLOB fields
  • Fix a problem that could cause NULL values to be quoted when exporting custom query results as CSVs
  • Improve use of the table name token when exporting multiple tables
  • Fix interface lockups and crashes that could occur in certain export situations
  • Fix table creation syntax when creating a table based on selection of some columns in some CSVs
  • Improve handling of binary string field types during exports
  • Fix incorrect export of comments for tables not being exported
  • Fix null field exports for XML
  • Significantly reduce memory usage during large exports
  • Connection Handling:
  • Add MySQL 6 support
  • Add Drizzle support using their MySQL API
  • Significantly improve stability when MySQL drops the connection unexpectedly
  • Improve automatic reconnection handling
  • Improve handling of servers with short default timeouts, improving specified timeouts on connection and reconnection
  • Don’t display connection lost prompts for background connections until re-used
  • Reduce the number of helper connections used to one, preventing firewalls blocking users accidentally after too many connections in short timespans
  • Improve detection of table encodings on MySQL

New in Sequel Pro 0.9.9.1 (Sep 19, 2011)

  • New Features:
  • Add support for naming relations
  • Support fullscreen in Mac OS X 10.7 Lion
  • Add support for abbreviated MySQL timezone definitions
  • Sequel Pro has the OS X Lion Application Category of “Developer Tools”. (Convenient when sorting by Application Category in Finder.app and when creating folders in LaunchPad.app)
  • Up-to-date German and Russian translations, including Russian translation of the credits file
  • Support regex within the table filter list to match tables, falling back to plain text matching; thanks to Emma Persky for the original patch
  • Lion compatibility improvements:
  • Update tab colours under 10.7 to match system styles
  • Fix issues dragging tabs out of windows and into other tab bars
  • Fix QuickLook issues under 10.7, including windows which couldn't be closed, fullscreened, and crashes
  • Use overlay scrollers where possible
  • Fix Bundle Editor Group names not showing up in Lion
  • Fix crashes when custom query errors occur when running multiple queries on Lion
  • Usability Tweaks:
  • New Index sheet improvements
  • SSH reconnection dialog defaults to NO if SSH key not recognised
  • Tweaks to export window's Filename field
  • Add option to the Export window for including AUTOINCREMENT values, defaulting to off
  • Disable the 'include drop syntax option' when the structure option is not enabled in the Export Window
  • Prevent error bell when using the enter key to initiate a connection when keyboard focus is on the favourites outline view
  • Don't initiate a connection when the currently selected favourite is clicked again slowly
  • Increase speed of connection by combining initial version check/timezone check/encoding check.
  • Improve connection timeout handling to significantly improve connection stability on certain servers
  • When moving a field in the structure view, only use the default value if it actually has one
  • Improve editable row checks in views and custom query results to make more results editable
  • Fixes sorting of integer time values in server process list
  • Prevent undo from working across tabs, keeping undo within the current tab
  • UI Tweaks:
  • Visual tweaks to Connection Error Dialog & New Index Sheet
  • (Localisation) Foreign Key tweaks for localised languages.
  • (Localisation) Duplicate DB Sheet
  • Fix layout issues of main window (including issue with connect screen)
  • Bug Fixes:
  • Fix startup encoding detection when connection to servers with an init_connection option set, fixing errors viewing tables and display of NULLs for data
  • Various New Index Sheet fixes
  • Fix an issue when cancelling the User Manager
  • Fix exceptions editing non-unique-keyed views or custom query results containing some types of binary data
  • Correctly use the user-specified NULL string in the CSV exporter
  • Use the CLIENT_INTERACTIVE mode for MySQL connections to improve timeout behaviour
  • Fix an issue when removing the only content filter
  • Crashes when using “Use monospaced fonts” or “Display vertical grid lines” preferences after closing at least one window
  • Fix crashes on cancelling the CSV import field mapper
  • Fix issues with autocomplete behaviour
  • Fix exceptions in the bundle controller when using tab switching keys
  • (Regression) Re-add default new table's id field to AUTO_INCREMENT
  • Misc:
  • Add Sparkle to credits
  • Various code base tidy ups and fixes
  • Attempt to fix SSH master use

New in Sequel Pro 0.9.8.1 (Aug 9, 2010)

  • Behavioural:
  • Fix favourites sorting
  • User manager fixes
  • Fix table row count display of filtered tables
  • Fix copying binary data as tab-delimited strings
  • Improved handling of corrupted tables, disabled storage engines and similar errors
  • Fix structure editing errors
  • Improve structure behaviour editing to commit when the return key is pressed
  • Respect "Reload after editing" preferences when editing custom query results
  • Prevent custom query uppercasing of reserved keywords if they are quoted
  • Fix reordering of timestamp fields
  • Improve default socket search paths
  • Fix custom query intercepting up/down arrow keys when autocomplete finds no matches
  • Speed and compatibility:
  • Improve background database structure querying, including support for MySQL 3 & 4
  • Table trigger loading improvements and fixes from MySQL

New in Sequel Pro 0.9.8 (May 4, 2010)

  • 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 (

New in Sequel Pro 0.9.7 (Dec 21, 2009)

  • 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.

New in Sequel Pro 0.9.6 (Aug 11, 2009)

  • Interface:
  • Customised toolbar items will be reset to the new defaults to ensure new additions are visible
  • Contextual menus have been added to many views
  • Updated a large number of interface elements for improved appearance and behaviour
  • Updated toolbar icon appearances
  • Added a shortcut for the Choose Database menu (⇧+ ⌘ + D)
  • Added a table history memory and navigation feature; new entries are created on table change or filter application
  • CREATE TABLE syntax is now formatted before display
  • It is now possible to remember up to 100 queries in the query history
  • Added the ability to copy table information with column names in both Content and Query views
  • Added a preference for whether new fields should be created as NULL/NOT NULL by default
  • Improved warning dialogs including when deleting content rows, fields, and indexes
  • Improved interface updates according to actions in other parts of the interface
  • Add the ability to export server variables to a file in MySQL config format
  • Improved the display of names and values in the server variables dialog
  • Improved the display of filter settings for long column names
  • When Growl is enabled, remind the user that some options can be set in the Growl System Preference prefpane
  • Added a preference to allow the display of vertical grid lines in table views
  • The text/blob edit sheet has been significantly improved, including speedups and Quick Look support
  • Improved future automatic update behaviour when dialogs are showing
  • Fixed issues with the “Default favorite” selection
  • Added a preference to allow control of frequency of autoupdate check
  • Added position cascading for new windows
  • Connection:
  • Redesign the connection interface and functionality
  • Replace the connection sheet with a connection view within the main window
  • Allow explicit selection of the connection type, and hide fields not appropriate to selection type
  • If the user tries to use “localhost” for a TCP/IP connection, ask them what they meant to do
  • Improve autodetection for default socket location, including default MAMP location
  • Added support for connections via native SSH tunnels
  • Password and public/private key authentication support
  • Automatic local port assignment
  • Display SSH tunnel use and use in the title bar
  • Fix occasional corruption of old favourites (automatically fixes any broken old favourites)
  • The help button on the connection interface now links to online help
  • Overall connection lag has been significantly improved
  • Attempt to automatically recover from and bypass errors caused by MAX_ALLOWED_PACKET for large blob object support
  • Add support for servers running in ANSI/ANSI_QUOTES mode
  • Improve password storage reliability
  • Improved favourite name editing and the use of default names
  • Improve connection error dialogs to more closely reflect the error that occurred
  • Tables list:
  • Added a table list filter which is automatically shown when many tables are present
  • Sort tables in the list alphabetically by OS X locale
  • Added initial support for listing, duplicating, and removing Functions and Procedures
  • It is now possible to duplicate or delete Views
  • Added a menu option and dialog for renaming tables, views, procedures and functions in addition to click-to-edit
  • Improve the table duplication sheet
  • Allow the storage engine of new tables to be specified in the create table dialog
  • Added support for truncating tables
  • Improved the display of the row count in the table information pane
  • Saved the collapsed state of the table information pane
  • Fixed initially displayed position for newly added or duplicated tables
  • Structure tab:
  • No longer send needless query when nothing is changed after editing a field
  • When adding a field insert it after the currently selected row
  • Improve compatibility with more table structures
  • When adding indexes default to INDEX if a primary key already exists
  • Replaced editable table type with a link to the table info tab with more options
  • Fixed behaviour when attempting to remove the last table field
  • Improved saving of rows including improved default values behaviour and improved support for viewing/editing “on update CURRENT_TIMESTAMP”
  • Use a checkbox for the “Allow Null” setting
  • Content tab:
  • Added the ability to copy content as an SQL INSERT command for easy use with other tables/databases
  • Improved display after errors
  • Significantly reduced the amount of memory required to show large tables and speed up processing of results
  • Added LIKE support for numeric data fields to the filter options
  • Allow “NOW()” to be entered in date or time columns
  • Display link arrows in columns with foreign key references, allowing automatic table selection and filter setting for clicked cell
  • Any part of the table cell can now be clicked on to edit the contents
  • Content tab state is reset less often; for example, row selections will no longer be lost just after making an edit
  • Query tab:
  • Make query results editable where they can safely be edited
  • Allow custom query results to be sorted by clicking on the column header
  • Improved “Run Current”/”Run Previous” button behaviour
  • Errors when running multiple queries via “Run All” now ask the user whether they want to proceed
  • Errors highlight the correct line
  • Improved auto-completion support
  • Add a new narrow-down completion style menu using F5 (ESC triggers old implemention)
  • Add icon and spelling completion for narrow-down completion
  • Improved separator detection
  • Added core functions
  • Added database names
  • Added procedure and function names where available
  • Only autocomplete database, table or column names inside backticks
  • Added support for selecting lines by on the line numbers
  • Added MySQL help functionality
  • Lookup based on the connected server
  • Ability to update reference as you type
  • Full search functionality
  • Back/forwards navigation through search results
  • Improved syntax highlighting
  • Improved indenting/outdenting behaviour
  • Added find/replace support for the custom query editor
  • Added a section to the preferences to customise the query editor behaviour
  • Added the ability to customise syntax highlighting colours
  • Added the ability to customise foreground/background colours
  • Added the ability to highlight the current query with a customisable colour
  • Performance improvements when working with large quantities of text in the query editor
  • Added the ability to drag files onto the query editor to add their contents to the text view for editing
  • Improve auto-pairing behaviour next to words
  • Added keyboard shortcuts for easily increasing and decreasing the font size and multitouch increase support (⌘ + +/-)
  • Added initial DELIMITER support
  • Added the ability to copy content as an editable SQL INSERT command
  • Custom queries which fail are no longer automatically retried if they do not fail as the result of a connection error
  • Improved accuracy of query timing
  • History and favourites selection now perform standard text entry/replacement instead of overwriting the entire editor
  • Added ability to comment out or uncomment the current selection or lines in the query editor using ⌘ + /
  • Added ability to copy a selection as RTF ( ^ + C )
  • Added ability to select the current query ( ^ + Y )
  • Queries beginning with USE, CREATE, DROP, RENAME, or ALTER update the table list
  • Remember the width of custom query result columns which map to real fields
  • Table relations tab:
  • Added a table relations tab for viewing and adding constraints where supported by the current table
  • Lists current constraints in a table
  • Allow addition of new relations
  • Easy linking of columns in the current table to indexed columns of the appropriate type in other tables
  • Supports ON UPDATE and ON DELETE actions
  • Allow removal of constraints
  • Import / Export:
  • Added the ability to export the schema as a basic Graphviz .dot file
  • Fixed crash when importing without a table selected
  • Import and Export of CSV and SQL formats have been significantly sped up
  • Improve import/export progress dialog interface
  • Correctly export views with dependencies on other tables/views occurring after the original view in the table list
  • Added automatic line ending detection for CSV imports
  • Fixed CSV imports to more accurately import a range of files, including newlines in quoted strings and quote characters escaped by quote characters
  • Printing:
  • Printing layout and appearance has been improved
  • Blob data representing images will be shown as thumbnails
  • Added a paper size dropdown to the print dialog
  • Added optional background printing
  • Other:
  • The query logging option to hide SELECT/SHOW statements now functions more reliably
  • Query log exports now saved as .sql files by default
  • Fixed multibyte support in favourite details when storing/retrieving passwords
  • Improved interaction with table names containing backquotes (`)
  • Table storage engines are now read from the server rather than using a generic hardcoded list
  • Fixes a number of crashes
  • Fixes a large quantity of memory leaks
  • Significant underlying code overhaul, including recent SQL client libraries, significant speedups, and updating the underlying MCPKit framework to include all the recent Sequel Pro updates in a generic and reusable method
  • In/decreasing the font size ( ⌘ + +/- ) works on several text views
  • Drag and drop of a text file to insert its content works on several text views (by holding the ⌘ key it inserts the file path instead)

New in Sequel Pro 0.9.5 (Apr 30, 2009)

  • Auto-updating:
  • The auto-updating framework has been updated to avoid a number of problems. Please note that 0.9.4 may not upgrade itself correctly to 0.9.5 but the updated code in 0.9.5 should fix future upgrades.
  • Interface:
  • Buttons in the main window have been updated for a much sleeker Leopard interface.
  • The preferences have been redesigned and improved, and offer control for new features:
  • Added the ability to set a default favorite.
  • Added the ability to connect to default favorite on startup.
  • Added the ability to configure the maximum number of queries to remember.
  • Added the ability to disable Growl notifications from within Sequel Pro.
  • Added the ability to configure network timeout.
  • Added the ability to toggle connection keepalive.
  • When creating new tables the name and encoding to use are now selectable.
  • Table deletion and duplication has been moved to an action menu to avoid misclicks.
  • Button tooltips have been improved and now show keyboard shortcuts where available.
  • Reloading the tables list will now reselect the current table if possible.
  • The zoom window menu item has been added for consistency with other OS X applications (Thanks to samsouder).
  • The three main tabs have been renamed to Structure, Content, and Query.
  • Printing now automatically paginates and supports page setup.
  • The window title now uses the connection name instead of user@host if it’s set to allow windows to be more easily distinguished.
  • Favorites will save correctly after edits, and the keychain password will be preserved when a connection is renamed.
  • The status tab will no longer crash if used on Views.
  • The “Null” column in the Structure view has been renamed to “Allows NULL” for clarity.
  • The connection sheet UI has been made more Mac-like, and you can now double-click to connect to favorites.
  • Added the ability to add the current connection as a favorite via the File menu.
  • A number of text modifiers and selectors have been made available across the interface:
  • Convert selection to uppercase/lowercase/titlecase.
  • Transpose selection.
  • Remove diacritics in selection.
  • Normalize selection (Canonical and Compatibility composition & decomposition).
  • Select current word or line.
  • Query tab:
  • The custom query text field now applies syntax coloring automatically.
  • The custom query view now shows a summary of query execution time.
  • The custom query view can now Run All Queries, Run Selected Queries, or Run Current Query, with new shortcuts.
  • The custom query view can now optionally automatically preserve indentation level.
  • The custom query view can now optionally match quotes and brackets.
  • The custom query view can now optionally capitalise recognised SQL keywords.
  • The custom query view supports indenting and outdenting selected text.
  • The custom query view will now display line numbers.
  • Right-clicking on keywords allows lookup in the MySQL documentation (thanks to Alex King for the original version of this patch).
  • Query history can now be cleared.
  • The results table will now correctly reset positioning when running queries to prevent crashes.
  • The custom query view font is now editable.
  • “Empty query” errors should no longer be generated.
  • Content tab:
  • Columns in the Content view can be reordered; this will not affect table structure but can allow easier viewing.
  • Date field comparisons have been renamed from older/younger to before/after to reduce confusion.
  • Duplicating a row containing blob or text fields now correctly duplicates the data if blob/text loading is deferred.
  • Fields which have not been loaded due to blob/text loading being deferred show their status more clearly.
  • NULL will no longer be prepopulated into new rows for fields with NOT NULL set.
  • Fixes a crash bug related to mixed sorts and refreshes.
  • Fixed problems using the IN filter method.
  • The LIMIT FROM stepper has been improved and will now stay within the range of rows.
  • Query Log Console:
  • The console has been reworked to resolve a number of crashes related to large numbers of queries.
  • The console now supports live filtering.
  • Timestamps can be hidden.
  • SELECT/SHOW statements can be hidden.
  • Console contents can be exported to a file.
  • A single console window is now shared across all connections.
  • Import / Export:
  • SQL exports and imports should now preserve encodings correctly.
  • SQL imports of all files are now slightly faster.
  • SQL exports are now generated in a format which will import faster.
  • SQL exports now export Views correctly.
  • SQL exports now support exporting constraints correctly.
  • Many imports of large files which previously crashed will now succeed thanks to the reworked query log console.
  • CSV exports of the current table will now use the selected line and field delineators.
  • Other:
  • Fixes a number of memory leaks.
  • Interaction with the keychain has been improved and connections with similar details will no longer share the same password.
  • Improved interaction with autoincrement fields.
  • Backticks are now supported within identifiers.
  • Null values in new rows are displayed and added correctly if the display value for Null is changed in preferences.
  • If a connection is interrupted and automatically restored, eg via sleep, the encoding is now correctly preserved.

New in Sequel Pro 0.9.4 (Mar 12, 2009)

  • Interface:
  • Improve interface responsiveness, especially on slower connections.
  • Fixes a problem where many columns in a table are shown with a tiny width.
  • Added a pagination stepper for use when LIMIT is enabled.
  • Added very basic printing support for the currently selected view.
  • The log console has been moved to its own window in preparation for future changes.
  • The log console can now export its contents to a file.
  • Allow the database encoding to be specified when creating a new database.
  • Varchar and char length limits are now enforced in the interface for clarity.
  • Rows which have been edited without any changes being made are no longer saved back to the database.
  • Row editing has been improved to allow clicking on other fields within the row without forcing a save.
  • Row editing has been improved to allow reediting if the row fails to save.
  • Field editing has been improved to allow reediting if the field details fail to save.
  • Fixed a number of crashers related to opening, deleting, and saving in the binary edit sheet.
  • Improved image drag and drop compatibility in the edit sheet.
  • A Refresh Databases option has been added to the Database list in addition to the current menu.
  • Added many more keywords and columns in the current table to the custom query autocompletion lists.
  • Custom query favorites, history and run buttons have been moved below the splitter to allow the pane to be collapsed.
  • Speed up table loading and scrolling when large quantities of data are present in fields.
  • Status tab interface improvements.
  • Improved support for viewing Views.
  • Show the state of the toggle to edit all fields in sheets.
  • Deselect favorites in the connection sheet as soon as they are edited for clarity and improved connection error recovery.
  • Fixes an issue causing the row count to be displayed as zero.
  • Dates in table info pane and status tab use the user’s date and time display formats.
  • The custom query favorites editor has been redesigned.
  • Reduces the minimum width of the tables list a little and prevents it from disappearing.
  • Connection:
  • Disconnections or network errors are automatically recovered from more often.
  • Instead of hanging when a serious networking problem is detected the user is notified and asked how to proceed.
  • Supports reconnection while maintaining the current window state on connection failure.
  • Run a connection keepalive in a background thread to maintain the connection to the server.
  • Field type improvements:
  • Improved support and added filtering for DECIMAL field types.
  • BLOB and binary field types are fully viewable and editable.
  • BLOB and binary field types show a preview of their content as text when viewing the table.
  • Added support for BIT field viewing, editing, and filtering.
  • Filtering using “IN” has been improved.
  • Date filter order has been fixed.
  • Table structure:
  • Creation of datetime columns has been improved.
  • Reordering columns now preserves unsigned/null/default attributes correctly.
  • Import / Export:
  • Numeric data in string column types is now correctly exported as a string to avoid leading zero loss.
  • Imports have been threaded and can now be cancelled while they are in progress.
  • SQL import speed has been improved.
  • SQL and CSV export speed have been improved.
  • The tables list is automatically refreshed after importing an SQL file.
  • Fixes a crash when importing a CSV file into an empty database.
  • Improved error handling when reading import files.
  • The import window menu now remembers the last import type used and also recognises CSV and SQL extensions.
  • Fixes a crash when exporting an empty table to CSV or XML, singly or as part of selected tables.
  • Encodings:
  • Improved table encoding autodetection.
  • Ensure consistent encoding usage when viewing tables and data.
  • The “Database Encoding” menu item in the Databases menu has been renamed for clarity.
  • Added support for the EUC-KR Korean encoding.
  • Added a special encoding option (UTF-8 Unicode via Latin 1) for utf8 tables containing utf8 data which has been saved via a Latin1 connection, for compatibility with older clients and a number of older website scripts.
  • Other:
  • Overall application size has been reduced.
  • Improved SQL compatibility for importing and custom queries.
  • Fixes a number of memory leaks.
  • Slight speedup on COUNTing tables.
  • Lots of minor interface improvements.
  • Huge code cleanup and improvements.

New in Sequel Pro 0.9.3 (Mar 12, 2009)

  • Sequel Pro is now much faster when working with large data sets.
  • Fixed a data corruption issue with TEXT and BLOB data types.
  • Encoding autodetection now uses table encoding instead of the underlying database encoding.
  • Table fields can now be reordered in the structure view.
  • Enhanced the import interface including an improved CSV field mapping interface.
  • Searching in browse mode is no-longer “real time”, to improve usability over slow connections.
  • It is now possible to filter by NULL and NOT NULL.
  • Reloading the view in browse mode will now preserve view position, sorting and filters.
  • Table information pane is now functional.
  • Console is now more space efficient.
  • Now have a shortcut key to show/hide the console.
  • Improved growl support.
  • Improved keychain password storage.
  • Can now quit Sequel Pro when a connection sheet is open.
  • Improvements to favorite query system (more to come).
  • Fixed a bug when renaming a connection favorite.
  • No-longer show busy animation in all connection windows when only one connection is actually active.
  • Fix issue where favorites are not selected when they're created.
  • Cancelling a connection is now more reliable.
  • All export modes are now faster, use less memory, and show progress more accurately.
  • CSV exports are now neater and no longer export NULL strings, exporting a blank cell instead.
  • Can now export all data in the current table regardless of limit settings via a new export menu item.
  • SQL exports now export TEXT and BLOB types correctly and are much faster to import.
  • Other clean-ups and improvements.

New in Sequel Pro 0.9.2 (Oct 21, 2008)

  • Fix bug where data will be truncated if you edit a varchar containing more than 100 characters
  • Fix bug decimal value are sometimes treated in hexadecimal (causing data corruption)
  • Default value for "limit rows" preference is now 1000 rows instead of unlimited
  • Added show/hide toolbar and customize toolbar menu items
  • Clean up some menu items in the File menu
  • Misc other changes

New in Sequel Pro 0.9.1 (Sep 17, 2008)

  • "Add Database..." added to Database popup button.
  • "Add to Favorites" checkbox removed.
  • Fixed formatting issue in Credits.rtf .
  • Show/Hide Console & Clear Console Toolbar items now enable properly.
  • Symlinks in MySQL Framework were damaged - file size down to 5 MB from 8 MB.
  • Tables List split view now saves its width.
  • Focus ring removed from Favorites Table in connect sheet.
  • Turned on alternating rows.
  • Turned off allow multiple selection.
  • Changed Add and Remove Buttons to show standard plus and minus images instead of text.
  • Growl Support Added.
  • Add, Remove, and Renaming of favorites now possible in connect sheet.
  • Added localisation for TABLES and TABLE INFORMATION.
  • Fixed Credits.
  • Added grabber images.
  • Removed small icon of table and replaced with new one.
  • Added "Checksum Table" to MainMenu.
  • Added extra splitter grab handles.
  • Add Software Update checking.