@cosine @cloud the problem in question is the usage of JSON column type in mysql, which is an unofficial extension of the SQL standard. mariadb isn't *quite* 1:1 with this because it's not standard, but as of mariadb 10.2.7, all json types are aliased to longtext. this may have some unknown side effects.
otherwise, it's perfectly understandable for some to feel that pixelfed is not quite ready for deployment. the readme highlights this in bold.
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!