steemit / steem

The blockchain for Smart Media Tokens (SMTs) and decentralized applications.
https://steem.com
Other
1.95k stars 790 forks source link

Merge and replace deprecated steemd with PostgreSQL or similar #3620

Open pfunks opened 4 years ago

pfunks commented 4 years ago

There are superior databases to use for a centralized content database and ledger. steemd is woefully inefficient for this purpose. It is a waste of resources to run a centralized database on software meant for a decentralized network.

mtastafford commented 4 years ago

This would really trim a lot of the fat off of the project. I suggest we remove all the code related to witness voting as well, seeing as how it's obviously a waste of time.

Couple kb saved, but that's money in the pocket!

VIM-Arcange commented 4 years ago

We should really consider .txt files. It's way more easy to edit, rename or delete. That will definitely help to get rid of the redundant information stored in the blockchain, you know this immutability and censorship-free thing nobody cares about. IMHO, this is the best way to reduce the current blockchain size and speed up replays!

CADawg commented 4 years ago

Wow. I love how innovative you guys are. We could be the next OneCoin!

4miners commented 4 years ago

Why not just delete the repository? You will not need it anyway after move to TRON... 🤔

prcolaco commented 4 years ago

This way, using postgresql we could remove all the plugins as well and implement them as stored procedures! so much easier to maintain and easier to deploy as well, as the database would just serve the code as well and the nodes would just be there for the sake of decentralization, oops, or better, redundancy...

officiallymarky commented 4 years ago

I'm all for it!