pgadmin-org / pgadmin-org/pgadmin4

Add Menu of Recently Opened Query Tool Files

Open
#6,422 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Feature
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

Open the contributing guide

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 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.