You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: