jakob / jakob/Postico

Add "matches regex" to column filter options

Open
#905 0 comments 0 reactions 0 assignees View on GitHub
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

Image

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.