RazorSQL Changelog

New in version 6.3.8

July 3rd, 2014
  • Enhancements:
  • Added PostgreSQL materialized view support
  • Added support for creating projects and interacting with projects via a tab on the file system browser
  • Enhanced materialized view options on the database browser for Oracle
  • Added an option to print line numbers when printing via the web browser option
  • Changes:
  • Expansion of materialized view node in database browser now shows view columns
  • Bug Fixes:
  • DynamoDB: All columns not always displaying in select * queries
  • PostgreSQL Database browser not differentiating among overloaded functions

New in version 6.3.5 (April 30th, 2014)

  • Enhancements:
  • Filter Query Results Tool: Added options for matching any column in a row with equals, contains, or in operations
  • Import Tool - If column names included on first line of delimited file or excel spreadsheet, try to populate column number field based on order of column names
  • Command Line Export Tool: Added multi-value insert syntax option for supported databases
  • Command Line Backup Table Tool: Added multi-value insert syntax option
  • Command Line Backup Table Tool: Added included identity column insert option
  • Command Line Backup Schema Tool: Added multi-value insert syntax option
  • Command Line Backup Schema Tool: Added included identity column insert option
  • Changes:
  • Changed process for getting PostgreSQL type information to improve performance
  • No longer display keep-alive errors for SQLite
  • Bug Fixes:
  • Database Browser: Informix tables and views not always getting sorted in the correct order
  • DyanmoDB: Generate DDL tool not generating column types when tables have both hash and range keys
  • DynamoDB inserts against tables with more than one global secondary index throwing errors
  • DynamoDB describe table not showing all global secondary indexes

New in version 6.3.4 (April 2nd, 2014)

  • Enhancements:
  • Added H2 database conversion support to and from HSQLDB, MySQL, Oracle, SQLite, MS SQL Server, PostgreSQL, and MS Access
  • Added MonetDB support
  • Changes:
  • When closing RazorSQL with unsaved files, added a cancel option to the Yes/No save dialog
  • New session window no longer required mouse to navigate
  • Changed memory settings on Mac OS X 64-bit version
  • Bug Fixes:
  • DynamoDB select count(*) queries with where clauses - where clauses getting ignored
  • Percent of original size field not showing correct values in zip file viewer

New in version 6.3.3 (February 26th, 2014)

  • Enhancements:
  • DynamoDB: Add global secondary indexes and local secondary indexes to the describe tool
  • DynamoDB: Add global secondary indexes and local secondary indexes color indicator to the database browser
  • DynamoDB: Upgraded to latest AWS libraries
  • Increased launching performance of edit table tool
  • Increased launching performance of alter table tool
  • Changes:
  • Execute Procedure Tool: For Oracle, now supports REF CURSOR as an IN OUT parameter if no value is set for the REF CURSOR as an IN param
  • Bug Fixes:
  • DynamoDB - does not support tables with dashes in the name
  • DynamoDB: tables with global secondary indexes not showing key information
  • DynamoDB: describe tool not showing information for tables with global secondary indexes
  • DynamoDB: Tables with no rows not showing columns in the database browser
  • DyanmoDB: Unpopulated index columns not showing as columns in database browser
  • Read only version does not allow to change databases

New in version 6.3.2 (February 12th, 2014)

  • Enhancements:
  • Added MariaDB support
  • Added the Oracle 12c JDBC drivers
  • Bug Fixes:
  • Dynamodb - Export with generate DDL not working for tables with periods in the name

New in version 6.3.1 (February 7th, 2014)

  • Enhancements:
  • Added close all query results option to right-click menu of query results tab
  • SQLite: Enabled foreign key support by default for new connections
  • SSH Client: Added ability to enter separate passphrase for private key file
  • SSH Tunnel Tool: Added ability to specify a pass phrase for a private key file
  • Added a MariaDB driver option to the MySQL connection type options
  • Ship with MariaDB drivers
  • Bug Fixes:
  • Database Conversion: converting boolean true or false values to SQLite not getting generated with proper syntax
  • DynamoDB: Tables with dots in the name not supported for certain operations
  • Next Tab and Previous Tab options not working correctly on Mac
  • If query results column names are rearranged, and column names and results are copied to the clipboard, the column names are not in the correct order

New in version 6.3.0 (January 17th, 2014)

  • Enhancements:
  • Added support for the Cassandra database
  • Added an Edit -> Delete Lines Containing option
  • Salesforce: Added the ability to connect to a Salesforce sandbox environment
  • Function Navigator / Function Selector: Now shows both procedures and functions in Oracle PL/SQL packages
  • Query Scheduler: Added option to set start time in seconds from current time
  • Query Scheduler: Added option to set the title of the query scheduler window
  • Query Scheduler: Added option to determine whether to overwrite or append to the output file if it already exists
  • Query Scheduler: Added option to load query text from a file
  • Query Scheduler: Added option to load query text from the SQL favorites list
  • Query Scheduler: Added file name, interval, executions, and query to status field of query scheduler window
  • Changes:
  • Continue should be the default button on the Add Connection Wizard screen
  • Added additional error notifications for the Export tool
  • If a maximum rows value is set in the preferences, that value will get set on the JDBC driver's statement object for each query
  • Bug Fixes:
  • Salesforce: Using TableName.ColumnName syntax in queries returns null values
  • Salesforce: Relationship queries using join tables via dot notation columns (example: Contact.Account.Name) returning null values for columns from the joined tables
  • Salesforce queries not always returning rows above initial salesforce request limits
  • Mac 64-bit: Various focus issues where windows / dialogs are not getting focus when appearing

New in version 6.2.6 (December 11th, 2013)

  • Bug Fixes:
  • Connection to Salesforce not working since previous release
  • SQL Server / Sybase: Calculated results in select clauses can return 0.0 instead of null

New in version 6.2.5 (December 6th, 2013)

  • Enhancements:
  • Added Retina Display support for Mac 64-bit version
  • Query Results - added row count display for query results for queries executed without using the fetch all rows option if all rows have been retrieved from the query
  • Changes:
  • Database Browser - added logic to always trim spaces from tables for databases where table are retrieved from the driver as opposed to executing system queries
  • FTP Connection Window - mouse click no longer needed to connect
  • Changed default font on Mac 64-bit versions to enable bold in default Monaco font
  • Bug Fixes:
  • Execute SQL Fetch All Rows option displays extra blank row in the query results after the last row