I'm interested in the possibilities for hosting dynamic content. I was thinking a Lemmy instance might be fun. If there was; A minimum 2Ghz spec for participating servers. A minimum solar system sp...
Just an idea. Anyone interested in buying some solar hardware to play with?
This is actually on my longer term plans. I already have some hardware for running my servers on solar power, but its a bit more complicated to get everything set up and the grid power I am currently using is mostly wind and geothermal anyway (as in… literally because those power plants are very near).
Distributing file storage could be already done via a newer version on Pictrs and Garage but currently the Pictrs instance is proxied by the Lemmy backend, so you can’t fully utilize the potential of a distributed file storage backend by serving images directly to users from it (CDN like).
However, figuring out a way to distribute the main PostgreSQL database might be more complicated (there is CockroachDB, but the licensing terms are not FOSS…).
Other than that, you really just need some sort of script to link login to the solar protocol and it should work.
I think that is only for synchronizing read-only instances off a main centralized one that is being written on. That can help with scaling, but having a central point of failure that needs to be available 24/7 would be kind off the opposite of the idea of the solar protocol.
This is actually on my longer term plans. I already have some hardware for running my servers on solar power, but its a bit more complicated to get everything set up and the grid power I am currently using is mostly wind and geothermal anyway (as in… literally because those power plants are very near).
Distributing file storage could be already done via a newer version on Pictrs and Garage but currently the Pictrs instance is proxied by the Lemmy backend, so you can’t fully utilize the potential of a distributed file storage backend by serving images directly to users from it (CDN like).
However, figuring out a way to distribute the main PostgreSQL database might be more complicated (there is CockroachDB, but the licensing terms are not FOSS…).
Other than that, you really just need some sort of script to link login to the solar protocol and it should work.
Might be a fun project to work on. I wonder if we could convince some grant funder to give us money?
Would this approach help with the database replication? https://hevodata.com/learn/postgresql-sync-replication/#Method2
I think that is only for synchronizing read-only instances off a main centralized one that is being written on. That can help with scaling, but having a central point of failure that needs to be available 24/7 would be kind off the opposite of the idea of the solar protocol.
Maybe https://github.com/citusdata/citus#what-is-citus ?
Yeah, maybe. I didn’t know this project before and would need to look into the details a bit more. Bookmarked ;)