There are advantages for soft deletes for CRUD architecture, but are there any for CQRS/ES (Event Sourcing)? I guess if your read model is based on RDBMS then

There are advantages for soft deletes for CRUD architecture, but are there any for CQRS/ES (Event Sourcing)? I guess if your read model is based on RDBMS then it makes sense, otherwise it depends on the database system in question (i.e. some NoSQL databases like C*[1] and Riak[2] are implementing deletes by writing special tombstone values, which is kind of soft-delete but on the implementation level - but you can't easily restore the data like in case of RDBMS). [1] https://thelastpickle.com/blog/2016/07/27/about-deletes-and-tombstones.html https://thelastpickle.com/blog/2016/07/27/about-deletes-and-... [2] https://docs.riak.com/riak/kv/latest/using/reference/object-deletion/index.html https://docs.riak.com/riak/kv/latest/using/reference/object-...