Querious Release Notes

🎈🎉 Querious 2 is now officially released, no longer in beta! 🎉🎈

Fixes:

• Fixes a crash when trying to set the SSH key in the Server Access settings in the Server view.

New:

• Added confirmation for deleting a table index in the Structure view.
• Added confirmation for deleting a table foreign key in the Structure view.
• Added confirmation for modifying row data in the Query view.
• Added a disabled-by-default confirmation for modifying row data in the Table Content view. (Enable it in Preferences.)
• Right-clicking on a row in the Query view's left sidebar (Recent Queries, Saved Queries, etc...) now shows the menu items that were only visible in the row's action menu before.
• Double-clicking a Recent or Saved Query opens a new editor with that query in it.

Fixes:

• Fixes the Tab key not completing the displayed suggestion when Tab was also set as the autocomplete trigger key.
• Recent Queries cannot be renamed.
• Fixes a crash on macOS Sierra that would generally happen when closing the window in certain circumstances.

New:

• Autocompleting identifiers that require quoting (eg: `table-name`) will surround the identifier with backticks if there is not already a leading backtick.

Changes:

• Control-Tab and Control-Shift-Tab now work for changing tabs in the window. (Cmd-Shift-[ and ] still work too.)
• Clicking "Cancel" in any of the prompts from SSH will immediately kill the SSH tunnel connection setup rather than ask the same question several more times.
• Removed "experimental" XML export.

Fixes:

• The Server view's SSH connection now works if the server has both an ECC key and RSA key. The connection will negotiate to use RSA and ask to add the RSA fingerprint if necessary. ECC keys are still not supported.
• Escapes underscores in database names when adding database-level grants.
• Wildcard database patterns in database-level grants are displayed properly.
• When removing the SSH password in saved connection settings, it removes Querious's saving of the SSH password from Keychain if it's there.
• The Copy panel now remembers which format was last used (CSV, Tab, SQL).
• The Records/Data File "Process" sheet has tooltips for the "Select Rows" radios to explain their differences.
• The Table Reference sidebar in the Query view starts with the selected database when appropriate.
• Toolbar controls are disabled when the tab is showing the reconnection view.
• The Security Switch is disabled in the connection settings when Unix Socket is selected.
• Fixes weird text overlap in the Transcript, Slow Query Log, etc in the Server view on 10.11+.
• Fixes switching in and out of the Server view always resetting the subview selection to Server Status.
• Some misc stability improvements for rare issues.

New:

• Added keyboard shortcuts for New, Open, Close, Save for query editors in the Query view. See the menu in the editor list.
• Added new "Navigation" preferences pane, for controlling what View -> "Go To…" shows.
• There's a new preference (enabled by default!) for limiting View -> "Go To…" results to the currently focused database or selected database.
• Query autocomplete is a bit smarter to not show functions and keywords at certain times when it makes no sense.
• Query autocomplete is a bit smarter to show only column names for the relevant table in some limited situations.
• Query autocomplete in the Routine, Event, and Trigger structure views is more complete, equivalent to the Query view.

Changes:

• The icons in the primary sidebar on macOS Sierra will temporarily appear different, because there's a bug in macOS which is what causes different pieces of the interface to randomly disappear, and oddly enough these images are one way to trigger that bug easily.
• The ordering of results in the "View -> Go To" window is improved to place priority on the database of the currently selected item in the connection window. Other results with equal priority are now sorted alphabetically by database name.
• Go To's location updating prioritizes whichever database is focused or selected.
• The "Go To…" window tries to maintain the user's selection while it's updating and the matches change.
• Optimizations to the primary sidebar so that loading tables, views, etc doesn't cause any visual flashing, and also is much more efficient and faster.
• Table column sorting now cycles through a "no sort" mode.

Fixes:

• Fixes progress spinner sometimes showing on rows when it shouldn't in the primary sidebar
• Fixes primary sidebar hierarchy having a race condition in updating locations, and randomly not updating databases sometimes.
• Autocomplete trigger key wasn't always working. -- Code note: I don't see the logic in the code that was there.
• Fixes the Triggers view in Table Structure having "Copy CREATE Statement" multiply each time the contextual menu is opened when right-clicking on a trigger in the list.
• Some misc stability improvements for rare issues.

Changes:

• Greatly improves the time to get the slow query log from the server.
• The Table Content view now only sorts one column at a time since that's all that was ever indicated visually. Before it would sort by multiple columns in the order in which you previously clicked them.
• Experimental improvement of reducing the delay to display the list of databases immediately after connecting. This is a proberbial toe-dipping.

Fixes:

• When copying a subset of a table's columns to SQL (such as in the Query view when a SELECT statement is used), if the selected columns contains the primary key of the table row, Querious no longer includes all column values in the generated INSERT statements.
• The Query view now recognizes /*! */ comments as being executable and will send them to the server.
• Fixes a couple rare crashes.

New:

• Added the Query Formatting contextual menu item to the query text views in Event, Routine, Triggers, and View structure views. Also in the Saved Queries view and SQL file document windows.
• The Procedure Content view shows a big progress indicator when a query is running for a long time.

Changes:

• Table Status data is now cached so frequent navigation in Querious doesn't trigger fetching it over and over. It expires after two minutes. The data can always be manually refreshed. A new boolean hidden preference "databaseContentTableStatusAutomaticallyLoad" was added so fetching the table status automatically can be disabled. You can set this with the defaults command in Terminal.

Fixes:

• Jump to Foreign Row now works reliably again.
• Exporting to SQL no longer includes generated columns in the exported data.
• When the result rows in the Query view are sorted, using the field panel to edit them now edits the correct value.
• Fixes an encoding display bug for Enum/Set types in the Table Structure view's "Values" field.
• The "Include Foreign Keys" checkbox in the SQL Export options view now enables/disables properly.

New:

• Added a preference for determining the initially selected database in query editors in the Query view.
• Autocomplete suggests tables/views only, immediately after FROM.
• Adds new smarter autocomplete suggestions where parent.child offers logical suggestions for 'child' based on what's in the parent.
• When adding a new user, you're asked for the password for that user so that it won't fall foul of the password validation plugin.
• When creating a new user host, it asks for the password to use, just like when creating a new user. This also fixes incorrect default password assignment which didn't work with mysql 5.7+
• Added Open Tables / Use count to Table Status view.
• Added the option to Truncate the destination table before importing CSV and Tab files.
• The Table Column view now has a popup in every column's Default Value row, with a "None" value, for explicitly dropping the default value for the column.

Changes:

• All schema object name sorting is done with numerical sorting now. This means table7 and table11 are now ordered respectively.
• Renaming of tables etc in the left (primary) sidebar in the Content and Structure views must be done by pressing Return to begin editing or using a Rename menu item explicitly. The delayed click-to-edit behavior is disabled because it has consequences if triggered accidentally.
• Import Panel's "accessory view" is now always visible. (So "Allow all file types" is visible.) This is relevant in OS X El Capitan and later which otherwise would automatically hide it.
• In the Table Content view, when editing a value and "committing" an empty string, if the column type is a non-stringy column (an integer, etc), Querious will use the column's default value when updating the value.
• The export/import progress indicator in the status view at the top of the window is only shown in the relevant connection tabs; that is, the tabs connected to a server involved in the transfer, either as a source or destination. So no longer does it appear that an import/export is happening in an unrelated server that's open in another window or tab.

Fixes:

• Build 1048 fixes a crash in autocomplete that was present in build 1047 of beta 45.
• Fixes the Add Row button not being enabled sometimes when it should have been in the Table Content view.
• Fixes the tab's activity indicator/spinner spining when it shouldn't.
• Fixes column mapping view allowing dragging a "None" source column from the mapping list.
• Fixes stretching/squishing of the search field in the Table Content view.
• The SQL import preview now should show an error message if it can't read a file.
• Fixes the error reporting when exporting, where in one case it would say an error occurred while "importing".
• Fixes a rare potential crash in the Server view when closing the tab/window.
• Fixes a rare crash (happened exactly once) in the File Value Panel text view where changing encodings could lead to a crash.

Fixes:

