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