[Feature request]: All things JSON...
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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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