• Fixes the potential for beachballing in the Query view due to autocomplete.
• Fixes some autocomplete "flickering" in the Query view.
• Small visual fix in the edit connection settings panel, where Testing would not hide the spinner properly when it was done.
• Fixes a crash on 10.9 and earlier.
• Additional stability improvements.

New:

• The "Go To" window now shows a spinning progress indicator when it's "looking" for locations
• The left ("primary") sidebar in the Content and Structure views now shows a spinning progress indicator next to each database when Querious is doing a remote fetch for determining what tables, views, triggers, etc are inside the database.
• Added a preference for turning on/off autocompletion of tables/views/etc in the selected database only. (On by default, which matches previous behavior.)
• When in the Query View, "Export" once again asks whether to export current query's results, or do a normal export directly from the database.

Changes:

• Optimization - Major changes to the left ("primary") sidebar in the Content and Structure views. Everything should work the same, but the changes make Querious more performant in several situations, where before it may have needed to force you to wait while a remote query was performed.
• Optimization - Indexing the list of database and table (etc) names for autocomplete in the Query view is significantly faster.
• Optimization - The "Go To" window now prioritizes fetching Table Names first, over triggers, events, etc. This means all the table names will be retrieved much sooner, allowing navigation to one to be quicker.
• Optimization - The "Go To" window no longer actively continues indexing locations (tables, views, etc) in the background after the window is closed.
• Optimization - Selecting from information_schema.triggers can be extremely slow in some versions of MySQL, so its use is avoided when possible by way of SHOW TRIGGERS instead which is much faster.

Fixes:

• Fixes the issues in the previous beta where some crashing would occur, such as when renaming a table.
• Fixes missing re-enabling of foreign key checks statements in SQL Exports if certain options are chosen
• Fixes the Table Content view from locking up due to many queries being run when using MySQL 5.0
• Fixes the slightly-too-narrow column in the text completion suggestions window.
• Fixes a crash when selecting a view in the Content view.
• Fixes window restoration at launch not "focusing" on the database that was focused before Querious was quit.
• Fixes the minor "flashing" of the icons in the left ("primary") sidebar in the Content and Structure views when expanding or collapsing a database.
• Fixes SQL exports including table data potentially leaving one of the tables locked.
• Fixes exports leaving an open connection to MySQL that was never reused.
• Additional stability improvements.

New:

• The Table Content view's status text field is clickable and will display the full status message, if the text is being truncated. (Like if an error occurred.)
• In the left sidebar in the Content and Structure views, right-clicking and selecting "New XYZ…" will default to creating the new schema object in the database that was right-clicked on, or the database that contains the object that was right-clicked on.

Changes:

• Optimization - Indexing the list of database and table (etc) names, such as for the "Go To" window, is significantly faster.
• Optimization - Getting the foreign keys for all tables in a database, so the Database Relationships view can draw the diagram, is significantly faster, especially for databases with many tables.
• Optimization - More improvements to the Table Content view's loading so results are loaded quicker.
• Optimization - Switching between different databases in the Database Structure view is much snappier.
• The Import/Export/Transfers Progress window has newest and unfinished operations at the top instead of the bottom of the list.
• On OS X El Capitan, made a small style change to the "Go To" window to make it look like the Spotlight window. (No white background and border around the text field.)

Fixes:

• Fixes the "New Connection" window title bug introduced in beta 41.
• Fixes window restoration not selecting the last-selected schema object in the left sidebar.
• The Structure view now correctly shows "No Selection" if nothing is selected in the left sidebar, just like the Content view.
• Fixes the Run button in the Query view potentially having the wrong title/action and enabled state after switching to a saved query.
• Fixes the Table Content view's search popups becoming disabled in certain circumstances if there is a search and content caching is enabled in preferences.
• Fixes a rare crash in the Server Access view, when clicking "Connect" and then closing the tab/window.
• Fixes a rare crash in CSV importing which was dependent on certain file "layout" and size.

New:

• When importing CSV/Tab, table column matching uses fuzzy-matching to assign very similar, but not identical column names.
• Added "Open As" popup to the Open panel, allowing the choice of a specific file format when then the file extension is ambiguous (eg .txt).
• Now allows opening file types with ambiguous extensions (eg .txt) by drag and drop onto the Querious icon, and will ask which format the file is in.
• The Database Relationships view supports zooming out using a track pad or with the slider control in the bottom left corner of the view.
• Saved Queries now have save the the selected database.

Changes:

• Notable improvements aimed at making the UI more responsive. In particular, when in the Table Content, switching between tables is now instant. There are other improvements scattered in various places as well, with more to come.
• Underlying performance improvements to making new connections to MySQL behind the scenes when required.

Fixes:

• When a window is being restored on launch, the UI now shows the reconnection happening instead of potentially blocking until it's done.
• Fixes the Query View's results summary from slowly crawling up and to the left when executing many queries.
• Procedures and Functions are correctly sorted in the left sidebar in the Content and Structure views.
• Fixes the "Go To" window not closing when cycling between windows.
• Fixes a recently occurring crash when setting the default value for a bit column. (Broken in beta 40.)
• Null-allowing numeric columns (INT etc) can have NULL set as their default value again. (Broken in beta 40.)
• Fixes a few rare crashes.

New:

• Holding Option while pressing Command + will do a Duplicate instead of Add in the Table Columns and Table Content views.
• Holding Option will show the Duplicate icon on the Add button in the Table Content view, just as it already does in the Table Columns view.
• Added an "Image" tab into the field value panel in the Table Content view, allowing a field value in binary columns to be viewed as an image.
• Holding Option while clicking on the "Left" or "Right" arrow buttons up in the Table Content view's search, will jump to the first and last rows in the table respectively.

Changes:

• In the Table Content view, when entering search conditions, textual columns (varchar, text, etc) always have "contains" selected in the condition popup by default. Other columns have "is" selected.

Fixes:

• The Table Columns view will correctly use CURRENT_TIMESTAMP, NOW, CURDATE, CURTIME, CURRENT_DATE, CURRENT_TIME, with or without parens, case insensitive, and work in (appropriately) date, time, timestamp, and datetime columns.
• In the Table Columns view, you can no longer enter an empty string for a default value of a numeric type (which is invalid in MySQL). Querious will show "0" as the default value.
• When exporting to SQL, null bytes in textual columns are escaped as \0.
• When duplicating a table (including data), null bytes in textual columns are escaped as \0.
• Fixes the import panel's Cancel button.
• Avoiding blurry text in query results view because of partial-pixel centering
• Fixes the tab bar being out of place in certain circumstances after resizing the window.
• No longer crashes when manually typing in an invalid Generation Storage option in the Table Column view
• "Day" in the Export filename template correctly uses Day-of-Month (1-31) instead of Day-of-Year (1-365).
• Fixes the visible control sizing animation issue when quickly cycling through different saved connections in the saved connections list.
• Fixed a few small memory leaks.

New:

• The Table Content view allows exporting currently displayed rows to SQL.
• The Query view allows results to be exported to SQL if they're all from the same database and table.
• The Query view's results list is filterable by success/failure.
• Added a checkbox to ignore foreign key constraints when truncating tables.

Changes:

• Removed the old results summary view which showed a list of the status of each query as a "bubble" view. It was almost entirely redundant to the other list.
• Executing many many queries (10,000 for example) in the Query view is now much faster and more efficient.
• Added better error capturing and process logging to the table duplicator, so that in the event of an error, there's a complete log of what took place.

Fixes:

• Fixes Query view cancelling not appearing cancelled.
• The import panel no longer allows moving on to step 2 (Destination) when it can't read the file correctly.
• Table Status in Database Content no longer spits out errors when it can't count the rows in a view.
• Table Status view in Database Content sorts Autoincrement fields numerically rather than stringly.
• Fixes data/records document filtering not always working after reordering the columns.
• Fixed the data/records document filter's location/column popup losing the selected column when reordering columns in the list view.
• Clears the filter text in the data/records document filter field when choosing Show All.
• Workaround for an OS X bug when the Find panel for an SQL document is open when a document gets closed, causing a crash later.

Changes:

