How to handle pagination with AND/OR filter on a value from another table?
Let's say I have the table
I want to support filtering posts by tags, with either an OR/AND filter on the tags.
There could be many posts, so we probably need to paginate.
I could paginate the post_tag table, but then how would I support a combination of tags without fetching all of the post_tag combinations? There are at least 100k
posttagpost_tagI want to support filtering posts by tags, with either an OR/AND filter on the tags.
There could be many posts, so we probably need to paginate.
I could paginate the post_tag table, but then how would I support a combination of tags without fetching all of the post_tag combinations? There are at least 100k
