distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL 8.0 released

ansgar posted 1 year ago in Anouncements
343 revisions after the 7.0 release follows the new 8.0 release of HeidiSQL now.

Get it from the download page.

Here are the most noticable changes:


- Available in 23 languages now. Thanks to all translators and Transifex hereby!
- Database tree: Introduce optional folders for tables, views, routines etc.
- Introduce session folders in session manager.
- Make routine editor work on MS SQL servers.
- Support search and replace in data and query results.
- Add support for microseconds in temporal datatypes of MariaDB 5.3+ and MySQL 5.6.
- Introduce a query history, available in the right side helpers box. Can be turned off.
- Implement grid export as PHP array.
- Host > Variables: Add "Global" column, and highlight values different to their session pendant
- Add menu item for launching mysql.exe command line with current parameters.


... and more:
- Table editor: Fix handling of BIT default values, and support BIT columns in MS SQL.
- Table editor: Improve selection of ENUM and SET default values
- User manager: Support dots in database and table privileges
- Data grids: Support copying/pasting NULL values
- Fix stripped backslashes in VIEW body editor
- Apply hotkeys to dialog buttons
- Grid export: Remove zero padding to avoid octal => integer conversion in PHP
- Data grid: Propose column names from selected table in filter panel
- Database and new table filter above database tree
- Table editor: Display number of selected columns in status bar
- Database tree: Indicate previously selected tables with a non-ghosted icon in the tree, while leaving never selected ones ghosted
- Display timestamp in very right status bar panel when executing a query
- Table editor: Add missing DATE and TIME datatypes for MS SQL
- Table editor: Support old style "TYPE BTREE" in table index code
- Routine editor: Finally fix ramshackle detection of routine body
- Data grid: Make foreign values drop down optionally
- Dialogs: Introduce "KeepAskingSetting" checkbox
- Session manager: Move startup script and local time zone options together with SSL settings to a new "Advanced" tab
- SQL export: Support filename and dirname patterns in export target combobox
- Database tree: Display overlay icons for some special table engines like federated, csv, aria and performance_schema
- Implement an automatic keep-alive ping, to prevent SSH tunnels from disconnecting
- Add support for renaming tables in MS SQL
- Fix crash on exit when connected to pre-4.1 servers
- Table editor: Enhance MS SQL compatibility in table editor
- Fix and enhance handling of multiple statements and multiple results
- Grid export: Add "Include query" and "Include auto increment column" checkbox options
- Processlist: Add link label "EXPLAIN Analyzer on MariaDB.org"
- Internal: Refactor logic for reading and writing application and session settings
- Session manager: Introduce new columns "Last connect" and "Counter"
- Extend the variable editor to explicitly modify strings, numbers, booleans or enumerations
- Detect client timezone and send SET time_zone to the server, so that NOW() and friends return UTC-fixed values
- Session manager: Add server specific icons for TokuDB, InfiniDB and Infobright
- Session handling: Use home brown file format for exporting and importing registry settings, as used for the portable version
- Implement usage of mysql_warning_count(). Ask for running SHOW WARNINGS in a new query tab.
- Fix command line for Wine users
- Introduce new preference option "Prefill empty date/time fields".
- Restore previous selection after refreshing process list (and neighbor tabs)
Curanai posted 1 year ago
I guess, I am not the only one working at this weekend ...wink

Dear Ansgar,

congratulations - v8 with some interesting features. But sometimes two words represent the required most of all: thank you!

Keep up the very good work - I LOVE your "Heidi". :D

Bye.
17795 posted 1 year ago
Good news guys ! Heidi is a very good client, you did a so great job ! Congrats and good luck !
Ti9eR posted 1 year ago
thank you!
Rvanlaak posted 1 year ago
Great to hear! Thanks for all efforts...
studyzy posted 1 year ago
Good new version. Fixed the bugs, hope it better!
ImRicoh posted 1 year ago
Why not add object groups. For example.

Tables
Views
Querys
Procedures
Functions
and more
ansgar posted 1 year ago
This is in the new 8.0 release. You just need to right click the tree > "Tree style options" > "Group by type".
epielettronica posted 1 year ago
WARNINNG!!!!!
In this version I can't see all the field using special char such as [ and ]
ex: Vout_[V]
Mysql permit the use of special char using '' to indicate the field...
Best regards
stepler654 posted 1 year ago
Thanks a lot!
Query history that's what I really missed!
kalvaro posted 1 year ago
I can confirm there're several issues if you have a column called "Vout_[V]":

The column doesn't appear:
- In the table editor
- In the "Data" tab
- In the right pane

Switching to the "CREATE code" tab in the table editor makes HeidiSQL crash.

I suppose the issue lies in the regular expression that extracts columns names.
ansgar posted 1 year ago
Quote parsing fixed in r4397
ImRicoh posted 1 year ago
How can select which tables to export data.

for example

+ DataBase
STRUCTURE DATA TABLE
[X] [X] Table1
[X] [ ] Table2
[X] [X] Table3
[X] [ ] Table4

Best Regards
ansgar posted 1 year ago
Please do not use this release thread for such questions.
dodfr posted 1 year ago
Query history ??? yes !!!
Rvanlaak posted 1 year ago
Come on guys, create new threads for feature requests...
smserwan posted 1 year ago
thankyou thankyou thankyou
i'm a big fan of heidiSQL
it's a great software

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