Organizing tables in folders/groups...
Is it possible to somehow group tables to virtual folders (or something like that). Or at least sort tables manualy?
Example:
we are using postgres and we have the folowing tables:
As you can see there are many tables which are related to “partner” (marked with red). I would like to put those table in one folder or at least move the table device_partner close to the other partner tables.
Is it possible to do something like this in datagrip?
We could use multiple schemas but that is much more complicated because we would have to move tables between schemas every time we want to change the grouping.
Please sign in to leave a comment.
Hey Adrian Green!
Thank you so much for your detailed and structured feedback! Would you mind if I add your suggestions to the existing feature request for Virtual folders for objects: manual distribution?
Best regards,
Dmitry Romanov
Product Manager, DataGrip
Currently, there's only a sorting option for the table columns
https://youtrack.jetbrains.com/issue/DBE-6929/Structure-View-Column-reordering-and-sorting-issues
We have a set of feature requests for managing database objects in Database Explorer:
https://youtrack.jetbrains.com/issue/DBE-6929/Structure-View-Column-reordering-and-sorting-issues
Please feel free to upvote and follow this issue
The lack of the ability to organise tables into ‘groups’ or ‘folders’ is pretty much the #1 pain-point in Datagrip.
Please, Jetbrains, try to work with multiple schema, each with 5000+ tables.
Try to constantly filter and scroll through such huge listings. Even 500 tables is a stretch to do comfortably.
It seems like such an obvious thing to provide. I am astounded that people can work without it. They must have super-human memory and keyboard shortcut foo.
I GET that there is filtering available, and that is nice, but what happens when you simply want to organise tables into easily navigated system?
Making some kind of dynamic grouping system using underscores would be a start, but not all schemas are nicely named.
What happens when you have thousands of tables that are logically related, but their names do not reflect the relationship?
What happens when you return to a system after months and have forgotten the complex set of relations?
What happens when you wish to share your project with someone who has no knowledge of the relationships?
…
Why not just allow the user to create their own folders? WHY NOT?
It does not affect anything. It does not hurt anyone. It just allows a user to be organised. PLEASE allow users to be organised.
A certain competitor product allows a single level of grouping (Navicat). Along with their nice data-filtering UI, Navicat is lovely to work with in comparison.
Please, please introduce table(/view/function/procedure/package…) grouping and go one-better than Navicat and allow the user to create nested groups.
nb: the feature request in the reponse above relates to table columns, not the organisation of tables and other objects as per the original question.
Dmitry Romanov - Re adding my comment to DBE-10741 - yes please.
I already made a comment there quite some time ago, but perhaps if YOU echo my comments somebody will sit up and take notice!
:-)