Softpedia >Mac >Internet Utilities >Querious >  Changelog

Querious Changelog

What's new in Querious 2.0 Build 1055 Beta 48

Nov 1, 2016
  • 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.

New in Querious 2.0 Build 1053 Beta 47 (Oct 24, 2016)

  • 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 in Querious 2.0 Build 1051 Beta 46 (Sep 19, 2016)

  • 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 in Querious 2.0 Build 1048 Beta 45 (Sep 19, 2016)

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

New in Querious 2.0 Build 1042 Beta 44 (Apr 17, 2016)

  • 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 in Querious 2.0 Build 1040 Beta 43 (Apr 12, 2016)

  • 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 in Querious 2.0 Build 1027 Beta 41 (Mar 24, 2016)

  • 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 in Querious 2.0 Build 1024 Beta 40 (Mar 2, 2016)

  • 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 in Querious 2.0 Build 1023 Beta (Feb 12, 2016)

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

New in Querious 2.0 Beta 37 Build 1016 (Jan 3, 2016)

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

New in Querious 2.0 Beta 36 Build 1014 (Dec 16, 2015)

  • 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 in Querious 2.0 Beta 35 Build 1010 (Dec 11, 2015)

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

New in Querious 2.0 Beta 34 Build 1002 (Oct 24, 2015)

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

New in Querious 2.0 Beta 33 Build 1000 (Oct 16, 2015)

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

New in Querious 2.0 Beta 32 Build 999 (Sep 27, 2015)

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

New in Querious 2.0 Beta 31 Build 998 (Sep 10, 2015)

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

New in Querious 2.0 Beta 30 Build 996 (Aug 18, 2015)

  • 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 in Querious 2.0 Beta 29 Build 993 (Aug 14, 2015)

  • 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 in Querious 2.0 Beta 28 Build 991 (Aug 6, 2015)

  • 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 in Querious 2.0 Beta 26 Build 985 (Jul 1, 2015)

  • 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 in Querious 2.0 Beta 25 Build 980 (May 21, 2015)

  • 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 in Querious 2.0 Beta 24 Build 978 (May 19, 2015)

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

New in Querious 2.0 Beta 23 Build 977 (May 18, 2015)

  • 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 "interent" 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 in Querious 2.0 Beta 22 Build 971 (Apr 21, 2015)

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

New in Querious 2.0 Beta 21 Build 962 (Mar 25, 2015)

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

New in Querious 2.0 Beta 5 Build 923 (Aug 6, 2014)

  • 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 in Querious 2.0 Beta 4 Build 922 (Aug 6, 2014)

  • 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 in Querious 2.0 Beta 3 Build 921 (Aug 6, 2014)

  • 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 in Querious 2.0 Beta 2 Build 920 (Jul 18, 2014)

  • 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 in Querious 1.1.1 Build 518 (Sep 19, 2011)

  • Fixed problems related to SSL, saved queries, and CSV importing.

New in Querious 1.1 Build 516 (Sep 19, 2011)

  • New:
  • Major architectural improvements for handling connections. Improved performance and stability.
  • New tabs drag reorder, move from window to window, etc.
  • Can connect to multiple servers in the same window
  • You no longer need to specify the local tunnel port for SSH connection.
  • SQL exports and imports are about 50% faster and use less memory
  • CSV/Tab importing is about 40% faster.
  • SQL exports now write multiple row insertions per insert statement
  • Added preference to not load large blob types immediately in the Content view.
  • Added Edit Duplicate Delete to the contextual menu for saved connections
  • Added a Save As Favorite button to the connection view
  • Connections can have custom icons
  • Changes:
  • Improved performance of import/open panels; Also added a checkbox enabling/disabling all file types.
  • Changed the window titles so that if the connection uses SSH, it specifies the SSH host if there is no nickname. (Avoids lots of root@localhost titles for actually different machines.)
  • When viewing table content, if you switch between tables, the "Start At" field resets to 0.
  • When adding a new row to the content view, it's added below the selected row, not at the bottom.
  • Updated syntax keywords list.
  • Fixes:
  • When connection dropped, it just goes back to the connection screen, doesn't close the window
  • SSH tunnel drops are handled more gracefully.
  • Fixed the connection error message which says it failed to connect on a port, when connecting by socket
  • Querious now passes along SSH prompts if needed, such as yes/no for verifying an unknown host.
  • With a row selected in the Content View (or any table view of rows) it no longer infinite loops when pressing Escape
  • Changing the default value for BIT column types in the Columns view works correctly
  • Can now use CURRENT_DATE in the default value of a column (along with CURRENT_TIMESTAMP as before)
  • Can delete multiple columns at a time in records documents.
  • Fixed a bug when importing very very large CSV files.
  • Fixed some bugs where the open panels weren't resolving aliases
  • Fixed visual problems on Lion

