• eah@programming.dev
    link
    fedilink
    arrow-up
    1
    ·
    3 hours ago

    I become suspicious when I see a Medium user posting well-written deep articles as frequently as this user appears to be doing. How can we tell whether this is AI slop or not?

  • Treczoks@lemmy.world
    link
    fedilink
    arrow-up
    23
    ·
    2 days ago

    I stopped using floats 30 years ago when I learned what rounding errors can do if you only deal with big enough numbers of items to tally. My employer turned around 25M a year, and it had to add up to the cent for the audits.

    • Womble@piefed.world
      link
      fedilink
      English
      arrow-up
      13
      arrow-down
      4
      ·
      edit-2
      1 day ago

      Single floats sure, but doubles give plenty of accuracy unless you absolutely need zero error.

      For example geting 1000 random 12 digit ints, multiplying them by 1e9 as floats, doing pairwise differences between them and summing the answers and dividing by 1e9 to get back to the ints gives a cumulative error of 1 in 10^16. assuming your original value was in dollars thats roughly 0.001cent in a billion dollar total error. That’s going deliberately out of the way to make transactions as perverse as possible.

      • Treczoks@lemmy.world
        link
        fedilink
        arrow-up
        20
        arrow-down
        1
        ·
        1 day ago

        Nope. With about a hundred thousand factored items, things easily run off the rails. I’ve seen it. Just count cents, and see that rounding errors are kept in close, deterministic confines.

        • jasory@programming.dev
          link
          fedilink
          arrow-up
          4
          arrow-down
          1
          ·
          18 hours ago

          You can use Kahan summation to mitigate floating point errors. A mere 100 thousand floating point operations is a non-issue.

          As a heads up computational physics and mathematics tackle problems trillions of times larger than any financial computation, that’s were tons of algorithms have been developed to handle floating point errors. Infact essentially any large scale computation specifically accounts for it.

          • Treczoks@lemmy.world
            link
            fedilink
            arrow-up
            6
            ·
            17 hours ago

            Yep. And in accounting this is done with integers. In my field (not accounting), calculations are done either in integer or in fixed-point arithmetic - which is basically the same in the end. Other fields work with floats. This variety exists because every field has its own needs and preferences. Forcing “One size fits all” solutions was never a good idea, especially when certain areas have well-defined requirements and standards.

          • soc@programming.dev
            link
            fedilink
            English
            arrow-up
            3
            ·
            15 hours ago

            Yeah, but compared to counting money, nobody cares if some physics paper got its numbers wrong. :-)

            (Not to mention that would require the paper to have reproducible artifacts first.)

            • azolus@slrpnk.net
              link
              fedilink
              English
              arrow-up
              2
              ·
              edit-2
              6 hours ago

              We’re using general relativity to calculate sattelite orbits - fuck your point of sale system if our sattelites come crashing down we’re gonna have much bigger problems lol.

        • Womble@piefed.world
          link
          fedilink
          English
          arrow-up
          3
          arrow-down
          6
          ·
          edit-2
          1 day ago

          You are underestimating how precice doubles are. Summing up one million doubles randomly selected from 0 to one trillion only gives a cumulative rounding error of ~60, that coud be one million transactions with 0-one billion dollars with 0.1 cent resolution and ending up off by a total of 6 cents. Actually it would be better than that as you could scale it to something like thousands or millions of dollars to keep you number ranger closer to 1.

          Sure if you are doing very high volumes you probably dont want to do it, but for a lot of simple cases doubles are completely fine.

          Edit: yeah using the same million random numbers but dividing them all by 1000 before summing (so working in kilodollars rather than dollars) gave perfect accuracy, no rounding errors at all after one million 1e-3 to 1e9 double additions.

          • Treczoks@lemmy.world
            link
            fedilink
            arrow-up
            5
            arrow-down
            1
            ·
            1 day ago

            The issue is different. Imagine you have ten dollars that you have to spread over three accounts. So this would be 3.33 for each, absolute correctly rounded down. And still, a cent is missing in the sum. At this point, it is way easier to work with integers to spread leftovers - or curb overshots.

            • FizzyOrange@programming.dev
              link
              fedilink
              arrow-up
              2
              arrow-down
              1
              ·
              18 hours ago

              That doesn’t make any sense. As you say, in that case you have to “spread leftovers”, but that isn’t really any more difficult with floats than integers.

              It’s better to use integers, sure. But you’re waaaay over-blowing the downsides of floats here. For 99% of uses f64 will be perfectly fine. Obviously don’t run a stock exchange with them, but think about something like a shopping cart calculation or a personal finance app. Floats would be perfectly fine there.

              • Amju Wolf@pawb.social
                link
                fedilink
                arrow-up
                2
                ·
                14 hours ago

                As someone who has implemented shopping carts, invoicing solutions and banking transactions I can assure you floats will be extremely painful for you.

                A huge benefit of big decimals is that they don’t allow you to make a mistake (as easily) as floats where imprecision just “creeps in”.

            • Womble@piefed.world
              link
              fedilink
              English
              arrow-up
              2
              ·
              edit-2
              21 hours ago

              I fail to see a difference there, 10.0/3 = 3.33333333333 which you round down to 3.33 (or whatever fraction of a cent you are using) as you say for all accounts then have to deal with the leftovers, if you are using a fixed decimal as the article sugests you get the same issue, if you are using integer fractions of a cent, say milicents you get 1000000/3 = 333333 which gives you the exact same rounding error.

              This isnt a problem with the representation of numbers its trying to split a quantity into unequal parts using division. (And it should be noted the double is giving the most accurate representation of 10/3 dollars here, and so would be most accurate if this operation was in the middle of a series of calcuations rather than about to be immediately moving money).

              As I said before, doubles probably arent the best way to handle money if you are dealing with high volumes of or complex transactions, but they are not the waiting disaster that single floats are and using a double representation then converting to whole cents when you need to actually move real money (like a sale) is fine.

              • Treczoks@lemmy.world
                link
                fedilink
                arrow-up
                2
                arrow-down
                3
                ·
                18 hours ago

                I fail to see a difference there

                That I noticed some posts ago. The issue has not changed since then.

                • Womble@piefed.world
                  link
                  fedilink
                  English
                  arrow-up
                  2
                  ·
                  18 hours ago

                  And so instead of explain why and clarify any misunderstanding you chose to snarkily insult my intelligence, very mature.

  • randy@lemmy.ca
    link
    fedilink
    arrow-up
    15
    arrow-down
    1
    ·
    edit-2
    2 days ago

    I got hung up on this line:

    This requires deterministic math with explicit rounding modes and precision, not the platform-dependent behavior you get with floats.

    Aren’t floats mostly standardized these days? The article even mentions that standard. Has anyone here seen platform-dependent float behaviour?

    Not that this affects the article’s main point, which is perfectly reasonable.

    • a1studmuffin@aussie.zone
      link
      fedilink
      English
      arrow-up
      8
      ·
      1 day ago

      Floating-Point Determinism | Random ASCII - tech blog of Bruce Dawson https://randomascii.wordpress.com/2013/07/16/floating-point-determinism/

      The short answer to your questions is no, but if you’re careful you can prevent indeterminism. I’ve personally ran into it encoding audio files using the Opus codec on AMD vs Intel processors (slightly different binary outputs for the exact same inputs). But if you’re able to control your dev environment from platform choice all the way down to the assembly instructions being used, you can prevent it.

      • randy@lemmy.ca
        link
        fedilink
        arrow-up
        4
        ·
        1 day ago

        Thanks, that’s an excellent article, and it’s exactly what I was looking for.

    • nimpnin@sopuli.xyz
      link
      fedilink
      arrow-up
      23
      ·
      2 days ago

      Mostly standardized? Maybe. What I know is that float summation is not associative, which means that things that are supposed to be equal (x + y + z = y + z + x) are not necessarily that for floats.

    • pinball_wizard@lemmy.zip
      link
      fedilink
      arrow-up
      1
      ·
      1 day ago

      The real standard is whatever Katherine in accounting got out of the Excel nightmare sheets they reconcile against.

    • bleistift2@sopuli.xyz
      link
      fedilink
      English
      arrow-up
      2
      arrow-down
      2
      ·
      edit-2
      1 day ago

      If you count the programming language you use as ‘platform’, then yes. Python rounds both 11.5 and 12.5 to 12.