Postico icon indicating copy to clipboard operation
Postico copied to clipboard

Pin Tables

Open jakob opened this issue 7 years ago • 4 comments

It would be useful to have a feature that allows "pinning" tables (similar to Apple Notes). Pinned tables would always be shown at the top of the sidebar, regardless of filters, and allow to quickly jump between tables.

jakob avatar Jul 05 '18 07:07 jakob

Don't mean to hijack this issue, but it would be great to be able to "pin" table columns too. This would address(to an extent) the inability to reorder columns, without the need to create extra views or use other hacks mentioned in #370

v15h avatar Sep 08 '18 11:09 v15h

@v15h it's already possible to reorder columns for display in the table view -- it's just not possible to do so server side. I'll comment on issue #370 to make that clear.

jakob avatar Sep 08 '18 11:09 jakob

Tried it out and it remembers the order too! Just what I needed.

Thank you, Jacob. Postico is awesome.

v15h avatar Sep 08 '18 21:09 v15h

I should like to expand on the use-case for this.

When programming a new feature, I usually introduce 2 or 3 new tables. They are usually referencing 1 or 2 already existing tables. So while working, I find myself constantly looking at the same 4-5 tables all the time (sometimes for weeks).

But my application usually has 50-200 tables. So I find myself scrolling/keyboard shortcutting/searchfiltering through the tables sidebar over and over again, to find my relevant tables and see what new data was created during development.

I know I can use 5 windows or 5 tabs to solve this. Multiple windows I rule out because I don't have so much space when on the go with my laptop. And It's quite a hassle to resize and position them depending on the rows that are there.

Tabs are cumbersome because it's not easy to see which table I'm currently looking at. Or, say, I have a colleague look over my shoulder, they wouldn't easily see what it is that I'm looking at. This is natural: "Hey, this is the feature I'm building, see those tables here? These are the ones I focus on at the moment."

Also, I use the mouse a lot and would not want to CMD+number through the tabs until I "accidentally" found the table I want to look at. Rather I'd like to see only a few tables in the sidebar, those that are relevant to my current work, clearly highlighted to see which one is open, manually going through them with the mouse.

The table-search-filter in the bottom allows me to find one table (or multiple by prefix/suffix). But that's not enough.

Pinning would be superb. I could also imagine entering multiple table names in the search bar (separated by space) to filter forth all necessary tables.

(For some years this has been the one missing feature I stumble upon pretty much every day. I'm glad I found this issue after reading through all 300+ of them when I thought I'd finally do my part and post a new feature request :)

Thank you indeed for your time. I'm sure eventually this feature will surface :)

halo avatar Oct 30 '20 09:10 halo