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
@case @simon I don’t see why not. SQLite should have the performance to run a single user instance if not a few more. Not entirely sure what the concurrent connections on SQLite are? something like https://fly.io/docs/litefs/getting-started
@jesse @case the general rule with SQLite running in WAL mode is concurrent reads but only one process writing at a time
Since SQLite writes are mostly measured in fractions of a millisecond it turns out queuing up writes to apply once at a time will happily handle hundreds (or even thousands) of writes a second on modest hardware