Release Notes - Sequel Pro

Release 0.9.7December 21, 2009

Build 1630

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.

Release 0.9.6 August 11, 2009

Build 1167

Highlights of the new features in this version are: overhauled connection including SSH tunnel support, updated interface, filterable tables list, foreign key support, sortable and editable custom query results, native MySQL help support and significant speed and memory usage improvements.

The below list only shows a selection of the enormous list of changes in this version:

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)

Release 0.9.5 April 30, 2009

Build 639

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

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

Release 0.9.3 – December 20, 2008

• We welcome three new programmers to the team: Mark Townsend, Rowan Beentje, and Stuart Connolly. Thanks guys!
• 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.

Release 0.9.2 – October 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

Release 0.9.1 – September 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

Release 0.9 – August 5, 2008

• redesign user interface for connect panel
• code improvements for favorites system
• code improvements for menu validation system
• 256x version of icon for better quality in cover flow
• create new database menu and remove add/remove buttons from main window
• UI tweaks around table select view and it's buttons
• Replace tabs with toolbar buttons to make the app feel more modern
• move database select menu out of window into toolbar
• more intelligent default names when creating a new favorite
• now using normal size scroll bars
• nicer looking tables list
• table information pane
• move console commands into view menu
• now has an x86 build for improved performance on intel macs
• Misc. other user interface changes
• Misc. code clean-ups

Release 0.8 – April 12, 2008

• Rebrand project as Sequel Pro (name change, author changes, icon change)