New in Querious 1.0.1 Build 398 (Mar 9, 2010)

  • Querious now handles SSH tunnel port collisions better.
  • Multiple fixes in the Users view
  • Fixed a crash in the Tab importer

New in Querious 1.0 Beta 12 Build 383 (Nov 19, 2009)

  • Fixes:
  • Added a preview to CSV and Tab importing
  • Optimized field value drawing a bit.
  • Changes:
  • CSV import no longer has a line endings setting. It figures it out itself. This avoids a crash due to using the wrong line ending.
  • Fixes:
  • "Databases and Tables" list is resizable again.
  • If an error occurrs when loading a user's privileges, it's now shown in an error mesage
  • Foreign Keys no longer include UNIQUE column indexes
  • Fixed an exception when bringing up the export SQL panel
  • Fixed an obscure UI bug which would cause it to look like the privileges from one user/host was copied to other user/hosts with the same host name.
  • Fixed error message when creating table to show the correct name.
  • CSV import no longer allows importing with missing settings
  • Fixed an issue in tab and CSV importing which would fail to import if column headers were not turned on.
  • Fixed some minor visual glitches when the import panel first opens.
  • Import/export window now has a minimum size set
  • Avoiding some potential problems which would manifest during import/export.
  • Fixed a crash that sometimes occurred when deleting a database.
  • Fixed a bug where clicking on the popup for a column type sometimes would crash.
  • Fixed a bug where an exception would be thrown when editing binary data in field values
  • Indexes & Keys view commits acknowledges in-flight changes before switching out to another view
  • Fixed an exception caused by editing a value in a newly added row in Content and Indexes, using a keyboard shortcut to switch to another view, and clicking Don't Save for committing the row.
  • Fixed several potential bugs with records documents.
  • Select Previous/Next tab is no longer enabled when tabs aren't even visible (when waiting to make a connection)
  • When creating value lists for fields, you no longer must press return before clicking + to add the next one
  • Worked around a bug where empty value list values were allowed to pass through
  • When you rename a connection, it now selects the new row correctly

New in Querious 1.0 Beta 11 Build 373 (Sep 8, 2009)

  • Fixed a bug causing underscores to insert the first completion in the autocomplete list.
  • Added back ticks in the Table operations SQL statements
  • Fix "number of rows affected" count
  • Works around a Mac OS X bug which prevents table value cells from drawing text into neighboring columns.
  • Updated for 10.6 to remove some deprecation warnings.
  • Fix for CSV not testing the last bye in the file.
  • Fixed a bug with tab importing where if headers are turned off, then it'd throw an exception and crash.
  • Jumping to a foreign row (by clicking on a foreign key arrow button for example) reports an error if it can't find a referenced column instead of throwing an exception.
  • When jumping to a foreign row, if Querious somehow fails to get the value from the current row, it reports an error.
  • Fixed a bug which would cause a crash when dragging the any two or more rows including the last row in the Columns view and dropping them below the last row.
  • Triggering autocomplete for a string with a square bracket such as 'ex[' no longer causes a crash.
  • The find string field always re-enables when it needs to if the selected find settings require it to be.

New in Querious 1.0 Beta 10 Build 370 (Sep 1, 2009)

  • New:
  • Table values draw NULL values as a little outlined NULL "pill".
  • Added a small note about the performance of expanding the row height for multiline values.
  • When importing finishes, Querious will bounce the icon once in the Dock to let the user know
  • Records documents show what format the file will save as in the window title
  • Changing the format of a records document is undoable and marks the document as changed
  • The application icon in the dock now shows a "Complete" badge on it when all imports/exports are done.
  • Changes:
  • Significantly improved the performance of the variable row heights in results tables. From minutes to seconds in large cases. Also significantly reduced memory usage requirements.
  • Saved Queries should now be saved immediately instead of when Querious quits.
  • Fixes:
  • The title of tabs shows the nickname appropriately. It would show the server address instead if Use Compression was checked.
  • Side effect of the newly added support for stored procedures are fixed. (MySQL error messages properly show again, deleted rows properly disappear from the Content view etc.)
  • Fixed duplication of recent queries in the query history.
  • Fixed problemse with deleting queries in the query history.
  • Fixed a number of small memory leaks
  • Fixed CSV importing into tables
  • When saving a records document, it no longer hogs memory.
  • When saving a records document, it's no longer monumentally slow.

