pgadmin-org / pgadmin-org/pgadmin4
Add Menu of Recently Opened Query Tool Files
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
Describe the solution you'd like
As a pgAdmin user who often needs to open, edit and run queries out of saved .sql files, I would like pgAdmin to have a menu that shows me the five or so most recently opened files. I would like this "Open Recent" menu to be available regardless of whether I already have the Query Tool open. Clicking on one of the recently opened file names should open the Query Tool with that file loaded.
Describe alternatives you've considered
None.
Additional context
I work on multiple database projects with substantially different topical matter. As a result, I have saved .sql query files in various directories on my computer. pgAdmin conveniently remembers the most recent directory I have opened, but if I am opening files from different projects (not unusual), I end up needing to re-navigate to their folders, which is time consuming.
I'm not sure where such a menu should live, however, in the pgAdmin context. In most apps that have a File menu, an Open Recent ... exists there. pgAdmin does not have a File menu, so perhaps it would require a modification of the Tools menu.
Contributor guide
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 tracing how pgAdmin opens saved .sql files in the Query Tool and how the Tools menu is assembled. Check how the application handles opening files when the Query Tool is not already open, then determine where a recent-file list could be stored and displayed. Done means an Open Recent menu shows roughly five previously opened files and opens the selected file in the Query Tool.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100