• 2 Posts
  • 807 Comments
Joined 1 year ago
cake
Cake day: June 17th, 2023

help-circle






  • Got hands on experience with this. Wasn’t my design choice but I inherited an app with a database where one of the keys was tied to a completely separate database. I mean at the time it probably made sense but the most unlikely of scenarios actually happened: that other database, the one I had zero control over, was migrated to a new platform. All of those keys were synthetic so of course they were like, “Meh, why we gotta keep the old keys?” So post-migration my app becomes basically useless and I spent 6 hours writing migration code, some of it on off hours, to fix my data.

    So it’s questionable whether a foreign key of a completely different system is a natural key, but at the very least never use a key YOU don’t control.









  • Just because it’s not on a report doesn’t mean providers have no recourse when it comes to seeking compensation. If they so choose they can take anyone to court and obtain a legal judgement. The frequent calls and letters from collectors are no picnic either.

    The biggest issue I have with paying bills on time is the stupid billing systems. Like 30% of the time I either can’t find the payment option in their portal, login doesn’t work, don’t see any record of services (i.e. just give us money), or the total amount owed is different from the paper bill. Life is distracting, and if I can’t assess what I’m paying for and get to the “Submit Payment” button in 10 mins then don’t expect me to remember 8 hours later when I again have free time.