Repository navigation
[Feature]: Visualize JSONB as JSON #3578
Description
Describe the new feature
SQLite 3.45.0 introduced JSONB, a binary encoding of JSON stored as a BLOB.
Unfortunately, inspecting rows in the database with this format is hard because they are not readable.
The "edit database cell" section only supports "Mode: binary", which shows the binary format, not the actual JSON.
The current workaround is to issue a query that converts the blob into actual JSON with SELECT json(jsonb_column) AS actual_json FROM ....
Ideally, there is a new mode to inspect JSONB blobs and display them as actual JSON.
Does this feature exist in another product or project? Please provide a link
No response
Do you have a screenshot? Please add screenshots to help explain your idea.
Reacted by sidesteps, Max Kamps, PhilTdr and justin0mcateer
Activity
mgrojo commentedon Mar 22, 2024
If you don't need to edit the column, you can use a display format.
danielepolencic commentedon Aug 12, 2024
Would you be open to add a new entry "JSONB" in the mode dropdown?
I feel this should work out of the box since it's a new type offered natively by SQLite.
decadenza commentedon Oct 1, 2026
This would be really useful. Currently the field is shown as:
And:
The workaround is to execute a query using
SELECT json(data) FROM your_table;.If would be useful to have it integrated as "JSONB" menu entry.