Well, I run an instance, too. It's not big at all, but I was thinking about the issue of scaling, too. You can only scale up a single server so much...
But on the other hand, Lemmy is still young. We'll find solutions to that problem.
Also, interesting article. I only took a glance at it, but having only two tables kind of suggests that Reddit is using a relational database. So, if they're not "normalizing" everything, why not use a completely different paradigm, like what MogoDB etc. has?
Yes, I figured. My domain name is not as cool as "shitjustworks" or whatever. But I can say that my instance is gonna stay for as long as Lemmy as software is supported, no matter if there are many users or not. I strongly believe that FOSS and the Fediverse are the future and I want to give something to the community by hosting the instance.