jakob / jakob/Postico

Foreign Key Editor usability

Open
#664 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
486
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Selecting the referenced table for a FK gets cumbersome when there are a lot of tables. If I'm lucky the table name is unique enough that I can type the first letters after opening the _select table_ input and the right table gets selected, but this does not always work.

A (fuzzy) search filed would help a lot. I currently have 400+ tables in 40+ schemata and scrolling through the complete list looking for the right table is not the best.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at the Foreign Key Editor and inspect the select table input used when choosing a referenced table. Verify how selection behaves with many tables and schemas. Done means users can search, including with fuzzy text, and select the intended referenced table without scrolling through the full list.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
desktop
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.