Good evening,

don't know what you do, but

"rails and search over join table elements"

More or less, I have a table of posts, that has a many-to-many association to tags.

Now I want an AND search over tags.

Meaning "cute fluff" leads to posts that contain both and not just any of them

An OR connection is what I have already and it's pretty darn easy

Just join the two, add an 'tags.name IN <Array of tags to look for>" and be done

An AND connection is so much harder, without pulling everything and going over every post (brute force takes >60s)

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!