Ability to create filtered indexes

Both SQL Server and Postgres allow indexes to be filtered by a condition.

Same behavior can be emulated in MySQL as described here: https://stackoverflow.com/questions/7804565/workaround-in-mysql-for-partial-index-or-filtered-index

I consider this to be an important addition, have had many use cases where a backend check needed to be applied instead of relying on DB checks, which are prone to user error and take longer to execute. DBDiagram has proven to be quite a useful tool and I’d be glad if they could support this feature as well.

3 Likes

I also would like this to be added, a way to define additional clauses on an index, like WHERE column_name IS NOT NULL, is pretty essential for a lot of use cases

Hi,

Thank you for sharing,

We noted your ideas and will consider implementing them in the future.

Cheers.

Are there any updates?

Hi @ski7777 ,

We added this functionality to our backlog. We are still considering implementing it in the future.

Thanks.

Hi, any news? We don’t even see it in the backlog as you said :confused:

Hi @Matteo_Convert ,

At the moment, we’re prioritizing a few other highly requested features first. We appreciate your patience and feedback, and we’ll be sure to share updates when there’s progress on this feature.

Thanks.