News for hackers. Stuff that matters.
Re:Hidden work when launching a SaaS by bungie4 on Monday February 12, 2018 @04:51PM (#16362634)
I usually use a date as a soft delete. If it's non-null, its deleted, and, you get to record the actual date of deletion.

I've never found it to be a problem. In fact, I find it's more of a problem to physically delete. You just have to design that way from the get go. Not added on after you've realized ppl leave.

Re:Hidden work when launching a SaaS by Rapzid on Monday February 12, 2018 @05:39PM (#16363039)
Yeah, I find the sentiment that this is hard to implement without it being YOOGE tech debt odd. There are so many ways to get it out of the way, including just querying through a view if you can't come up with an app-side solution.
Re:Hidden work when launching a SaaS by jessaustin on Monday February 12, 2018 @06:19PM (#16363302)
The technical debt might be proportional to how many ad-hoc queries you have buried in various modules before you realize that some things do need to be deleted as of a particular date. But as you indicate, with a real DBMS, naive queries can just be pointed at a view.
Re:Hidden work when launching a SaaS by bungie4 on Tuesday February 13, 2018 @07:50AM (#16366713)
Also, how to deal with down the road queries wrt; churn when you have deleted the data. I'm calling self inflicted technical debt because of shortsightedness or, dare I say it, lack of acumen. :D