Automatically group/hide table partitions

[Oliver-Saer]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): PostgreSQL 12.5 Alpine
2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 520

---

I'm really grateful that you have released a groups manager so that we can put our partitioned tables into a group, rather than having them all pollute the top-level.

However, a much better solution that I have seen other major PostgreSQL GUIs provide is the option to simply toggle-off partitions altogether. These are accompanied by handling to treat the normal table as a combination of all of its partitions. Currently in TablePlus, if I want to view/edit the schema of a partitioned table, I have to find its _default partition in the group.

Also, if I open another database (ie; for local/staging/prod environments), all of my groups do not carry over. So I either have to deal with it while I'm working with this environment, or create a whole load more groups.

This isn't a massive issue, but it's a far worse experience than is being offered elsewhere. Where this has been asked for before, the solution has been along the lines of "just use groups". So I'm wondering if this is maybe something you guys aren't prepared to address in the way I'm referencing here?

Thanks for your time and for continued development of this app.

[huyphams]

Hi @Oliver-Saer thank you for the details. It's a nice idea. I'm considering adding an option for "auto group partitioned tables" or "auto group tables with the same prefix/suffix." When enabled in the settings, TablePlus will create a virtual group for all of them without requiring manual creation repeatedly.

[Oliver-Saer]

Thanks for getting back to me on this. Something like that would be great and very much appreciated!

What would be even better is, as I alluded to in my OP, if the GUI would behave as though the partitions don't exist and instead allow all schema & data to be viewed/edited just by selecting the parent table.

In case it helps you decide upon an implementation strategy, an example of a GUI which I recently tried out (before ultimately deciding to renew my TablePlus licence 😉) named Beekeeper Studio is open-source so you can check out how they did it if you want: https://github.com/beekeeper-studio/beekeeper-studio

[jaybeecave]

Grouping would be a great feature

[xcrone]

Hi @huyphams @Ivoah,

I've always wanted this feature. Been asking from email a year ago. I would prefer the "auto group partitioned tables" instead of "auto group tables with the same prefix/suffix" because to me it's for different use case.

I've tried using grouping with prefix for my partition table. Even though it's grouped, I still need to open the grouping and find the main table to get all the records which is to me not the best potential UX.

I have some table that want to be grouped together by prefix/suffix but for partition tables, I only need to see the main table. The other partitioned can be hide and maybe just put a tag/toggle in table name to tell that this table has partitions.

I hope the team would consider this.