Open fervi opened 5 years ago
Thanks for the idea. That does sound like a good direction to go. I will be doing research on such databases and see if I can migrate.
Alternative way is to use "Fediverse" technologies. It's Decentralizated Federations Network. In short. We have two servers (Zapread.com and Zapread2.com) - they are independent, but they can "talk" and sharing content (but it's not mandatory)
https://en.wikipedia.org/wiki/Fediverse I recommend "ActivityPub" protocol
https://www.cockroachlabs.com/product/ could be a good option. Not sure if performance would be as good as SQLServer which is used now.
Also, we need to be careful that sensitive user data isn't leaked. The current DB is encrypted and well secured. If the DB becomes distributed, then data protection needs to be ensured. Not an easy problem.
In general, we are working on Zapread, which has a problem with the centralization of the project. Everything is on one server and if the creator dies this zapread (as a service) also. Of course, someone will do a fork right now, but what if Zapread would use a decentralized and censor-resistant database? Maybe it makes sense?
I once read about Rqlite and it's worth checking.