Use JSONB instead of a join table. As the tests, er, attest, this works perfectly fine, and it'll be much easier to work with in all cases except maybe for statistics (but I'd probably want a triggered update to some counts table anyway, as per this blog post)
Use
JSONBinstead of a join table. As the tests, er, attest, this works perfectly fine, and it'll be much easier to work with in all cases except maybe for statistics (but I'd probably want a triggered update to some counts table anyway, as per this blog post)