I figure it can scale "big enough" for a decent sized community to use, and hopefully will be more than usable on a $5/month tiny VPS. But I'm also eager for first-hand knowledge of how far SQLite /can/ scale.
Discussion
Ok, good to know. I'm shopping for options what to put on my beefy server (8vCPU, 32GB RAM) and assumed sqlite might not be the solution. On the other hand, all nostr events still fit comfortably into RAM :D