• 1 Post
  • 198 Comments
Joined 1 year ago
cake
Cake day: February 14th, 2024

help-circle













  • Maybe Musk needs to learn about data normalization and natural keys.

    I’m curious what the actual data looks like. I’ve spent quite a bit of time auditing large data systems.

    I would expect these databases to be largely denormalized with very wide tables, I would expect them to favour natural keys like a SSNs, and built around per department use cases.

    I would not expect them to be highly normalized because then when you need something from another department you need them to ensure consistency.

    These systems probably have like 50 years of legacy code or more in them too.






  • It was fun and I learned a lot. I mostly did small time jobs for local companies and used the money for my tuition. Most sites were just static HTML, and I could program flash, so there wasn’t much risk to it.

    I am glad we have git instead of various backup folders on an ftp server, continuous integration, unit tests, and frameworks/accessible info to prevent the more basic errors.