New in Querious 1.0 Beta 9 Build 368 (Aug 27, 2009)

  • New:
  • Added new "go to foreign key" button.
  • Added a preference for expanding the row height when there are multi-line field values. The maximum height is 5 lines.
  • Columns view "NULL" column combo boxes autocomplete if you type just 'N' or 'Y'
  • Split General preferences into General and Results
  • The Indexes view's Indexes table now supports autocompleteing column names like a combo box in the Name and Columns columns
  • Added COMMENT and AFTER to the keywords list
  • Changes:
  • Querious contains a workaround for MySQL bug #45862 which requires a FLUSH TABLES to be executed for the information_schema database to be updated properly, which Querious uses.
  • When there is a selection in the Columns view, clicking Add column adds a new column below the selected column instead of above.
  • Changed the default number of remembered queries to 25 from 10
  • When exporting data, if you don't specify an extension (csv, sql, etc), a default one is added
  • In a records document, if you click on a row, it'll clear the find highlighting now
  • Fixes:
  • The last column of results lists are no longer sometimes way too narrow.
  • Made a tweak to the Columns view which prevents reloading results data twice.
  • When exporting, the files exported are properly closed by Querious
  • Fixed CSV bug prevented a row from being imported properly if it the very last row ended with an encloser
  • Fixed another CSV bug which prevented relaxed mode from working properly with enclosers
  • Fixed a bug preventing memory clobbering if someone tries to import either a malformed file or the wrong file type completely.
  • If you open a records document with a headers row, but no content, it properly displays the column headers in the window that is opened.
  • Fixed a crash caused by leaving the "Enclosed by" or "Escaped with" fields empty when exporting CSV
  • In the Columns view, when switching a numeric column to NOT NULL, or switch a column to a numeric type, there should now always properly be a default value.

New in Querious 1.0 Beta 8.3 Build 365 (Aug 21, 2009)

  • Fixes:
  • Fixed a big slow down caused by the display of foreign keys in 1.0 b8.2
  • When exporting/copying CSV, it no longer sometimes crashes after it's done.

New in Querious 1.0 Beta 8.2 Build 364 (Aug 17, 2009)

  • New:
  • Foreign keys are (temporarily) shown in blue.
  • Right-click on an fk to jump to the foreign row.
  • Changes:
  • Tab importing is 4-5x faster.
  • Now uses the primary key in the WHERE clause of UPDATE, SELECT, and DELETE statements as needed, all over. Before, Querious would always use the entire row contents which was just unnecessary and could cause problems with certain column types.
  • Forced to remove password assistant from User password change sheet.
  • Fixes:
  • Fixed a bug which affected CSV and Tab importing, causing an exception.
  • Fixed an exception when an error gets thrown in AQRecordsDocument.
  • Tab importing in records documents doesn't show the values as binary data.
  • Column widths are no longer all squished. (Side effect of the improved resul-grabbing speed in beta 8).
  • New rows added to tables don't create an error when being saved.

New in Querious 1.0 Beta 6 Build 323 (Apr 28, 2009)

  • New:
  • SSL connections.
  • Window titlebar shows a lock icon when using a secured connection (SSH or SSL).
  • Improved error detection on file importing.
  • MySQL timeout values are now specifiable in preferences.
  • The window title now always shows the user name.
  • Changes:
  • Vastly reduced memory usage when exporting and importing to/from CSV, Tab, and SQL. This has cured all memory-related crashes during these processes.
  • Exporting is much much faster.
  • Better handling of mysql passwords for saved connections that use SSH. Existing passwords will be lost in Keychain, sorry.
  • When you click on the Query view, the focus is put on the query text view immediately so you don't need to click on it.
  • The query text view should work better with using Tab as the autocomplete trigger key. If it is set, then it'll use it to trigger autcomplete only if there are possible completions. If not, it will insert a tab.
  • Queries for requesting db, table, and column names in the Query view now happen serially to each other rather than in parallel which reduces load on the database server.
  • Fixes:
  • Fixed several memory leaks.
  • Fixed a crash where editing the username in the table without commiting it, and then clicking on the change password button would cause it to crash.
  • When opening a tab file records document, it wouldn't set the line ending properly which would cause a problem on save.
  • Likely avoided a crash with the autocompletions in the query text view. Not confirmed.
  • Now handles modifying binary data fields from the content table view properly.
  • If an UPDATE doesn't actually change a row (because it just sets a value to the same value), it no longer sees it as an error.
  • Renaming a column in the documents window is properly undoable.
  • Backticking appropriately when renaming a table and adding privileges for db, table, or column.
  • Changing the query syntax text font works again.
  • Added work around for Cocoa bug which affected the Add Item menu item in the Connection menu.
  • Multiple item delete now properly says "database" or "tables" or "databases and tables" appropriately.

