Forgive my technical ignorance here: Could SQLite be used as a "lightweight" ActivityPub datastore, for a hypothetical ~single-user instance? Leaving current implementations (Mastodon, etc.) aside, I'm curious if/how this could work? /cc @simon
@kylev @case @anildash SQLite happily handles hundreds (even thousands) of writes a second, so I imagine for almost all Mastodon use cases it would be just fine - maybe not for a single instance with thousands of active users, at least not without scaling up the server to one with a lot more RAM and CPU
@simon @kylev @case @anildash my 30-person instance processes about 200k messages/day via the redis queue. That's less than three/second. Watching sidekiq, it sometimes bursts to high double digits.
I have no doubt that sqlite would be able to handle several hundred users on modest hardware (I have it on a 4GB VM that's backed by NVMe storage; it's 20 bucks/month). I suspect it might be even more performant than postgres at that scale, since it's so much faster at chaining queries.