7.3.0

Dec 7 2020
Changes since 7.2:
  • General improvements:
    • Preference pages structure was reorganized (in the standalone and plugin versions)
    • Sample database now can be created from the main menu
    • Several UI freeze issues were fixed (deadlocks)
    • Transaction deadlocks viewer was fixed
    • Boolean value editor UI was changed (text instead of icons)
    • User authentication UI was fixed when “Save password” option is off
    • Project delete now requires confirmation of project files delete
    • Script can be fully deleted in case table is delete from ERD
  • A lot of improvements for MacOS:
    • Problem with toggle checkboxes was fixed
    • Problems with inline value editors were fixed
    • Problem with connection editor open on single click was fixed
    • Problem with metadata viewer in BigSur was fixed
  • Database navigator:
    • Filters now support masks escape (_ and % characters)
    • Connection state icons were replaced and adapted to dark themes
    • View only connected data sources filter was added
    • Quick search in connections/schemas options were added
    • Multiple objects delete confirmation dialog was redesigned
    • Tooltips visibility configuration was added in preferences
    • SQL editor context menu was enhanced
    • “Link with editor” command was fixed for SQL scripts
    • Problem with empty/redundant tooltips was fixed
  • Data viewer:
    • Grouping panel now supports column reordering
    • Column modifier icons (key, read-only) were updated
    • Column reordering UI was fixed
    • JSON/XML viewer performance was significantly improved
    • Minimum fetch size now limited by 100 rows
    • Bug with results fetch size disable was fixed
    • Contrast color now used as foreground color
    • ROWID columns support was fixed
    • Binary values copy-paste support was added
    • Column auto-completion in the filter panel was fixed
  • Data transfer:
    • Native client selector was fixed
    • Extra file name pattern variables were added
    • Native date/timestamp format support was added to the SQL INSERTS export
    • Extra formatting options were added to the SQL INSERTS format
    • Export in SQL INSERT format: support of various INSERT/REPLACE/UPSERT dialects was added
    • SQL INSERT query generator now skips auto-generated columns
    • Data preview was fixed for custom SQL queries
    • Binary format mapping was fixed (BLOB->binary)
    • Target table name mapping was improved
    • Context data context menu item visibility was fixed
    • SQL format: extra options were added (including INSERT OR REPLACE support)
    • REPLACE/UPSERT support was added in SQL export format
    • HTML format: additional export options were added
    • DbUnit format support was improved
    • Target format selector was fixed (Linux)
    • Bug in dump/restore credentials save was fixed
    • Automatic columns mapping added for CSV without header column
    • Export from SQL query with custom variables: UIX was improved
    • Problem with active schema switch during task execute was fixed
    • Export from query: task UI configuration was fixed (active schema select)
    • Incorrect preview in case of import from table to table was fixed
    • Now export from database to database is possible
    • Problem with incorrect auto-assigned name for exported resultset was fixed
    • Now export selected row only to excel is possible
    • DND works if a composite task is created inside a composite task
  • Import from CSV/XLSX:
    • Wrong rows can be skipped (with disabled “Batch import” option)
    • Import parameters documentation was updated
    • Date columns support was added
    • Timezone parameter was added for date/time columns
  • SSH:
    • Support for OpenSSH key format was added
    • Problem with double password prompt was fixed
    • Bug with variables in connection parameters was fixed
    • Private key format conversion was improved (Linux)
  • Command line:
    • Connection credentials now can be passed along with connection name/id
    • Running task from command line can be done in headlesss (console) mode
    • Support custom variables in CLI was added
  • Windows installer:
    • Shortcuts for “All Users” were fixed
  • ER diagrams:
    • Table comments loader was fixed
    • Able copy-paste was fixed
  • Scheduler:
    • Hourly spinner in scheduling dialog was fixed
    • Cron scheduler support was added on Linux/MacOS
    • Possibility to enter invalid data was removed
    • Month names in Linux scheduler were corrected
    • Now deleted tasks do not remain scheduled
  • AWS:
    • Support of SQL Server, Oracle, MariaDB in AWS RDS was added
    • Connect to Redshift after switching from IAM to DB native was fixed
  • SQL Editor:
    • Query Builder enhancements were added
    • Editor tab title now can include active database/schema name
    • Toolbar buttons enablement was fixed
    • “Auto-save on edit” option was added
    • Procedures auto-completion was improved (use signature or parameter names depending on context)
    • Query cancel on editor close was fixed
    • Disable auto-formatting inside comments
    • Active query cancel on editor close
    • Folding support was improved and enabled by default
    • Current/selected word highlighting support was improved
    • SQL formatting was fixed for DDL queries (like CREATE TABLE)
    • “Find in Google” command was added
    • SQL-related preference pages were redesigned
    • Parser of complex SQL blocks (e. g. PL/SQL) was significantly improved
    • Problem with missing query results for some DDL queries was fixed
    • Complex SQL queries parser was improved
    • Query folding now respects active SQL dialect
    • Problem with focus loss after query execute was fixed
  • PostgreSQL:
    • Latest PostGIS driver mapping was added
    • Geometry data types export was improved (proper SQL format + SRID)
    • Hidden databases can be loaded in the database navigator
    • Interval data type DDL was improved
    • Table storage parameters were added to DDL
    • “Connect as role” option was added in the connection settings
    • Materialized view comment edit was fixed
    • Trigger comment editor was added
    • Serial data types support was improved
    • Trigger DDL was fixed
    • $$ rule parser was fixed
    • Data type handler detection was fixed (uuid, name and other types)
    • Array editor was fixed (proper array item type discover).
    • Arrays edit support was fixed
    • Inet and other custom data types edit was fixed
    • “Generate SQL” action for varchar arrays was fixed
    • Create/alter trigger functions were fixed
    • Partition create/drop/alter actions were added
    • Table DDL was fixed (serial columns)
    • Role members/permissions viewer was fixed
    • Permission editor now supports sequences and materialized views
    • Bug with partition list read was fixed
  • MySQL:
    • Driver “MySQL 8” is now the default driver. “MySQL 5” driver can be used for older server versions.
    • User credentials of mysqldump overwrite local configuration now
    • Zerofill flag support was added
    • NULL values of “text” type rendering was fixed
    • Dump/restore credentials override option was added
    • “Disable foreign key checks” option was added in database restore wizard
    • Privileges editor UI was fixed
  • Oracle:
    • Tables/views load performance was improved on some systems
    • Extra NLS parameters were added on the connection settings page
    • Expired password change feature was fixed
    • Connectivity problem (“ONS configuration failed”) was fixed
    • Oracle 8 support was fixed (metadata read queries)
    • Ref cursors support was added
    • Multi-row INSERT support was added (for export in SQL format)
    • View and materialized view DDL was fixed (comments)
    • Extra metadata read performance options were added
    • Foreign key metadata read was fixed (ON DELETE rules)
    • View DDL was fixed (column comments)
    • PL/SQL parser was significantly improved
    • View DDL read was fixed
    • Session manager now supports Oracle 9 and 8
  • SQL Server:
    • Extra T-SQL dialect keywords were added
    • SSL support was added
    • Database create/drop/rename features were added
    • Data read from clustered tables was fixed
    • National charsets support was added for table/column comments
    • Index create UI was improved (index type selector)
  • Netezza:
    • Columns and table comments now available in DDL tab and Generate SQL
    • DDL with “Show comments” button.
    • Now comments can be added to views via UI.
    • Sequence DDL tab added
    • Ability to rename and delete sequence via UI added
    • Synonyms DDL tab added
    • Ability to rename tables via UI added
    • More functions to Netezza were added
  • Hive:
    • LIMIT clause support was added
    • Indexes metadata read was added
    • Index create/drop functions were added
    • Column add/delete support was added
    • Table rename support was added
    • SQL dialect was improved (extra keywords)
  • MongoDB:
    • Text view can be open
    • Remove old data function was fixed
    • Filter history appears in MongoDB
    • DELETE queries support was added
    • Support aggregation with SQL queries (GROUP BY) was added
    • MongoDB 2.x support was added
  • Informix:
    • Driver was updated to the latest version
    • Schemas/tables metadata extraction was fixed
    • Error in database switch in transactional mode was fixed
    • Check constraints read was added
  • SQLite:
    • Column autoincrement option support was added
    • Column drop feature was added
    • Table column delete feature was added
  • DynamoDB:
    • Partitions
    • Connection to DynamoDB using profiles was fixed
    • Scripts generated by Generate SQL were fixed
  • Firebird:
    • Data types information read was fixed
    • Problem with missing views was fixed. View source editor was fixed
  • BigQuery:
    • Problem with missing resultsets was fixed
    • Driver version was upgraded
  • DocumentDB: DocumentDB support was added
  • CockroarchDB: Role manager was fixed
  • DB2: Runstats utility support was fixed (wrong syntax)
  • Snowflake: Active schema set command was fixed
  • Derby: Unique indexes metadata read was implemented
  • HANA: Triggers metadata reading was fixed (bug with wrong schema)
  • Teradata: Active schema selector was added
  • Exasol: Table index create UI was fixed
  • CUBRID: driver configuration was fixed
  • Intersystems IRIS: driver was added