Exploring alternatives to the archived_at column pattern: triggers, application events, and WAL-based change data capture.
  • stevestevesteve@lemmy.world
    1·
    3 days ago

    I don’t feel like leaving the records in-table is that terrible. Maybe even partition on the deleted-at column to keep the performance impact minimal. The benefit of simplicity massively outweighs the rest for me