github HeidiSQL/HeidiSQL 9.2

latest releases: 12.0, 11.3, 11.2...
4 years ago

This is a new release with some new features and many bugfixes and enhancements.

  • New features:

    • Add support for JSON grid export
    • Add support for Markdown Here grid export
    • Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip, ...).
    • Add support for connecting to Microsoft Azure Servers
    • Add edit box + updown buttons for limiting the size of exported INSERT queries in bytes.
    • Display creation time, last alter time, comment and start time of scheduled events.
    • Online help document available. Various "Help" buttons in relevant dialogs link to this document.
  • Bugfixes

    • Dropping functions and procedures on PostgreSQL now with required parameters list
    • Size bars in "Database" tab on PostgreSQL now with correct values
    • Loading full grid data on PostgreSQL did not work on text columns
    • Fix microseconds in MSSQL date/time data types, hidden in data and query grids.
    • Use ISO 8601 date/time format on MSSQL
    • PostgreSQL: Fix wrong order of columns shown in indexes, and show normal indexes also
    • Do not uppercase ENUM values in procedure parameter datatypes
    • Fix crash when right-clicking a database, following by a click on "Drop"
    • Version conditional disabling for "Create new" menu items in MySQL mode only
    • TEXT data type has a maximum length of 65k for MySQL only. Introduce other values for MSSQL and PostgreSQL.
    • Fix memory leak in TfrmTableTools.SaveSettings
    • Let longer data type matches win over shorter ones, especially important on PostgreSQL
    • Make TPGConnection.FetchDbObjects compatible to pre-9.0 servers on PostgreSQL
    • Fix non working addition of new columns in MySQL
    • Detect xid type (oid 28) as integer.
    • Detect character type (oid 1042) as char, not varchar.
    • Detect aclitem[] type (oid 1034) as unknown, not text.
    • Fix detection of PostgreSQL data type INTERVAL as VARCHAR.
  • Enhancements:

    • Automatic storing of settings in portable mode
    • Optimize query for getting total row count on PostgreSQL
    • Add support for microsecond precision of MSSQL date/time types in table editor, show these in "Length/Set" column
    • Add a help button to the quite non-intuitive controls on the export dialog
    • Add support for JSON data type on PostgreSQL
    • Add support for HIERARCHYID data type on MSSQL
    • Increase various default values for window dimensions, for reasonable look and feel for new users
    • Add "Rename" context menu item in session tree.
    • Use local number formatting in grids by default
    • Use transparent background for NULL cells by default
    • Support columns with a string literal as default value plus an ON UPDATE CURRENT_TIMESTAMP clause.
    • Increase compatibility when getting procedure body on MSSQL.
    • Remove duplicates from recent file list pulldown.
    • Translate connected/disconnected words in status bar
    • Set focus on filter box when SQL help dialog opens.
    • Update gettext unit
    • Make search/replace dialog resizable
    • Activate "Clear filter" button after applying text to filter memo.
    • Gracefully remove superfluous WHERE keyword from data grid filter, so other places like the previously modified "More filters" menu do not add a second WHERE.
    • Use existing data grid WHERE filter to filter values from quick filter > "More values".
    • Remove outdated details in readme file, and redirect to official help page instead.
    • Detect all array style types on PostgreSQL as unknown type, e.g. TEXT[].
    • Pass column or argument name to NativeToNamedColumnType(), as a hint for the user.
    • Support quoted datatypes in TDBConnection.GetDatatypeByName, coming from TDBConnection.ParseTableStructure

Don't miss a new HeidiSQL release

NewReleases is sending notifications on new releases.