microwavecameraJun 2017Recommends
Short answer, no decimal in binary and math is hard. :) Here's a couple handy videos explaining it: ▶ this video [link]
in “Why do programming languages suck at math?” · View on HN
Floating Point Numbers - Computerphile
Floating Point Numbers - Computerphile on HackerTube: recommended by 2 Hacker News commenters across 2 separate months, 2015–2023.
Computerphile
Open on YouTubeexplainer · intro · evergreen
Tom Scott explains for Computerphile how floating point numbers work, why moving the binary point is fast, and why it handles money badly.
Why Hacker News recommends it
Recommended as a simple, fun explanation of why floating point gives odd errors like 0.1 + 0.2.
- people recommended it
- 2
- separate months
- 2
- strong recommendations
- 0
- discussed on HN
- 2015–2023
“Tom Scott's fun and simple take on Floating Points is a good video explaining why such weird errors happen”
What HN commenters said
3 Hacker News comments link this video. Each one links back to its thread.
felipesabinoNov 2015Recommends
Recommended: Floating Point Numbers - Computerphile ▶ this video Tom Scott's fun and simple take on Floating Points is a good video explaining why such weird errors happen
in “0.30000000000000004” · View on HN
mercxryOct 2023Cites it
You should still not use MONEY in Postgres, even their own website says so [1]. I still wouldn't use floats/numerics/decimals to store currency either in any db generally, as said by others you're going to end up with inaccurate numbers [2]. Therefore using integers is in fact very good for this use-case, especially if you are in accounting or book-keeping! Source: I work for a Fintech company that processes millions of payments. [1] [link] [2] ▶ this video
in “Why you should probably be using SQLite” · View on HN
Topics & tags
Computer architecture & CPUsInformation theory & signal processingfloating pointieee 754binarycurrencycomputerphile