Features: + Multi tabbed. + Syntax highlight. + Autocomplete. + Inline row edit. + Primary key detection. + Single cell selection. 1.0.0: + Initial Beta 1.0.1: + Added line numbers for executed query messages. + Added initial support for table designer. Currently table columns can be modified. + Indexes, foreign keys and triggers are currently read-only. + Support for OSX 10.8+. 1.0.2: + Added 'INSERT TO' context menu item for tables. + Added 'Copy as Insert' indiviual and batch context menus to result grids. + Improvements to auto-complete. + Fixed an issue with copying NULL results. + Added Hide/Show results menu item. + Fix for line numbers in OSX Yosemite 10.10.3. 1.0.3: + Auto-complete and drag/drop of table + column names will now quote if required. + Fixed an issue where when scrolling as results load, the scroll may scoll back to the top. + Fixed an issue where table numbers may be off by one. + Added a pully on the results view for easier resizing. + Return key now works as a shortcut for the connection screen. + On initial connection, if there is only one database it will automatically expand. 1.0.4: + Fixed an issue with escaping table names. + Views now display materialized views and each matarilized view now includes a 'Refresh materialized view' context menu. + Fixed an issue where the 'Drop column' context menu was available for columns in a view. + Fixed a few issues around scripting views. + Fixed an issue which could sometimes cause crashes during syntax highlight. + Added a preference to toggle query execution style between 'execute all' or 'execute current'. + General performance improvements on syntax highlighting. + Fixed an issue with opening files. + 'Copy as' context menu now supports comma separated and tab separated. + Added support for multiline nested comments. + New tabs will better figure out a default connection. + Improved performance for Select All in results grid. 1.0.6: + Updated app icon. + Updated server icon in treeview. + Tables and views now use separate icons. + Resoved a few issues with autocomplete. + Added icons for all autocomplete suggestions. + Updated internal list of autocomplete suggestions. + Added support for dropping indexes, foreign keys and triggers via the table designer. (Create and edit is still unavailable). + Create table context menu now uses the table designer UI. + Result sets now include context menus for insert and edit (if table has primary keys). + Added an insert context menu item to the table root level node. (Requires table to have a primary key). + Added a query history dropdown to the query editor. + Improvements to result set auto-sizing. + Right click on results table will now select items if required. + Columns in tree view now display data type and nullable attributes. 1.0.7: + Crashed. 1.0.8: + Added support for editing enums in query results (if table PK is available). + Added current user to database tree server node. + Linebreaks in the resultview now display the ΒΆ symbol, rather than being hidden. + History queries are now 'per connection' (queries you can on database A will not show when connected to database B). + Fixed an issue where saving a tab when prompted to close, would cause the close to fail. + Major query execution performance. + Fixed an issue where deleting a row from a result set could sometimes cause a crash. 1.0.9: ****** SAVED DATABASE CONNECTION WILL NEED TO BE RE-ENTERED DO TO SOME UNDERLYING CHANGES ***** + You can now inline sort query results. + Added schema names in the database view. Schema names will appear only for entries which are not in the current users default schema. + Added the ability to remove connections via the 'File' -> 'Remove Connection' menu item. + Copying text from the query view now includes a RTF and HTML copy, allowing for pretty pasting into emails + other apps. + Fixed a crashing issue that could occur when query execution resulted in an error. + Fixed an issue where columns for views and materialized views may not expand properly in the tree view. + Fixed an issue where column data types may not appear properly for the database tree, if the type is user defined. + Fixed an issue where closing many tabs quickly (cmd+w repeatedly) could cause crashes. + Fixed an issue with custom themes which could cause both background selection color and the cursor color to be incorrect. + Fixed an issue where the 'Enable auto-closing brackes' preference could not be disabled. + Fixed an issue where 'Execute query in cursor range' could sometimes execute a blank query. + Fixed an issue where searching via the database tree may not always work. + Fixed an issue where functions were not sorted properly. + Fixed an issue when updating via result set that could fail due to column names not being properly escaped. + Added an 'Advanced' option to the connection dialog, allowing a timezone to be specified. 1.0.10: + Added a toolbar with hide/show sidebar and results options. + Fixed an issue where making a connection without specifying a database could sometimes cause a connection failure. + Application window size should now be maintained between startups. + Fixed an issue with table/view name sorting when schemas were displayed. + Fixed an issue where nullable/not null would appear incorrectly for column details in the database tree. + Materialized views are now visible via autocomplete. + Fixed an issue which could cause the systems dock to freeze. 1.0.11: + Added SSH tunneling option. (Advanced -> SSH tunnel from connection dialog). Note 1: Application sandbox now requires 'Incoming network connections'. Note 2: SSH tunneling currently only supports Password and Keyboard-Interactive authentication. + Added keyboard shortcut for history queries (Command + Shift + H). Also available from the 'View' -> 'History' menu item. + Fix the search box on the left side of the database tree. When resizing it gets slightly offset. + Add a query history keyboard shortcut. + Mouse drag to select multiple rows in the results view. + Warning/Error icon on tab when a query fails. + Added tab context menus 'New query tab', 'Close tab' and 'Close other tabs'.' + Fixed an issue where query edit fonts could sometimes become incorrect. 1.0.13: + The database tree now has a few new keyboard shortcuts: - Cmd + Down on an table or view will select the first 100 rows. - Cmd + Right will open the entry in the designer. + Added import from CSV (with create new table option). + Improved user notifications. + Fixed a crash when starting/stopping query execution quickly. + Fixed a crash that could happen when closing a tab happened before a query had loaded. 1.0.14: + The connections window has been revamped. + New history window has been added. + Fixed an issue where comments may be removed from functions when created. + Files can now be dropped anywhere on the application window. If the file is dropped on a query tab, it replaces the current tab, otherwise it opens the query in a new tab. + Fixed 'Autocomplete does not work before comma' (https://github.com/hankinsoft/SQLPro/issues/21). 1.0.16: + Autocomplete now supports with schemas. + Added a warning icon to the 'Query finished' text when running a query which results in an error. + Added a master password security preference. 1.0.17: + Added Amazon Redshift support. + Added an optional remember password checkbox when connecting to a server without specifying a password. + Keyboard shortcuts Cmd + 1-9 can now be used to switch tabs. + Added support for SSL connections. + Added triggers node for each table. You can now view triggers attached directly to tables. + Added 'favorite' to the query window. You can now enter a favorite query and have it added to the query window via the favorites menu or via autocomplete. + Improvements for handling large result sets (greater than one million) entries. + History window now has keyboard shortcuts. Right arrow, left arrow and space key. 1.0.19: + Fixed an issue with views not being loaded in the tree view. + Some actions (such as drop table, function, views) will now preview the underlying query which will be run. + Views and Materialized views are now separated into separate groups. + Double clicking Tables, Views and Functions now have default action.