Feature Request: Configurable Column Presentation in Content View
- Dominant language
- Python
- Stars
- 486
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
I love Postico's subquery popups for foreign keys in content views, but it would be FANTASTIC if it could go one step further and allow *aliasing* of how that column is presented in column view; eg, if, as is common, the key is on an integer or uuid, to let you alias that column's presentation as a *different* column from the referenced table (italicized or somehow otherwise graphically adjusted to reflect that it's not the true value of the column).
Obviously this is non-trivial since you're effectively doing a join for every content view but would be a huge readability & entry time-saver, especially for heavily-normalized schema.
While you can achieve similar results by setting up views in the DB itself, there are many advantages to not creating permanent schema in the DB purely for presentation/utility reasons, and then having to limit or otherwise scope access for what's a convenience for *one* user.
Even better would be if this was configurable by way of a bi-directional data handler function, to allow *other* aliasing/presentation step transformations. Extensibility could then allow other things like, for instance, configuring a column that stores image urls to actually show the image :)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the content-view handling for foreign-key subquery popups and any existing column-presentation configuration. Define the intended scope for aliases, joins, and bi-directional data handlers before implementation; done should include a clear configurable presentation behavior for referenced columns.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- database, desktop
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100