3 ms·
We deal with soft delete in a Mongo app with hundreds of millions of records by simply moving the objects to a separate collection (table) separate from the “no
by cj 9mo ago
We deal with soft delete in a Mongo app with hundreds of millions of records by simply moving the objects to a separate collection (table) separate from the “not deleted” data.
This works well especially in cases where you don’t want to waste CPU/memory scanning soft deleted records every time you do a lookup.
And avoids situations where app/backend logic forgets to apply the “deleted: false” filter.
- vjvjvjvjghv 9mo agoI guess that works well with NoSQL. In a relational database it gets harder to move record out if they have relationships with other tables.
- tempest_ 9mo agoEh you could implement this pretty simply with postgres table partitions