Mastodon Feed
dysfun@treehouse.systems ("gaytabase") wrote:
there have been two attempts at a model everything in postgres for flexibility version of fedi. jsonb and my own universal primary key with trait tables.
jsonb turns out to be a mistake for real. perf goes to shit fairly quickly, this is why pleroma and akkoma users are always complaining about perf.
UPK w/traits is a mixed bag. it will get you that flexibility and it will work better than jsonb, but you're still ultimately making the database's job quite difficult. and of course you can't make the database do all the recursive deletion for you so have fun with that.