search

jakob / Postico

Public issue tracking for Postico
https://eggerapps.at/postico/
476 stars 9 forks source link

Feature Request: Regex-style table sidebar filtering #396

Open jhaber1 opened 7 years ago

jhaber1 commented 7 years ago

e.g. *_users, ^user, users$

Coming from Sequel Pro, to me, this is one of its most powerful features that I haven't seen in any Postgres GUIs.

jakob commented 7 years ago

*_users is not a standard regex. I assume you mean .*_users?

jhaber1 commented 7 years ago

Sorry, yeah, should have clarified; I was mixing standard globbing syntax with regex (which Sequel Pro supports both if I recall correctly). Something like *_users would return e.g. new_users/old_users/young_users, etc.

Though maybe in application, it's probably not best to conflate the two styles.

jakob commented 7 years ago

No, Sequel Pro doesn't support glob syntax. They try matching a regex, and if it fails, they fall back to substring matching. See here

Looks like a good idea...

gajus commented 6 years ago

This needs more visibility. Can this be added/ tracked in the README.md?

jakob commented 6 years ago

@gajus Sure. Just tell 12 more people to click the "thumbs up" button and it'll appear in the top ten when I update it the next time :)

gajus commented 6 years ago

There should be at least labels or some other means for people to find feature requests.

gajus commented 6 years ago

I don't understand how others work without this.

I have database with 150+ tables. When working on a particular problem, I want to be able to switch between related tables. Now I am using a new tab for every table. But that doesn't allow to visually navigate the tables quickly.

This is a quick feature to add.