@hj yeah, they could have architected it to stream updates with something like LiteStream but instead they went with "just periodically download a whole sqlite database" which surprisingly works well for them
and the speed is way faster than Redis because there's no network involved
@hj speaking of that though, Pleroma's rate limiter is built-in which you can't do in a lot of languages. And we can make it cluster-aware in the future. So thanks to Elixir we don't need Redis
@feld yeah, I mean it's bad but at same time it is what it is, dunno how to make it any better. I think at least we need to be more explicit about it tho. You can run pleroma on RPi but you shouldn't run database there as well.
@hj if you ripped out full text search functionality I think it could be feasible to make it run on SQLite but it would be single user and performance would struggle in a lot of areas, but in a reasonably small environment it would probably work
I would love to see it possible to build upon this. I think it is the right solution for a lot of problems, only that the tooling people commonly use is not compatible with it (expecting normal-ish SQL semantics...)