<j​airbolsonaro:nope.chat> Greetings to all the people who helps making Monero such a great crypto.

<j​airbolsonaro:nope.chat> I have a question about Monero's database choice. As said by some valuable contributors in the #monero channel, LMDB has a lot of write amplification for this specific use case. Since most blockchain data is immutable (as an example key:block hash value:block data blob), why not just creating an append-only database file for immutable data (that's the majority of data stored in da<clipped message>

<j​airbolsonaro:nope.chat> tabase, as far as I know) that contains all the values, and keeping a simple index that saves the keys and the position of their values in the append-only file? It would have literally no write amplification and the best performance possible with purely sequential writes, the only downside is that values can't be deleted efficiently or modified (their length can't change) (at leas<clipped message>

<j​airbolsonaro:nope.chat> t not without recompacting the whole database). Which is not the case for most of the blockchain data.

<j​airbolsonaro:nope.chat> Thanks in advance.

^ this has been done in cuprate

<s​yntheticbird:monero.social> Just like DataHoarder said

<s​yntheticbird:monero.social> see Cuprate/cuprate #566

<s​yntheticbird:monero.social> and github.com/Cuprate/Tapes