• fishpen0@lemmy.world
    link
    fedilink
    English
    arrow-up
    1
    ·
    3 hours ago

    Right up until you are doing compliance and governance and you realize docs are actually a terrible terrible source of truth for any automated systems. We’re 3 years into a project at a healthcare company to rip google sheets and docs out of our apps and replacing them with Postgres, bigquery, dbt and dagster.

    It’s simply not okay to have your database be something anyone with write access to a doc can fuck up a formula by accident on. Your medical bills being maintained by random formulas on dozens of linked spreadsheets maintained by hand by random people on different teams is part of why they are impossible to unwind. By the time someone audits it, it’s printing different numbers than when your bill was rendered and it’s version control doesn’t work to roll it back without breaking dozens of other things.