

It’s definitely possible to store the stories in columns, but there’s also very little reason to do it. I think filepath in SQL and the stories in separate files in whatever format makes the most sense (html, txt, epub). If you ever want to search the stories for keywords, write a python script to build indexes in SQL, performs much better than doing LIKE on a maxed out varchar column.
I was thinking maybe Elastisearch, but I don’t know how much work that is to set up. For a hobby project, writing your own indexer isn’t too hard and might be more fun and easier to maintain than an industry-grade solution.
I’ve been here for a while and this is still unclear to me: Is All only the communities that are synced to my server? And syncing is dependent on a user on my server subscribing to it? So if I find a new community on a different server and subscribe to it, it will show up on my server’s All?