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. 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.
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.)
Please login to leave a reply, or register at first.