• When deleting rows from the Table Content view, it uses a single DELETE query for all of the rows when the table has a primary key. In cases where the server is slow to respond to each individual query, this can dramatically speed up the time to perform the delete.
• Changes to the in-app updater which should avoid really rare cases where OS X doesn't handle the update smoothly, causing obscure crashes sometime during the first launch of the new Querious version.
• When running into a certain Querious bug during importing CSV/Tab files, instead of crashing the import will fail with a very detailed error. When looking at the error, there is an option to send an email to support@araelium.com which would be very helpful in tracking down the bug!

Fixes:

• Fixes a problem where a newly opened window would be slightly shorter than it should be.
• Fixed the Event Structure view's Comments text field always being empty even when the event has comments.
• Once again trying to work around "vibrancy" problems in the Query view results list.

Fixes:

• Fixes a crash introduced in the previous beta when importing a CSV file with no column headers.
• Removed syntax coloring from SQL import preview to immediately work around a performance issue in OS X while looking for a better long term solution.
• Fixes the default SQL export file name not changing when the selected database changes.

Fixes:

• Works around a bug in the underlying MySQL client library which could cause problems connecting without SSL to a server that has SSL enabled.
• Fixes a problem where Querious was unable to install the privileged helper tool sometimes necessary to read the error and slow query logs on the local machine.
• Corrects a performance issue in the previous release which would appear to cause Querious to lock up.

New:

• Adding JSON column type support (MySQL 5.7.8+)
• Added support for adding and editing Generated Columns (MySQL 5.7.5+)
• Added JSON (text-editing) panel to the field value editor panel with syntax coloring and validation
• Added new preferences to control whether tables/columns/etc are suggested in autocompletion. Turning these options off reduces the need for Querious to perform queries to look them up, improving responsiveness.
• When selecting "Show All" in a Data File window, it immediately shows all the records instead of requiring the "Show All" button to be clicked.

Changes:

• Massive refactoring of the import panel to prepare for upcoming new features. (wink. nudge.)
• Lowered the SSH keep alive interval to 60 seconds from 240 to hopefully prevent silent SSH tunnel drops by NAT/routers.
• The field value editor's text view uses an in-field find bar instead of a separate find panel window.
• Over 10x improvement in slow query log parsing, and improved scrolling smoothness.
• Adds a note in the crash reporter for crashes with "bear trap for <rdar://problem/20935868>" to explain that this crash is caused by a bug in OS X El Capitan. Crashes in Querious are quite rare, and this is by far the most common crash.

Fixes:

• Fixes the Selected Database popup in the Query view so that type-to-filter and then picking a menu item works properly on El Capitan. (OS X broke this.)
• Fixed autocomplete not suggesting view names in the Query view
• Fixes some query text drawing in lists (such as in the slow query log) from strangely drawing text on top of itself. (OS X broke this?)
• In SQL exports, the CREATE DATABASE statement is now immediately followed by a USE statement so that everything after that (creating tables, importing data) works properly on import.
• Shifted the disabling of foreign key constraints in SQL exports to be *before* creating tables so that the dependency order creating the tables is irrelevant.
• Fixes the "no database selected" error which could occur when duplicating a database.
• The Table Indexes view allows adding and editing FULLTEXT columns.
• Fixed a crash in the Server Processes view which could occur when an error happened.
• Fixed a rare crash if somehow a function/procedure had no "definer" value.
• Fixes a crash which could occur when trying to open the popover to change a table index's columns.
• Fixes a bug in the Table Content view where the wrong row position and count could be shown after returning to a previously selected table.
• The Show All / Filter button in the Data File window is appropriately "Show All" when first opening a document.
• Changed the text drawing optimization to not chop off long single lines of text anymore in the Table Content and Query views.

New:

• Added an Advanced preference for preferring utf8mb4 over utf8 for the connection encoding when the server supports it. (Using utf8mb4 enables you to store emojii in your columns, for instance.)
• In the Query view, the Run button has been moved slightly, an "Action menu" added (with the same actions as in the query editor list on the left), and Save/Revert buttons will appear when modifying a saved query.
• You can now pick a storage engine at the time you create a new table.
• The Table Info view's storage engine popup now shows all available engines on the server.
• Table Status in the Database Content view has more columns available to be shown. Right-click on the column headers to show/hide them.
• The Server Processes view shows timestamps now. It also remembers and shows more slices for when the window (and chart) is wider.

Fixes:

• Copying rows as SQL from a single table inside the Query view when the rows don't include a PK no longer silently fails and breaks things.
• Fixed a recent issue preventing editing the column value of multiple rows at the same time in the Content View. (It was showing an encoding error.)
• Fixed a recent issue where connection to "localhost" would make the Server view think you were connected to a remote machine and want SSH access.
• Fixed the Server Variables search field losing focus while typing.
• Fixed an issue in the Server Variables view where non-session dynamic variables were read-only.
• In the Table Content view,if the search has no conditions (eg, full text search, but an empty string), it won't generate an empty WHERE clause and then complain.
• Prevents a crash when (for some reason) the indexer gets a nil value for a column name from the information_schema table.
• Fixes small visual bugs on El Capitan.

Fixes:

• Fixes some problems with the display of options for the "Run SQL Script" option in the File menu, and related crashing.

Fixes:

• Small change for OS X El Capitan compatability. Grab this version before updating to El Capitan.

New:

• When deleting a row or rows in the Table Content view, the removal is done without refreshing the entire view, and the selection remains nearby.
• Previously-selected rows (identified by PK values) are re-selected after a refresh in the Table Content view.
• When viewing/editing a binary column's value in the field value editor sheet, and the Text tab is shown in the sheet, you can now pick which character encoding to interpret the binary data with. The editor is also smarter about detecting encoding errors for textual columns, and preventing invalid data from being entered.
• In the Slow Query Log view, it's now possible to use "Open…" in the action menu to open a log file even while slow query logging is disabled in MySQL.

Changes:

• When manually doing a Refresh All, the Query view's autocompletion indexing is also refreshed so it will pick up changes run without Querious knowing.
• The Open panel shown by "Run SQL Script" does not use an "accessory view" on El Capitan because it's hidden by default. (Terrible OS X behavior change if you ask me.) It's a separate sheet now so that it's forcibly always shown.

Fixes:

• When refreshing the Table Content view, if the columns in the table have changed, Querious will now notice and properly display the current columns.
• The Query view's behind-the-scenes MySQL connection is guaranteed to not have a selected database at first, as is advertised by the popup. (Before it was possible there may have actually been a selected database on connection.)
• Selecting a saved query's menu item from the favorites bar above the query editor in the Query view while a saved query is selected in the query editor list / sidebar, will no longer modify the selected saved query and instead open a new query editor.
• Fixed a problem in the slow query log parser.
• Fixed a crash which would possibly occur sometime later after viewing the Server Processes view.

Fixes:

• Fixed a rare recently-introduced bug where Querious may crash when entering the license key. (What a horrible first impression. Sorry.)
• If there are no databases on the server, the add button below the list is now correctly enabled so that a databaes can be added.
• Fixed a crash for the few OS X Lion users out there. Once again, the minimum system version after Querious 2.0 goes final will be increased to OS X 10.9.

New:

• Added SQL query formatting capabilities in the Query view. See the Editor menu, or right-click in the text view.
• When selecting a column from the Table Content search view list, it will only show the conditions (is null, contains, etc) that make sense.
• Added a notification if Querious is in the background when a long query executing in the Query view finishes.

Changes:

• Updated the status view in the toolbar, and the Table Content search controls for El Capitan appearance.
• The column mapping views (for CSV/Tab import/export) uses contemporary styling on Yosemite and later.

Fixes:

• Fixed a recently-introduced bug where Querious wouldn't quit if there were no connection windows open.
• Tabs in restored windows appear in the same order as they were at Quit time.

New:

• Added a Stop on Errors option in the Query view. It's accessible in the pulldown menu of the Run button.
• Added a "use batched inserts" option to CSV/Tab import. When batched inserts are used, it's not possible to give a specific file line number if an error occurs.
• Added an option to SQL exports which controls whether foreign key names are included in the SQL.
• If closing the connection tab/window while there are unsaved changes to saved queries in the Query view, it will ask to accept, reject, or review those changes.
• If closing the connection tab/window while there are running queries in the Query view, it will ask whether to stop the queries or not.

Changes:

