HeidiSQL 12.9 with editor hints, invisible column support and functional indexes

10397 posts
ansgar's profile image ansgar posted 3 days ago in Anouncements Permalink

Get it from the download page

32 bit builds are now dropped from the installer. They are still built and downloadable, but only in the portable versions. More details in issue #2071.

3rd party updates:

New stuff:

  • Show editor hints for string literals, revealing their character length
  • Show editor hints for routine tokens, with routine parameters, comment and body
  • Show table columns with datatype in table token hint (screenshot)
  • Issue #872: add support for creating and altering INVISIBLE columns in table editor with MariaDB 10.3.3 and MySQL 8.0.23 (screenshot)
  • Issue #2066: support MSOLEDBSQL ADO providers with version postfix for MS SQL (screenshot)
  • Issue #1975: add preference option to skip dialog for selecting the SQL reformatter (screenshot)
  • Issue #1777: basic support for function key parts in MySQL 8.0+ (screenshot)
  • Show editor hints for SQL functions, data types, tables and procedures when mouse hovers a token
  • Show function description text in hint panel when using the completion proposal
  • Issue #2046: support 4 different SSL verification levels on PostgreSQL
  • Issue #2035: support new REPLICA MONITOR admin privilege on MariaDB 10.5.9+
  • Issue #2009: basic implementation of a data generation tool, in table tools dialog (screenshot)
  • Issue #2004: load and display SQLite triggers in database tree and tab
  • Issue #619: support spatial columns with an SRID in table editor, on MySQL 8.0+ (screenshot)
  • CSV import: add checkbox option for keeping dialog open after successful import, so the user may process multiple files with less clicks (screenshot)

Bugfixes and enhancements:

  • Fix incompatible parameters for OnDragDrop event on some VirtualTree's
  • Code readability: use named constants for column indexes on table editor
  • Issue #1777: indicate functional key part in table editor with a different icon
  • Issue #2071:
    • drop 32bit mode from installer
    • update copyright year in license file
    • Issue #1296: remove VC redistributable package (will be replaced by a note on the download page)
  • Issue #2071: provide 3 new languages by InnoSetup installer
  • Fix non-painted pasted columns in table editor
  • Issue #2063 and #2002: repaint database tree after filtering
  • Issue #2035: rename REPLICA MONITOR privilege to SLAVE MONITOR, which seems to be the preferred name in MariaDB
  • Issue #2003: set no column for auto-sizing, in foreign key list
  • Issue #2038: fix empty preview panel on first click in image blob
  • Issue #2050: Add new line at end to support comments at the end of a view definition
  • Issue #2058: create a more complete functions-postgresql.ini from the documentation on postgresql.org
  • Put key icons besides column names in completion proposal
  • Issue #2051: fix unused column default value when creating a new grid row, if that default value is a simple integer expression
  • Issue #2024: fix slow grid export
  • TMySQLConnection.SetOption: find defined name of option constant per RTTI and show it in error message (when setting failed)
  • Issue #1426 and issue #1768: minor: do not try to set MARIADB_OPT_TLS_VERSION option with libmysql
  • Issue #1426 and issue #1768:
    • fix value of MYSQL_OPT_SSL_VERIFY_SERVER_CERT constant, hopefully fixing SEC_E_ALGORITHM_MISMATCH with libmariadb
    • disable MYSQL_OPT_SSL_VERIFY_SERVER_CERT if SSL checkbox is not checked, required since libmariadb C Connector 3.4.0
    • show colored warnings in log panel for each failing mysql_options() call
  • Issue #2041: categorize PostgreSQL's MONEY type from floats into text types, to fix exports and editing localized values including a currency symbol
  • Issue #1253: minor code simplification and inline documentation
  • Issue #2040: fix new crash through accessing non existent ActiveGrid
  • Issue #1253: fix queries for dropping primary or unique key in PG tables
  • Issue #2040: when closing a query tab, cancel cell editor if active, preventing crash
  • Table editor: fix crash happening through clear indexes button
  • Issue #1981: increase contrast for colored text in privilege tree with dark styles
  • Attempt to fix DLL hijacking issue with DWrite.dll per manifest
  • Issue #2036: disable clickable anchors in message dialogs when current style is dark, to work around unreadable text
  • Issue #1992: Escape ampersand in caption of menus and tabs, preventing underlined hotkey generation for names of session, database and tables
  • Issue #2031: Cast MySQL's JSON type columns to literals in WHERE clause of grid UPDATEs and DELETEs. Similar to PostgreSQL's colName::text / issue #769
  • Issue #922: remove milliseconds from exported date/time values in Excel mode
  • Issue #278: prevent connection activity through hovering status bar while a query is running
  • Issue #1965: remove unused variable
  • Issue #321: leave away name of indexes when creating a table on PostgreSQL
  • Issue #2000: disable multiline feature in grids, even when setting "Lines of text in grid rows" is larger than 1. Aims to fix laggy performance in grid with large contents.
  • Enable loading first part of JSON columns in grid, enhancing scroll performance
  • Issue #2014: code refactor: move ParseSSLSettings into TUser class
  • Issue #2014: user manager: parse SSL settings from SHOW CREATE USER, but also keep parsing SHOW GRANTS for backward compatibility
  • Issue #2011: pre-select a reasonable collation if the servers default collation is not set or not yet supported by Heidi
  • Issue #1907: fix missing assignments in TDBObject.Assign, causing a default AvgRowLen of -1 which slows down the SQL export
  • Code cleanup: Make use of TDBConnection.Has(TFeatureOrRequirement) in more MySQL related code
  • Issue #2007 and issue #1965: use the previous RowsAffected value after ShowWarnings in grid update
  • Issue #2006: enhance foreign key combo editor in grid for long item text, so the items show a hint in mouse-over
  • About box: show Delphi version behind compiled date
  • Issue #1998: fix non-scaled title text font in completion proposal
  • Issue #1991: check if left part of table name up to a dot lives in the database list. If not, assume it is part of the table name.
  • CSV import: set default folder and filename in open-file-dialog to the one of the selected file
  • Issue #1984: fix undefined and wrong result of TMySQLQuery.TableName when using a table alias
  • Move mostly empty log message to debug level
  • Issue #2000: restore partly disabled support for multi lined grid rows
  • Issue #2070: clear grid selection when jumping to next search result
  • Issue #1874: fix using "UnknownTable" when copying PostgreSQL rows in data tab
  • Set hint font from underlying SQL editor, to apply a better formatting
  • Issue #2053: add debug log lines in all places where a sorting is created or restored
  • Issue #2063 and #2002: repaint database tree after filtering
  • Fix Delphi error message saying SynEdit's OnDropFiles declaration has an incompatible parameter list

Please login to leave a reply, or register at first.