jakob / jakob/Postico

[Feature request]: All things JSON...

Open
#570 10 comments 10 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Postico is great, it's sleek and fast! However I'm using Postgres JSONB functionality more and more, and it could really do with some TLC in this area. Here are some ideas I think could help improve the experience of using JSON in Postico:

1. Pretty print by default when hovering over a JSONB field, and in the righthand pane.

2. Currently when switching to Pretty Print in the righthand pane it considers this a mutation of the field and asks to Save Changes. I would suggest making this purely presentational to not risk mutating the field just for pretty previews.

3. There's currently no way to preview pretty printed JSONB in the SQL Query tab, which makes it really tough to work with large JSON responses. A righthand pane, and pretty printed preview on hover would go a long way in this view.

4. It would be great to have an option to toggle between the current 'rows' response view, and a purely JSON response view in the SQL Query tab.
(Similar to https://github.com/jakob/Postico/issues/459)

Thanks for listening!

## What software versions are you using?

Postico version: 1.3.4 (2642)
macOS version: 10.13.5
PostgreSQL version: 9.6.6

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reviewing the JSONB field display and the SQL Query tab, which are the entry points named in the request. Compare the current rows view and Pretty Print behavior with issue #459. Done means the requested JSON previews, non-mutating presentation behavior, and optional JSON response view are defined and implemented.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
database, desktop
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.