Scaling just fine right now. To be honest, the goal was always to be able to scale /down/, not necessarily up. But latest release has been pushing up to 200mbits/sec while using a single core, so good enough for many of us.
Discussion
Does multiple cores help? I thought sqlite is single threaded
Sqlite locks on each access afaik, so you're probably right.
Not in WAL mode: readers and writers can proceed without blocking one another. Checkpoints can be an issue for concurrency, but that can be worked around.
SQLite can use many cores, and even multiple processes. There are some gotchas, but generally speaking it can use every core available for queries (especially reads).
Do you have plans to implement retention configs? We elected to just crank down all the limit settings by default for now
Plan is most likely to allow gRPC to deny, permit, or permit w/expiration. Need to implement the expiration NIP first, that is going to be a little tricky to not have a performance regression on.