• Removed the Delete/Drop button from the primary (left) sidebar in the Content and Structure views. Instead, you must use the Delete menu item in the Action menu.
• Disabling the translucent "source list style" in Query view's results list to see if it works around an OS X Yosemite bug which has been causing crashes.

Fixes:

• Fixed some checkboxes in CSV import not remembering their selection after relaunches.
• If a string encoding conversion error happens during import of CSV/Tab, it's now always caught and an error shown.
• The "Go To" window no longer suggests the database as a result when searching for 'database.table'.
• Fixed the mysterious bug that was preventing connections settings from being saved for a handful of users.
• The schema object deleter panel's Cancel button responds to Escape and Command-Period
• Fixed bugs in the user privileges view where adding privs for a table or column when there were previously none explicitly set, wouldn't display properly.
• Fixed a minor issue where when cancelling an import, there was a delay before it visually appeared cancelled.
• Fixed several crashes.

New:

• The checkboxes for adding DROP statements to SQL exports turn red when checked, as a friendly cautionary indicator.

Changes:

• The Content and Query view row table views do not have vertical "elasticity" when scrolling. It's not the ideal solution, but it's a workaround for an unfriendly default OS X behavior where the elasticity could cause all scrolling to stop. (Still waiting for a response to a bug report filed with Apple.)

Fixes:

• Fixed a crash when duplicating an empty database
• Fixed missing dialog text for table operations
• Misc stability fixes.

New:

• Added CREATE/DROP DATABASE option to SQL exports.
• When changing the Content view row limit in prefs, the Content views will change immediately to reflect this.

Changes:

• When duplicating a row in the Content view, the autoincrement column is left without a value.
• When inserting a new row in the Content view, if the autoincrement column value is blank, it will be assigned the next autoincrement value.

Fixes:

• The column names in table index creation SQL statements are now always quoted.
• Fixes the text "(null)" in the dialog when changing the password for all hosts of a particular user.
• Fixes initial focus in password reset for Server User dialog.
• Fixes the vertical scale of the Processes view in the Server view when there are many of them.
• Fixes a rare crash when SQL importing.
• Fixed a problem with the mysql.user_info table fields not being properly escaped when modified.
• Fixes a problem with CURRENT_TIMESTAMP as a value in the Content view not working properly.
• Sets and Enums with backslashes and escaped character sequences are handled properly.
• Fixes MySQL privileges not being interpreted correctly if the PAD sql mode is on.
• Misc stability fixes.

New:

• The CHECK table operation now shows multiple rows when applicable.

Fixes:

• When exporting CSV/Tab records from the Query view, it now uses the correct encoding for the data rows. (It was always using UTF-8 before.)
• When exporting CSV records from the Query view, it now respects the "always enclose" option.
• Fixes a crash introduced in the previous beta when an error occurs fetching server logs.

New:

• Added "Show value suggestions menu" in Results preferences which displays a popup in each cell where possible values such as NULL, 0, CURRENT_TIMESTAMP, etc are listed.

Fixes:

• Fixes a crash introduced in the previous beta, caused by loading processes in the Servers view and then switching to another view before the load was done.
• Fixes a crash introduced in the previous beta when an error occurs fetching the server errors log. Ironic?

New:

• Server Processes list is sortable
• In the Table Content and Query views, NOW and CURRENT_TIMESTAMP, which are valid values to type into a cell (like NULL), now allow a parenthesis suffix ()
• The Table Structure's Columns view now has the CURRENT_TIMESTAMP and ON UPDATE suggestions for both datetime and timestamp.
• The Table Structure's Columns view now allows creating datetime/timestamp/time fields with fractional seconds (new in MySQL 5.6)

Changes:

• This build completely changes the whole way keychain items are managed. Keychain items used by Querious were previously "internet" keychain items, and now they are "general" password items. Querious will automatically create and begin using the new keychain items, but will leave the old ones intact. If they are unused by any other application, you may at some point remove those older items if you wish. New items are clearly marked with the prefix "Querious: " in their name.
• Significant memory optimizations when reading the slow query log from a file.

Fixes:

• Several fixes related to handling of the data types/length/default value in the Table Columns view, which will avoid the possibility of creating query errors.
• With a recent query selected, the selected database can't be changed. (It's always "None") This is because you can't run these queries so it's wrong to be able to select them. In the future they *should* be runnable, but that requires some changes to handle the recent queries list changing and the tab moving, etc.
• In the Table Indexes view, you now can't start adding a second new index to a table if the first new index is incomplete and unsaved.
• Fixed a crash when copying the first column in a records document / data file.
• Should fix any possibility of the server access view being blurry by being positioned on a half pixel somehow.
• Switching between Content/Structure/Server and Query no longer "empties" the Table Reference sidebar in the Query view.
• Should correctly fix the line number drawing in query text view sidebars which broke in the previous beta.
• Fixes a crash if getting the SSH user authentication methods list from the server fails.
• Many miscellaneous stability fixes.

New:

• The Query view has been heavily reworked again, to make big improvements to the usability. The Query view now supports multiple "tabs" or "editors" which are listed in top of the left sidebar under "Queries". There is one by default, but you can add as many as you want. You can also directly open a file up as an editor. Saved queries are shown directly below the query editor "tabs", and editing them is done by simply selecting them, which is a great improvement from before. Simply dragging a saved query to the "Queries" area will add a new query editor, and dragging a query editor to the Saved Queries editor will add it as a new saved query. See the action menu on the right side of the row for any editor saved query to see a number of other features.
  
  The "Selected Database" list is now a popup at the very top of the query editor text field. Clicking on the popup will show a filterable menu with all of the databases in it. This "Selected Database" will be the target of a 'USE [DATABASE];' statement executed before executing the designated queries in the text field. If no database is selected, no USE statement will be executed by Querious.
  
  
• File->Open in the Query view can open the file into the editor or a new window. A panel pops up with a choice of destination.
• The query view's tabs and queries are restored after relaunch.
• Added a button to the top of the left sidebar in the Content and Structure views that invokes View -> Go To.
• Added Comments column to the Table Columns view. This can be shown or hidden by right-clicking on the column headers.
• Colored connections now color the status view when Reduce Transparency is turned on in system preferences.
• Added an Edit button below the connection fields in the connection view when a saved connection is selected.
• Added "No Saved Connections" text to the connections sidebar when there aren't any.

Changes:

• Big performance improvements to the database indexing done in the background (for View -> Go To, and autocomplete etc)
• Improvement to the "Go To" result priority sorting
• Optimizes Query view's result display performance

Fixes:

• Fixed fuzzy connection name field in connection and reconnection views.
• Fixed small text color bug in the saved connections list.
• Window title is correct for reconnected windows opened at launch.
• Fixes a crash in Tab file importing when the number of columns in all lines does not match.
• Fixed a crash in the Database Relationships view when doing the relationship layout. Seems to have only ever happened when there are really long table names.
• View Structure: if definer is NULL for some reason, it won't crash.
• Fixed a visual bug in the Relationships view where connected tables weren't always shown in full alpha.
• Copying rows from Table Content no longer has missing column names for the columns which are hidden from display.
• Several miscellaneous stability fixes.

Fixes:

• Fixed a problem in the Table Content view where columns may be hidden in certain situations.

New:

• Added more info and options to Table Info view including Row Format.

Changes:

• Changing the table engine is first confirmed, and an indeterminate progress dialog is shown while the change takes place.
• Renamed Table "Info" to "Options & Info"
• Reduces how often new MySQL connections are needed.
• Small optimizations to View -> Go To

Fixes:

• Fixed a crash that popped up in beta 19.
• Routine parameters are parsed correctly when the IN/OUT/INOUT keyword is not present.

New:

• Added a large progress indicator to the Table Content view when it takes more than a second to load.
• When creating a database, you can specify non-default charset and collation.
• Added Database Structure -> Info subview which lets you modify the database's default character set and collation.
• The Table Operations menu in the contextual menu of the left sidebar in the Content and Structure views lets you truncate multiple tables at the same time.
• The Selected Database list in the Query view has a button to reveal a search field.

Changes:

