Floating Point Numbers - Computerphile
Computerphile2 HN recommenders · 2015–2023
2.5M views · explainer · evergreen · Uploaded 2014-01-22
Tom Scott explains for Computerphile how floating point numbers work, why moving the binary point is fast, and why it handles money badly.
Recommended as a simple, fun explanation of why floating point gives odd errors like 0.1 + 0.2.
19:42But what is the Fourier Transform? A visual introduction.
3Blue1Brown
23:53D/A and A/D | Digital Show and Tell (Monty Montgomery @ xiph.org)
FL Studio
6:538-bit computer update
Ben Eater
1:21:22Light Years Ahead | The 1969 Apollo Guidance Computer
TNMoC
27:25“Hello, world” from scratch on a 6502 — Part 1
Ben Eater
47:52Finding the Missing Memristor - R. Stanley Williams
The Qualcomm Institute
1:01:07The Ultimate Game Boy Talk (33c3)
media.ccc.de
1:48:55The Thirty Million Line Problem
Molly Rocket
3 comments from Hacker News
Recommended: Floating Point Numbers - Computerphile [VIDEO] Tom Scott's fun and simple take on Floating Points is a good video explaining why such weird errors happen
Short answer, no decimal in binary and math is hard. :) Here's a couple handy videos explaining it: [VIDEO] [LINK]
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] [VIDEO]