4 ms·

I think it's fair to ask whether the file's _contents_ need to be ACID transactional or could you just mark the row as deleted and schedule a job/Cron to clean

by hderms 7y ago

I think it's fair to ask whether the file's _contents_ need to be ACID transactional or could you just mark the row as deleted and schedule a job/Cron to clean them up? In light of that, and the fact that a binary blob isn't really a relational piece of data and I can see the logic behind not storing it in a relational DB.

Matthias247 7y ago
I agree with that. Doing some kind of asynchronous garbage collection (Dumping all uploaded files, dumping the filenames from DB, and deleting all that are not required anymore) might be a lot easier to get right and reliable than trying to do everything in the request path.
- fgonzag 7y ago
  This is a such a good solution in many cases and is often ignored.
- fatnoah 7y ago
  This is what I did at a previous company where the main product was a messaging app with daily active users in the millions. Deletions were bit flips that were then cleaned up later by a cron job.