• Exported views' create statements are tweaked so that the select statement doesn't absolutely reference the exported-database's name. This would let you export views in one database and import them into another database, and not have the views actually be referring to columns in the original database. The same goes for triggers.
• Database Relationships now behaves better when there are lots of tables. There's an immediate fast layout done, and then it'll do the nicer-but-slower layout in the background. Layout is also cached so that when switching back and forth, the cached layout is used and thus the view can immediately be used.
• The "View -> Go To" window opens instantly and loads database and table names etc in the background as needed. It also re-opens instantly without needing to load anything.

Fixes:

• MySQL errors during fetching results sometimes weren't reported.
• Fixed a small bug with navigation history.
• Fixed the Show Columns… feature in the table content view. It was goobered up recently.
• Misc memory leaks fixed.
• Misc stability fixes.

New:

• Added color-coded connections on OS X Yosemite. Edit a saved connection and pick a color with which to tint the window titlebar. This color coding will help you distinguish between development and production servers, for instance.
• Added export file name templates. At the bottom of the export sheet, there is now a button to edit the default file name for exported files.
• When switching between subviews of the table structure view (eg Columns and Indexes etc) it now confirms if there are unsaved changes.
• Added "Copy Insert Statement" to the contextual menu when clicking on a table in the left sidebar in the Content and Structure views.
• Added "Copy Name", "Copy Create Statement", and "Copy Insert Statement" to the contextual menu on listed columns and tables in the Reference sidebar in the Query view.
• Added the ability to change the sort order for the columns listed in the Table Reference sidebar in the Query view.
• Double-clicking on the icon to the left of the table/column name in the Reference sidebar in the Query view will insert the name into the query text view.
• SSH connections in Querious work with "shared ssh connections" if specified in the OS X user's ssh_config file.
• Added a "Reset Colors" button to the Syntax color prefs.
• Added Apply/Revert buttons so that multiple changes can be made to the primary key column list at once.
• Queries are shown for errors when dealing with primary key and autoincrement.

Changes:

• The Users view should have noticeably better performance due to reducing the number of queries significantly.
• Tweaking Records document appearance for Yosemite.

Fixes:

• Fixed a hard to find crash in CSV and Tab importing. This was the most common of all Querious crashes. Rejoice.
• Fixed a crash when doing "Processing" in a "Records" document. This was the second most common crash. Rejoice.
• Fixed a crash which could occur when cancelling a connection.
• Turns off secure_auth mysql option which blocks connection to servers with 4.1 hashing styles. You should really really update your password hashing on the server if you were affected by this.
• The Relationships view now draws at a Retina resolution on Retina displays.
• Fixed the upside down drawing in the Database Relationships view on OS X 10.7. Please note that 10.7 and 10.8 support will likely be dropped soon after 2.0 final is released. You should really update to 10.9+ or later.
• float and double column types no longer have a specifiable length, avoiding some syntax errors.
• Fixed a potential crash when deleting saved connection settings that are also selected in a different window.
• Removed 'is NULL' from Records document filter options They can't be null and using this would cause a crash.
• The shortcut completion key specified in preferences works again when autosuggest is off.
• Selecting "Check for Update" very soon after launch will show the progress window. Before it may not have depending on timing.
• If the list of tables in a database has changed, the Database Content view will show the changes. Before it may have needed to be manually refreshed.
• Misc stability fixes.

New:

• Cmd-S (File -> Save) will save the being-added row in the Table Content view.
• Refreshing the Table Content view while there is an unsaved row will now display an unsaved changes sheet.
• In the Table Content view, a search condition against a numeric column using IS or IS NOT now does an = or != as is appropriate. (Previously, a string comparison was done which although the results were correct, was slower.)

Changes:

• The Query view now has its own dedicated MySQL connection used to execute all queries. In the past, if you executed 3 queries at once, all three queries would be executed on the same connection. However, if you executed 3 queries at different times, they may have been run on different connections, which could cause issues with transactions. If the mysql connection to the server is dropped, a new connection is formed.

Fixes:

• When searching with the Table Content view, the total number of rows in the table is no longer shown, as it can be mistakenly interpreted as the total rows found by the WHERE clause.
• Fixed an autocomplete suggestion bug near the 'FROM' keyword.
• Fixed the saved connections list small size row height.
• Fixed a bug preventing updating indexes.
• Misc stability fixes.

Changes:

• Server Processes now shows a State column.
• Added Query duration to the Server Transcript view.
• Table Status view adds an Index Size column.
• The Database Content view's Table Status view shows a spinning progress indicator while loading the table status.
• Users view shows when the user does not have grant privileges for global/db/table/column.

Changes:

• Some fixes and tweaks for appearance on OS X Yosemite.

Fixes:

• Fixes a bug in the Users privileges view where the Global Privileges couldn't be selected
• The Table Content search view previously asked for the number of rows in the table even when it didn't need them. This is fixed, and improves performance by not performing a useless query.
• If an error occurs when creating a table index, the error alert now shows the full query used to attempt creation, and the Revert button properly reverts.
• If the slow query log fails to load, the full error message is shown now rather than missing the reason it actually failed.
• Fixes an unlikely but potential memory problem when CSV/Tab importing.
• No longer shows release notes to first-time users.
• The import panel for the records window shows the right style now.
• Fixed a small visual bug during connection restoration at app launch. It wouldn't update the UI after having selected the restored settings so it'd look like it was connecting to the wrong server.

Changes:

• Changed the Keychain password management. The noticeable difference is that it should only ask for permission to use a Keychain item once per app launch, and only if the saved connection settings are selected in the sidebar, to be edited or connected to. Before it could ask for permission for every item, perhaps even multiple times, on launch, depending on the Keychain access settings.

Fixes:

• When showing/hiding the tab bar, it now shows/hides in all windows accordingly.
• Misc stability fixes.

New:

• On OS X Yosemite, The tooltip for the main view switches shows up immediately on mouse-over now
• The slow query log file path is now selectable so it can be copied.
• Double-clicking on a table in the Database Content view's table status list will navigate to that table.

Changes:

• Clicking in the empty space in the saved connection settings list will clear the selection and settings in the main connection view.

Fixes:

• Fixed a bug which was causing passwords to not be saved in Keychain in certain circumstances.
• Table indexes can now properly order the columns again. (Broken in a recent beta.)
• The selected tab's "name" now shows in the Window menu items in OS X Yosemite.
• Using Return and the arrow keys to edit different column values in Table Content view works even when changing the cell values. Before it only worked if the values were untouched.
• Fixed a bug with the Query view's autocomplete list row height being wrong when using a non-default font.
• Fixed a bug where the autocomplete list columns weren't sized properly sometimes.
• Fixes a few subtle bugs where certain keyboard interactions wouldn't work if caps lock was on. Weird, right?
• Some visual fixes for OS X Yosemite.
• Misc stability fixes.

New:

• Added a preference (in "Advanced") for refreshing all databases after an SQL import. Disabled by default.
• At the end of a CSV/Tab import, the Content view will refresh if viewing the table that was imported into, there are no modifications, and there is no field value being edited.
• In the Table Content view, if an error occurs when inserting a new row, the full query is shown, and an option to "Revert" which will remove the to-be-added row.
• Added better error messages and handling in the Table Content view when updating an existing row, and either Querious can't find the row in the database to update, or can't find the row in the database after having updated it.
• Added "Show Transcript" to the Connection menu.

Fixes:

• When entering an empty value for a numeric type column, it'll use the column's default value as expected.
• Fixed a rare crash when saving table content mods even if there were no modifications, trying to display a nil error
• Fixed a crash in the Server Variables view when editing a value and then filtering
• In error alerts that contain an SQL query, Return/Enter etc work to hit the buttons rather than doing nothing.
• Misc stability fixes.

New:

• Added a new preference "Up/Down arrows change rows when editing" in the Results panel. Adds a spreadsheet-like editing mode in result lists.
• Added a Disable Foreign Key Checks option to the SQL import options
• Added an explicit SQL export option for disabling foreign keys. It's now no longer tied to the "Disable keys" setting
• Selecting multiple items in the primary sidebar in the Content and Structure views, right-clicking, and then choosing Export, will now select all of those items in the Export panel. (Such as in the SQL export view.)
• Server Processes view shows the query as an additional column.

Changes:

• In the Table Content view, anytime the search comparisons change, the starting row offset now resets to 0.
• Moved some menu item separators around in the Table Content contextual menu so hitting "Set to NULL" accidentally is harder.