New in Querious 1.0 Beta 4 Build 285 (Mar 10, 2009)

  • SSH. Supports keys and passwords.
  • Added some support for Views. They now have a separate icon from tables, and can be viewed, but not created or modified in anyway other than deleting them. Nothing further will be added until 1.1.
  • The databases list selects the row for a newly created database.
  • The "values" popup window in column editing now uses Cmd
  • +, Delete, and Return to map to the Add, Remove, and Done buttons.
  • The foreign key columns popup window also uses Return for the Done button
  • Remembers the width of the database/tables list in the window
  • When you select from one of the popups in the Find view in Content, it selects the text field for easier typing. CHANGES
  • Changed recent query names from a timestamp to the first 25 chars of the query itself. FIXES
  • Fixed a bug which would cause unexpected behavior, and usually a massive amount of "NSOutlineView Warning: reloadData called while in the middle of doing a reloadData!" warnings to be logged to the console.
  • Fixed SQL export quoting bug.
  • When doing an SQL import, it now properly executes USE database; before starting
  • Case insensitive sorting of databases, tables by name
  • Fixed a bug when changing the "extra" value of a field which would cause all kinds of craziness in the Columns view.
  • Fixed problems with settings the comments for a field in the Columns view.
  • Now supports GIS extension column types as binary data instead of always showing NULLs.

New in Querious 1.0 Beta 3 Build 279 (Mar 3, 2009)

  • New:
  • Added keyboard shortcut for switching tabs.
  • The query text view supports Fn+Return on laptops and Cmd-Return to run the query. Enter still works as before.
  • Add User/Host button now has a popup.
  • The user privileges view now has a grant all / ungrant all button at the bottom of the window.
  • Changes:
  • Connecting to "localhost" will not use a socket if no socket value is entered.
  • SQL export now does DROP TABLE IF EXISTS instead of just DROP TABLE
  • The default limit for Content view results is now 1000 rows instead of unlimited
  • Fixes:
  • Fixed a bug which prevented the user from choosing enum or set as a column type
  • Fixed a bug preventing setting a timestamp default value to CURRENT_TIMESTAMP
  • Fixed a problem with SQL export's encoding
  • When closing the preferences window, it now ends editings so that fields with focus actually commit their values.
  • Fixed backticking problems in: foreign keys, importing, indexes, and Content view sorting.

New in Querious 1.0 Beta 2 Build 275 (Feb 18, 2009)

  • Querious can now open CSV/Tab files as spreadsheet-like documents where you can add and remove columns and rows, edit, sort, and search.
  • Query view results can now be exported to a file using the File->Export command.
  • Query view now allows you to sort row results.
  • Query view now shows the number of results returned for SELECT/SHOW/etc queries
  • Double-clicking on a saved query collection will now expand it.
  • In the Content view you can now search for by 'empty' or 'not empty'
  • Content view has a Find All menu item in the popup
  • You can now reorder columns in the Columns view.
  • In the Table Info view, Table comments field supports undo.
  • There's now a Run SQL Script menu item.
  • Changes:
  • Clicking on the dock tile will make a new window when there are none.
  • The content view now sorts all data by the SQL query
  • Fixes:
  • Added a "keep alive" technique for connections to prevent ridiculous timeouts.
  • Table cells can now scroll text again.
  • Fixed a bug when holding the Option key to edit a field value in a sheet.
  • All table, column, and index/key/etc references are backticked in SQL so that using reserved keywords for column names is acceptable
  • Content view shows the correct number of results when doing a Find
  • In the Table Info view, typing table comments doesn't cause a save and reload on each character typed.
  • Query view now uses longer "fitted" column names so that each column has a unique identifier.
  • When setting values in a new row-to-be-added in the Content view it no longer writes NULL values as a string instead off SQL nulls.