Thoughts on decentralized blockchain storage

[marcelfolaron]

Hi All,

I have been playing with the idea of adding blockchain support to Leantime.

Fancy marketing or real purpose?
One of Leantime's value proposition is privacy. Being able to store your project management system and files on your own server/private cloud offers a lot flexibility in terms of access restrictions, backups etc.
Blockchain could bring that to a new level. A decentralized store to store files, knowing that all versions will remain in the blockchain.

What to store?
Ideally everything but my understanding of the current options and technology is that this is not feasable.
MySQL being a relational database following CAP won't allow us to split the file and store in a blockchain network. Aside from that, even if we were to try it query speeds would be extremly slow.

One option is to store only files. There are multiple file storage providers out there already (https://www.storj.io/, https://filecoin.io/, https://sia.tech/) and their API seems simple enough to integrate.
Drawback is cost and again speed.

Lastly we could store a hash of each transaction in blockchain, this would give us at least a secure transaction history of everything that happened in Leantime. We started logging activity in the DB and could probably abstract that easily to store it anywhere.

What are your thoughts? Any blockchain experts here?