As a summary of our findings in writing:
Below is a table of user needs we discovered and solutions we or the customers suggested. Some of the "missing" features people complained about are not missing at all (such as auto-complete or syntax highlighting) but the fact that people didn't know about them points to a discoverability issue we believe we can address through design.
Needs | Suggested Solutions |
Users need a reliable way to save their queries frequently | Autosave, Persisting & Complete History, Persisting Un-run queries after disconnect |
Users need a more efficient way to type | Auto-discoverable Autocomplete, Customize shortcuts, more visible syntax highlighting |
Users need a process to share query output with others | Copy and Paste into Excel with proper formatting, Export button to MS XML |
Users need a way to quickly input content into pgAdmin | Edit within graphic table |
Users need query output to be stored to reuse results | Results stored in history |
Users need an easier way to find saved queries | Workspace, Search |