Fixes:

• Fixed a bug introduced in beta 10 where the list of columns in the Table Content view's search popup was empty in certain circumstances.
• Fixed a bug in the Connection Settings panel where clicking the Test Connection button wouldn't use the password currently entered into the password field if the password field had the keyboard focus.
• Fixed a rare and very funky crash in the Query view during text completion.
• Double-clicking on a folder in the saved connections list will edit the folder name again.
• Fixed certain query error dialogs being insanely tall.
• Exporting views as CSV/Tab works appropriately again.
• The import panel's tabs use the correct new style, matching export.

New:

• Added a new popover to make adding/editing table indexes easier
• Added "Index Size" to the Table Info view.
• The primary sidebar in the Content and Structure views can now be much much wider as long as there is room in the window.

Changes:

• Changed the "Null" column title in Table Columns to "Allow Null"
• The Tables list in the Relationships view controller is hidden by default.

Fixes:

• Bug fix for Table Content searching lockup introduced in Beta 10

New:

• The Table Content view now shows the total row count for MyISAM tables
• In the Table Content view, added a warning indicator when the search range is past the end of the table. (When it can determine that quickly.)
• The Table Content range "popover" now searches when pressing Return in the Start or Limit fields; Before it would search once the popover closed.
• Added a preference to disable caching rows in the Table Content view. If caching is disabled, but Automatically Retrieve Rows is turned on, then every time you switch to the Table Content view, it will requery the database for rows using your previous search settings.
• When adding an index, it'll automatically pick a name for you if left blank.
• Database Duplication errors now have a log that can be viewed to determine the reason for failure. Click on the "Reveal" button in the Imports & Exports progress window next to the error to see the log.
• The Database Content view shows icons indicating table vs view.

Fixes:

• Added a fix for Database Duplication creating triggers before their associated table.
• When deleting a table index that is not in the database, it no longer gives an error message saying it doesn't exist.
• Server Processes view colors were incorrectly swapped.
• Fixes a rare problem when duplicating a table's content where it could hit the maximum packet size.
• Fixed a bug where the error message when adding a row in the Table Content view wasn't fully displayed.
• Table Content View: When adding a row, if an error occurred the row would be unselected in the row list. This wasn't supposed to happen, and would mean that re-selecting the row would trigger the same error again. A minor annoyance.
• Fixes an odd crash in the Query view when using autocomplete in very specific circumstances.
• Fixed a crash that could occur if invalid settings were used when trying to open a CSV/Tab file in Querious.
• Fixed a bug that could cause a crash if a connection tab was closed at a specific point during the connection.
• Fixed a crash that could occur when using the Action menu to export multiple items selected in the primary sidebar in the Content or Structure views.
• Fixed an issue in the Server Processes chart view causing a crash.

New:

• Added mysqldump-formatted XML exporting. This lets you export structure and content of an entire database (or individual pieces) in the XML format that mysqldump uses.
• New visual style for the export/copy/file format sheets. Yosemite-appropriate.

Fixes:

• Fixes a bug introduced in beta 8 for certain SSH connections.

New:

• The Tab Bar can be hidden if only one tab is open. This is now currently the default. It can be changed in the View menu with the "Show Tab Bar" or "Hide Tab Bar" menu item in a window with just one tab. This is the same as the behavior in other Apple programs.
• When entering the same address for the MySQL host as the SSH host, Querious will fallback to using 127.0.0.1 as the MySQL host if using the entered address fails. Entering the same address for both is technically incorrect, but not and uncommon thing for new users to do leading to confusion when the connection ultimately fails.
• More helpful error messages (and the SSH connection log) are shown when SSH connection failures occur.
• Binary (when shown as hex) and bit column values are drawn in dark gray as a reminder.
• Added CSV/Tab import feature to use REPLACE INTO to update existing rows in the table.
• The Server Errors Log view will display errors more clearly now.
• Added an action menu button below the Primary Sidebar
• In the Primary Sidebar's action or contextual menus, hold Option to see Open in New Window
• Added a preference to disable restoring connections on launch

Changes:

• The refresh button below the Table Status list in the Database Content view reloads everything now and counts rows in all tables.
• The bottom bar of the window is smaller, saving a bit of usable space for small screens.

Fixes:

• Server Status view's left side stats are now scrollable.
• Fixes some rare crashes in the CSV importer.
• Fixes a bug in certain circumstances when closing the window or tab while table columns has unsaved changes.
• Fixes query result or content view row exporting to CSV/Tab issue with bit columns
• Works around a bug in OS X that can make Return/Enter edit the wrong row in the Saved Connections list.
• The Server Errors Log view will handle relative file paths to the log file.
• Fixes a lockup which could happen in the Server Processes view.
• Fixes a trivial display bug in the confirmation sheet when deleting a database where it'd show the database name twice.
• Misc stability fixes.

New:

• Many many tweaks to the appearance on OS X Yosemite. Pretty much done. Please report any problems or quirks with the new appearance.
• Query view lets you select the "RESULTS" header to see the more detailed results for all queries. The title of the boxes in the results row is also changed to the query text itself rather than "Query 123"
• When in the Content or Query views, if the Export menu item in the File menu is used, it'll now ask what you want to export: the displayed results, or something directly from the database.
• Added New Query/Folder and Delete to the menu when right-clicking in the Saved Queries list
• Added a preference to control whether recent queries executed in the Query view are saved between launches. (This allows you to turn it off, so no security-sensitive queries are saved.)
• Added finer-grained preferences over which "long" column types are not automatically loaded in the Content view.
• Querious remembers which tab was selected when re-opening windows after launch.
• Added a button to toggle the Tables sidebar in the database relationships view.

Changes:

• Significant changes to fetching of table, column, trigger, etc names for autocomplete in the Query view. The result is fewer queries will be sent to the server which should reduce a lot of overhead on large databases.
• Query view's list of query result statuses now shows the number of queries with errors.
• The Query view's selected database is independent of the Content/Structure views. It remembers what was last selected each time you go to it.
• The Transcript view displays the query in the user's query font
• Previously when a table was duplicated it would always drop the foreign key constraint names from the CREATE statement so that there was no possibility of name collision (since MySQL requires them to be unique throughout the database). That has now changed so that this will only happen if the table is duplicated into the same database on the same server as the source database.

Fixes:

• The preference for what the connection tab label showed was backwards.
• Fixed some small memory leaks.
• Fixed a crash that could occur on an error when duplicating a Table.
• Fixed a bug where deleting a row that has FKs pointing to it, would throw the error sheet while the delete confirmation sheet was still shown, and would then cause weird bugs to happen.
• Fixed a crash when typing multi-part characters in the query text view, if autocomplete was already showing something. (In other words, if it was displaying a completion for a partial word, typing option-e on a US keyboard to add the ´ accent character, would then cause a crash when the next key was pressed.)
• Small fix so that when importing saved queries from v1, if there weren't actually any saved queries, it doesn't add an empty "From Version 1" saved query collection
• Fixes the data file editor not working in OS X Yosemit in recent betas.
• Fixes a bug in the Query view where the File->Export menu wouldn't really do anything if no executed query result rows were showing.

New:

• Added Triggers tab in the Table Structure view.
• Querious will automatically import Sequel Pro saved connections into a "Sequel Pro" folder for convenience
• Added Import/Export Saved Connections menu items into the File menu. Supports formats for Querious and Sequel Pro.
• Connection windows still open when Querious quits, are restored when Querious is relaunched.
• Added syntax recognition and coloring for <#placeholders#>
• The Query view limits autocompletion suggestions to include tables, views, columns, etc from the selected database only. This makes it more useful in the majority of cases by making it easier to pick from the list.
• Experimenting with a few context-aware autocompletion cases. When in a FROM clause, it'll only suggest tables and columns in the current database. (Eliminates views, columns, etc from the results)
• The table reference in the Query view now shows tables in the selected database if no table is already selected and showing columns.

Changes:

• Changed the main connection tabs to fill the entire width of the window, like Safari and Finder.
• The tab label when the Query view is selected is now "Query: name-of-selected-database"

Fixes:

