JSON viewer

Hello. I think, it'll be good idea to add JSON viewer,which show it as TREE-like struct. Current time heidisql shows text columns with JSON data as plain text. This is not useful when analyzing recorded data.

Love how others are thinking the same.

In mySQL there is a DataType: JSON

The logic could be if DataType == 'JSON' OR DataType == 'LONGTEXT'

Then display a JSON viewer/formatter component.

This would make HeidiSQL an absolute God product.

Love how others are thinking the same.

In mySQL there is a DataType: JSON

The logic could be if DataType == 'JSON' OR DataType == 'LONGTEXT'

Then display a JSON viewer/formatter component.

This would make HeidiSQL an absolute God product. I think, need check format of data in column. If it can be parsed as JSON, then display JSON viewer. Or easier way. Add checkbox to column viewer. If checkbox is checked - show it in JSON viewer, otherwise - use default viewer.

I'd love this feature in Heidi SQL!

I agree with this feature request. It would be excellent to have a way to prettyprint format any JSON-like text. A display would be great if it looked like the output from Javascript JSON.stringify(object, null, 2)

Considering how many php and WordPress users there are for MariaDB and MySQL, a prettyprinter for php serialized data would also be great. //www.php.net/manual/en/function.serialize.php (I know, it's a hideous nightmare of a format. Even the the php docs say "use JSON". But php serialize has infested the world.)