HeidiSQL 8.0 released

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)

I guess, I am not the only one working at this weekend ...

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.

Good news guys ! Heidi is a very good client, you did a so great job ! Congrats and good luck !

thank you!

Great to hear! Thanks for all efforts...

Good new version. Fixed the bugs, hope it better!

Why not add object groups. For example.

Tables
Views
Querys
Procedures
Functions
and more

This is in the new 8.0 release. You just need to right click the tree > "Tree style options" > "Group by type".

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

Thanks a lot!
Query history that's what I really missed!

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.

Quote parsing fixed in r4397

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

Please do not use this release thread for such questions.

Query history ??? yes !!!

Come on guys, create new threads for feature requests...

thankyou thankyou thankyou
i'm a big fan of heidiSQL
it's a great software