I ran the Primal caching service for about 8 hours and stored about 8GB of data. So I conclude that Nostr is producing about 1GB of data per hour across the whole network.

I remember back in the day when "lol" seemed like overkill. Then we got the "😆" emoji as a Facebook react. Over time people gravitated to "😂" even though it's so far outside the realm of what people are actually doing. A slight smile, or even a smirk gets a "😂" out of politeness. We never thought anyone would be daft enough to actually use the "🤣". But more and more people are like "🤣🤣🤣" for even a slight smile. What's next, gen Z? Will you have to invent a new emoji to express the catastrophe of your hilarious laughter? 💀

The main limitation of SQLite is that it locks up when you try to write too much to it at once. This makes it "not a great use-case for social media". Not even due to your posts, but because of all the likes and emoji reactions you guys do. I still haven't hit any of those limits in my own experience. But writing to multiple database files could help it a lot, I bet.