Add "matches regex" to column filter options
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
When selecting a column filter, it's often useful to be able to use the regular expression operators ~ and ~* to filter by a regex - I use this daily. Would love to see this in this list!
"matches regex (ci)" for a case insensitive version would be helpful as well, though that's perhaps not as self-documenting, and "(case-insensitive)" might be too long. But even just the standard "matches regex" would be tremendously valuable.
https://postgresql.org/docs/18/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP
Thanks!
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the column filter options entry point and the PostgreSQL filter translation used by Postico. Add a visible “matches regex” option backed by the ~ operator, then verify that selecting it filters column values by a regular expression.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- database, frontend
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100