• Disallows tab dragging when it's the only tab in a full screen window.
• The tooltip when hovering over a database/table/etc in the left side primary sidebar is now wide enough to show the entire name.
• If the initial selected settings in a new tab/window used SSH or SSL, those security options controls weren't shown.
• Fixed a crash that could occur during query text editing.
• Fixes some minor issues with autocompletion in query text editing.
• The connection window toolbar doesn't allow item reordering, but does save the icon/text style. There's still an issue with text-only caused by OS X though.
• The View -> Go To… window always opens in the right location on screen.
• When focused on a particular database, the View -> Go To window will properly switch databases when a location in a different database is chosen.

New:

• Added a button to hide the query results at the bottom of the Query view
• Added "Duplicate Schema Object..." menu item in Connection.
• Database Content's list of tables can now be sorted by size, row count, etc
• New option for CSV/Tab importing to treat empty values as NULL if possible.

Fixes:

• Fixes varbinary columns not being displayed correctly.
• Fixes single-value enum/set columns not showing the single value.
• SQL exports no longer have the database name as part of the CREATE statement for views.
• Fixes super-tall confirmation window when deleting many tables/views/etc at once.
• Fixed multiple SQL syntax coloring bugs.
• Fixes an issue when deleting a lot of tables at once, where Querious would hit the MySQL connection limit.
• Fixes the progress indicator spinning when the Query view is no longer selected, even after queries have finished.
• Worked around some performance issues with tearing off tabs on OS X 10.9+. (A necessary component in OS X unfortunately became significantly slower since previous OS versions.)
• When dropping a torn-off tab to create a new window, the window location is now correct.
• The Table Name column in the Database Content view is wide enough for the longest allowed name.
• Fixed an SSH tunnel related crash which could occur in several situations, such as waking the machine up from a sleep.
• Fixed a crash caused by deleting a folder while editing its name in the connections list.
• In the Table Content and Query views, when editing a field value with the popup-sheet, it will fall back to sending a literal hex value if needed. For example, if editing the value of a latin1 string column, then if latin1-encoded characters are entered as hex into the Hex tab, that hex value will be send as a literal hex value to MySQL, bypassing the interpretation in the connection encoding, and having MySQL do the conversion from the connection encoding (utf8) to latin1 before storage.
• Avoids a one-off crash in the Database Relationships view.
• Should fix the possible crash-on-launch after updating on OS X 10.10 (Note that this applies only to updates after this one.)
• Fixes a crasher in the database indexer when multiple structure-changing queries are run back-to-back in the Query view.
• Fixes a potential lockup when running queries in the Query view.
• Fixes a crash that could occur when dropping/deleting a MySQL user.
• Fixes a crash that would occur if the first line of a CSV/Tab import was said to be column headers, and one of those headers was an empty string.
• Fixes a minor issue stability issue with SSH tunnels.
• Fixes a potential crash when deleting tables/views/etc.
• Fixed the data file Process copy-to-new-document crashing.

New:

• Dropping a .sql/.txt/plain text file onto a query text field will insert the contents of the file into the field.
• The Selected Database list in the Query view always keeps the selected database visible and centered so it's always easy to see.
• When results are shown for the first time in the Query view, it sizes the results area to fit the results shown.
• The saved connections list remembers which folders were open and which settings were selected.

Changes:

• No longer need to click-and-hold on the Add button in the connections view sidebar to add a folder. Clicking immediately shows the menu

Fixes:

• The Query view's query execution behaves better when DELIMITER is involved
• Confirms row deletions in the Content view, and changes to table columns in Structure by default. This was accidentally off for new users.
• Immediately disables toolbar items when switching to an unconnected tab.
• SQL exports with CREATE statements using compound statements are enclosed in delimiter swaps.
• Query view: no longer deselects the "selected database" when executing certain queries which modify structure and cause the list of databases to be reloaded.
• Only when copying rows to the clipboard as SQL, empty strings may have been written as NULLs in the query.
• Fixes a bug where certain rare errors in SQL exporting could cause a crash.
• Importing SQL files where a string column's value contained a null byte no longer causes a syntax error.
• Executing statements with null characters in them in the Query view no longer causes a syntax error.
• Deleting a row in the Content view, where a string column's value contains a null byte and that column is part of the primary key, no longer causes a syntax error.
• Fixes a crash on those 2 computers in the world without Arial installed.

New:

• Double-clicking on text in query text fields will no longer select neighboring commas, periods, etc. The new behavior should be much more appropriate for SQL.

Fixes:

• The Content/Structure/Query/Server buttons work when the connection window is full screen.
• The Query view list of query results no longer shows the same query string for (some) multiple results.
• The Table Columns view no longer attempts to use the empty string ("Invalid") as the default value for enums that can't be NULL. MySQL doesn't allow it.
• Fixes a crash on those 2 computers in the world without Arial installed.
• Database Relationships sidebar: no weird graphical glitches when resizing.
• When right-clicking on selected text in a query editor, it no longer deselects the text
• Fixes minor visual issues after the connection was dropped and reconnected.
• New tabs in a window have their initial focus set on the saved connections list.
• The SQL file editor window now supports the Find panel
• Fixes an issue with query text fields not using the background color set in preferences.
• Fixes an issue with relying on a deprecated MySQL variable for slow query logging. This could falsely report that slow query logging was disabled.
• Server File Manager won't connect unless there's an SSH username specified.
• Fixes validation of license keys from Q1 where the owner name contained certain unicode chars.

New:

• Added a "Count Rows…" menu item to the contextual menu for tables in Content and Structure

Changes:

• The Truncate table operation no longer displays an alert on success.
• Absolutely ensures update checking is always performed.

Fixes:

• The Query view's field-value double-click behavior correctly matches the Content view's
• Cancelling the field value editing sheet no longer commits the value despite being unchanged.
• Using "Go To…" and selecting a database will now change focus to that database in the Content/Structure view's sidebar if there already is a focused database. Otherwise it will continue to select and it expand it as before.

New:

• When focused on a database, that database is now shown in the list as well so it can be selected to see its Content and Structure views.
• Added "New" toolbar item
• Fields show "…" truncation if their text is not entirely visible.
• Added the ability to force-delete tables, ignoring foreign key constraints.
• When removing the primary key of a table where the pk column is autoincremented, Querious will now turn off the autoincrement first for you to avoid the error.
• Updated documentation in the Help menu
• Added menu items in Help for emailing support

Changes:

• Content view is shown first when connecting instead of Query.
• Users list and Privileges list use a smaller font size.
• Table Reference column list in Query view is easier to read by dimming the column type.
• Querious itself has a smaller file size.

Fixes:

• Fixes a crash in the Procedure structure view during autocomplete
• Fixes a potential crash when display results in the Query view.

Fixes:

• Fixed the disconnected Run Query button in the Query view.
• Fixed a crash that could occur when clicking on the Import or Export toolbar items.

New:

• All-new Query View layout refinements. The sidebar on the left is explicitly and clearly for choosing the "selected" database when executing queries. There is now also more width available for query results when more than one query was executed. The Saved Queries editor view also has more room when displayed.
• Added a new Table Reference sidebar view to the Query view. This lets you see the structure of a table without having to switch to the Structure view, find it, and then switch back. Typing a table name (in the current selected database) will automatically show that table in the reference sidebar for convenience.
• Added a "Use Query" pull down menu to the Saved Queries editor. Let's you run, copy, or insert the query back into the editor.
• Database Content view: added button to reload the row count of all tables at once.
• The connection window toolbar now uses the newer "flat" style icons.

Changes:

• Escape when editing a table cell in the Content or Query views will end editing without changing the value of the field.
• The left sidebar in the Content and Structure views now uses 11 pt font instead of 12, and the row height is also slightly smaller.
• Some changes to syntax parsing performance.

Fixes:

• A critical fix for the table duplication process where the wrong table name was being used in Preview 10.
• Fixed a crash that could occur when closing a connection tab or window.
• The table content cache is always invalidated properly after deleting a row or rows from the Content view.
• Fixed a bug when editing server access / SSH settings preventing the settings from being saved.
• Single line comments with "--" no longer incorrectly require a space after.
• A few misc stability fixes.

New:

