News for hackers. Stuff that matters.
Re:Pleroma 2.0: a free, federated social networking server b... by claudiawerner on Monday March 09, 2020 @08:00AM (#22524681)
Danbooru (and forks like Moebooru) and Philomena use string arrays in the database for tags.

Edit: nevermind, Philomena has a table for the many-to-many relationship and uses Elasticsearch for the heavy lifting.

Re:Pleroma 2.0: a free, federated social networking server b... by hau on Monday March 09, 2020 @09:01AM (#22524995)
Why arrays are preferable over m2m tables? What so special about pg arrays that makes anything but them inferior in "tagging" case? I genuinely don't get it.
Re:Pleroma 2.0: a free, federated social networking server b... by claudiawerner on Monday March 09, 2020 @09:45AM (#22525255)
Accodring to these rough benchmarks, it's faster to use arrays rather than joins:

https://shon.github.io/2015/12/21/postgres_array_performance...

https://gist.github.com/joevandyk/031cf5812bd656887623

To search for a post with multiple tags, you need to do a join for each tag. You don't have that problem with arrays.

Re:Pleroma 2.0: a free, federated social networking server b... by hau on Monday March 09, 2020 @02:50PM (#22528442)
Thanks, that looks cool.