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
post,tag,post_tag (join 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