• Duplicate Database - You can now right-click on a database and select "Duplicate" to copy the entire structure and data to create a new database on the same or a different server.
• Duplicate Table/View/etc - You can now duplicate tables, views, triggers, events, functions, and procedures on the same server, or between different servers.
• Added Table Operations to the Connection menu
• Made Delete and Duplicate work for primary sidebar selection if first responder
• The transfers window is brought to the front when a transfer finishes if hidden behind other windows.
• New preference for whether the tab label shows the server nickname/host or primary selection.
• When "focusing" the sidebar on a different database than is currently focused, it will select a table/view/etc of the same name as is currently selected. In other words, if the "development" database is focused, and the "orders" table is selected, switching to focus on the "production" database will automatically select the "orders" table in the sidebar.

Changes:

• Moved "Go Quickly" from the Connection menu to "Go To" in the View menu
• Renamed "Hide Columns..." to "Show Columns..."
• Made tweaks to the keyboard navigation in connection windows between controls using the Tab key.

Fixes:

• Table copies have per-row progress (when different servers). Status text fixed. Misc related status display.
• Dock progress bar shows progress for unfinished transfers only
• Notification for copy finishing no longer shows (null)
• Removed small delay when typing in table cells.
• Initial database selection in connection settings is no longer case-sensitive.
• Fixes a crash that could occur when connecting by SSH and the password authentication dialog was shown.
• Fixes a crash when editing a value of Query view result row, and then running a new query before pressing Return to commit the text change.
• Fixes a crash in the Server access via SSH.

New:

• Duplicate Table - You can now right-click on a table and select "Duplicate" to copy the structure and data to create a new table in the same or a different database.
• Added more fine-grained preferences over when certain types are edited in the results list or in a separate new sheet window. See the "Results" preferences panel.
• Preferences in the Results panel for editing values in a separate new sheet window apply to the Query view's row results list as well
• When truncating a table, the Table Content view will reflect the deleted rows.
• When adding, renaming, or deleting a db, table, etc in the sidebar, that change will be displayed in other tabs and windows for the same connection as well.
• Worked around a problem in OS X preventing the last column of table views from being resized because the click is intercepted to mean resizing the window by it's edge. (You can see this issue in Finder, for example.)

Changes:

• Saved queries menu items are now sized better and always wrap lines for easier viewing.
• Changed the order of the buttons in the Truncate confirmation alert so Truncate is in the primary position.

Fixes:

• When refreshing the list of databases/tables/etc, it may not have reselected the previously selected item(s) correctly in the past.
• Fixed serveral small issues in the Table Columns view.
• Corrected a trivial issue where the connection window would not always open when Querious was launched.
• The sidebar is no longer completely collapsible after having been to the Server view.

Known Issues:

• When duplicating a table, the Notification Center notification will display "(null)".

Fixes:

• Fixed a pretty common crash introduced in preview 7 (whenever an error message was shown typically).
• Fixed a few more memory leaks.

New:

• Added the ability to edit SQL text documents.
• When editing a saved connection, there's a new Test button which tests your settings to make sure they work.
• When a tab's connection is dropped, a new reconnection view is shown. This simultaneously fixes issues that could pop up after a connection was dropped due to any number o
• Syntax coloring SQL is now twice as fast and uses half as much memory.

Fixes:

• Fixed several stability issues in various places.
• Plugged a few memory leaks.

New:

• Added per-tab navigation history. See Go Forward/Go Backward in the View menu.
• Table Content View: Cmd-Delete always deletes the selected rows without confirmation
• Can set a timestamp field's value to NOW or CURRENT_TIMESTAMP for convenience.
• Added Enter Full Screen menu item.

Fixes:

• When importing CSV or Tab, if told that the file contains headers and those headers are not unique (which is bad form), Querious will make them unique and then import the file correctly.
• Fixes tabbing between controls in the Connection View to ensure it always is correct.
• Removed the Customize Toolbar menu item.

New:

• Rows in the Table Content view can now be copied as SQL.
• Rows in the Query view can now be copied as SQL, but only if the entire row belongs to the same table, and only if the primary key of that table is present in the results.

Fixes:

• Fixed a crash when importing CSV/Tab where the first line was not headers.
• Fixed a crash caused when a reconnection is made while the Server view was previously showing.
• Fixed some stability issues in the Procedure Content view.

Fixes:

• Fixes crashes on 10.7 and 10.8 when viewing the Database Structure - Relationships view.
• Added better validation which avoids a crash when editing CSV import settings.
• Fixes several memory leaks and crashes.

New:

• Added validation/error prompting for missing required fields when adding or editing a saved connection. (This will probably be tweaked again.)

Changes:

• Ensures all text substitutions (such as changing quotes to smart curly quotes) are disabled in the field-value editing sheet.

Fixes:

• Fixes a problem with overlapping controls in the connection settings panel in certain circumstances.
• Editing Table comments and switching tables would copy those comments to the newly-selected table too.
• Fixes a crash.

New:

• Imports saved queries from version 1.
• "Run" button in the Query view now has a menu and configurable behavior. The default behavior is identical to version 1.
• In the Query view you can now right-click on a query and select EXPLAIN.
• Right-clicking on a query in the Query view now has "Run Query" in the contextual menu.
• When selecting a field name from the search popup in the Table Content view, the text field is now given keyboard focus so you can immediately start typing in the search string.

Changes:

• The variables list in Server Status view has different scrolling constraints: Hoping this solves a problem with "jerky scrolling" believed to be caused by the rubber-banding effect in the horizontal direction.

Fixes:

• Enabled the crash reporter.
• Fixed the automatic update checking. (Feeling silly about this one.)
• Fixed a problem which would lead to a hang in query autocompletion.
• Fixed a problem which would lead to a crash when selecting a table in very specific circumstances.
• Search controls in Table Content and Data File docs resize with the window
• Fixed a crash when opening the Server Access tab in the connection settings panel if no MySQL host was already specified.
• The connection settings panel and view both let you correctly remove and change the selected SSH key file.
• Custom SSH key file name is shown in the SSH Password field as placeholder text as originally intended.
• The visual state of the SSH key file buttons are stronger as originally intended.

Click here for changes in Querious 2.0 versus version 1.1.4. Below are the changes since pre-release 4.

New:

• Added the new Querious 2 application icon!
• Added a contextual menu to Table Columns list. (Add, Delete, Duplicate).
• Added an "Export Results" menu item to the action menu at the bottom of the Procedure Content view.
• The Query view's result list shows when queries are still executing. Slight style changes as well.
• The Transfers window puts commas in row counts now.
• Registration works.

Changes:

• Cmd-Shift-E (File -> Export) in the Query view behaves the same as everywhere else. To export the results for a selected query, use the "Export Results" menu item in the action menu.
• SQL exporting now adds line endings between each row in batched inserts. This makes the file friendlier to text editors by not lines of text a megabyte in length.

Fixes:

• Fixed a tiny leak in SQL exporting

New:

• Added release notes section to the About window. Shown at launch if launching a new version.
• Can select and copy queries (in time order) from the server Transcript view.
• The Default Value column in the Table Structure Columns now has appropriate NULL/set/enum drawing and popups when appropriate.
• Run Query btn shows Cmd-Return when command is held down.
• Added an option in SQL exporting for batching INSERT rows.
• Added an option in SQL exporting for creating complete INSERT statements with column names.
• Added Join Columns / Split Column to Editor menu for data records documents.
• "Database" connection setting now focuses sidebar instead of expanding the database contents.
• Added new Updates preferences panel.

Changes:

• Selects SQL in the export panel by default.
• If an error occurs in Table Content when SELECTing rows it now shows the full query.
• More informative errors when creating an index without a name or columns
• Export menu item from Query view works if no results are shown.
• Data documents now show better row count numbers when filtered.
• When the sidebar is focus on a database, and no rows selected, consider the db being selected.
• Made data-destroying Delete buttons the NON-DEFAULT buttons in sheets.

Fixes:

• Changing a table's structure forces the Content view to reload the data.
• Fixed bug which wouldn't allow unchecking "Events" in schema object selector when there were no events in the selected database.
• Smarter ordering of dropping columns to avoid errors in Table Columns view.
• Stops port number fields from being formatted with commas.
• Fixes a missing indicator image for columns being deleted in the Table Columns view.
• Fixes a bug where deleting a duplicate of saved connection settings would delete the original as well.
• Misc fixes for stability and performance.