alkem-io / alkemio

START HERE! Cross project collaboration and shared documentation.
European Union Public License 1.2
23 stars 4 forks source link

Database: Robust deletions #1237

Open techsmyth opened 5 months ago

techsmyth commented 5 months ago

Description

Ensuring deletions are atomic is best done at the database level, simply hard to guarantee at application level.

This epic is about moving the deletion logic to be more in the database.

Initiative / goal

Maintainability + stability of the solution at scale

Hypothesis

There have been instances of orphaned data in the database due to server's crashing part way through a deletion.

The deletion should be much faster when happening at the database level.

Acceptance criteria and must have scope

Stakeholders

DevOps

Timeline

tbd

Design