Release History

FlySpeed SQL Query History

February 10, 2012

+ Now connection properties can be saved independently from the rest of the
  stored properties in the program installation folder. Modification of these
  settings will result in UAC prompt in Windows Vista and 7. 
  This might be useful if you want to deny modification of connection properties
  for the users with limited rights. 
  To switch to this mode, install the application in normal (not portable) mode
  and switch to the Portable mode in the Program Settings dialog.
+ Ability to check for updates and update the application automatically is made.
+ Now the query execution time is shown in the status bar.
- The bugs with sorting for not uniquely named or unnamed columns are fixed.
- The bug with PostgreSQL SSH tunnel connection is fixed.

December 28, 2011

- Folder's previous content was deleted if existed before moving queries to it.
  Fixed now.
= Filter is applied now on pressing the Enter key in filter editor or on
  selecting value from lookup dataset.
= Selecting new "is equal" value in the Quick Filter for the column that's
  already filtered doesn't add new filter item, but replaces the existing one.
= The Ctrl-Q shortcut is made to apply quick filter from the currently selected
  cell value.
= Alt+Arrow Down key combination opens the lookup dataset window now.

December 26, 2011

+ Connection through SSH thunnel is made for PostgreSQL databases.
+ "Like" and "Not like" operators are added to the quick filter bar.
= The "Read-only" yellow panel is gone. It is replaced with the dialog.
= Incremental search is reworked. It is activated now with the "Ctrl+F" keys.
- The bug with search and replace shortcuts in SQL text editor is fixed.

December 13, 2011

- Minor bugs are fixed.

November 23, 2011

- Stored password for MS SQL Server was applied incorrectly in case of using 
  SQL Native Client connection. Fixed now.
- The bug with occasional changing of loaded queries is fixed.

November 21, 2011

+ MySQL: Ability to connect through SSH and HTTP tunnels is made. Read the 
  answer at the F.A.Q. page to learn how to connect through HTTP tunnel.
+ MS SQL Server: Now it's possible to sort and filter result data for queries 
  with unions.
= MS SQL Server connection dialog: "Use alternate connection method" checkbox 
  is replaced with the "Connection method" combobox.
= PostgreSQL client library is updated to version 9.1.0.
- Several memory leaks are eliminated, minor bug fixes are made.

November 16, 2011

+ The new option "Use alternate connection method" is added to MS SQL Server 
  connection properties dialog to switch between OLE DB connection (not checked) 
  and native SQL client connection (checked).
+ Visual Query Builder: Support of ORDER BY in queries with unions is improved.
+ Visual Query Builder: Parsing speed optimizations are made.
- Minor bug fixes are made.

October 28, 2011

- The bug with not drawing text on active tabs is fixed.
- Minor bug is fixed.

October 26, 2011

+ Parsing and working with large queries in Visual Query Builder is speeded up.
+ Connection and command timeout settings are added for Oracle, Firebird,
  InterBase and IBM DB2.
+ OS authentication option is added to InterBase and Firebird connections.
+ Transaction Isolation Level property is added to MS SQL Server connections.
+ List of built-in functions for PostgreSQL is added to the SQL parser.
= Now it's not possible to disconnect or switch connection for the query window
  when SQL query is executing.
= Skins are applied to the Database Explorer tree now.
- Minor bugfixes are made.

October 13, 2011

= MS SQL Server: "FOR XML" clause is updated to support SQL Server "Denali".
= MySQL: COALESCE, GREATEST, LEAST and INTERVAL added to the list of builtin
= PostgreSQL: Function "substring('test',1,2)" is converted to "substring('test'
  from 1 for 2)" on parsing the query.
= Firebird: INT type alias is supported.
- AV when editing the query columns list in rare cases is fixed.
- The bug on trying to sort results when query is still executing is fixed.