search

TablePlus / TablePlus

TablePlus macOS issue tracker
https://tableplus.com
3.48k stars 57 forks source link

[feature request]: Instead of showing jsonb and json columns as a string of text, show it as a expand/collasable tree #2663

Open nojvek opened 2 years ago

nojvek commented 2 years ago

O### Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): PostgreSQL 10.0 / MySQL / MSSQL.
  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 414
  3. The steps to reproduce this issue:
    1. Open any table that supports jsonb/json column.
    2. Select a row.
    3. Expect to see expand/collabsable json viewer like chrome devtools / snowflake instead of a large blob of string.
image

We deal with a lot of json data. Having something like Snowflake / Chrome devtools json viewwer would be a great improvement in quality of life.

Example:

image

The render could work in a way that it would prettyfy the json while keeping it copy-pastable as real json.

image

Snowflake's variant column (aka json) make it very easy to explore large json blobs.

huyphams commented 2 years ago

Hi @nojvek you can view it using QuickLook:

  1. Command + Enter
  2. Using middle mouse.
  3. Right click > Quick Look editor.

The view on the right sidebar is supposed to show raw data

nojvek commented 2 years ago

I see that TablePlus has a quick look editor for JSON if you right click on a datacell. Would be nice if that could be to set as the viewer for json/jsonb columns somehow.

image
djkgamc commented 1 year ago

How about defaulting to pretty view for JSON in the sidebar? Does that count as a way to display raw data to a human? I think so