https://vickiboykis.com/2026/02/21/querying-3-billion-vectors/ #HackerNews #VickiBoykis #treasureHunt #techJourney #floatingPoint #HackerNews #ngated
Programming vlog 0x01 - Figuring out fixed point maths

0.1 + 0.2 In SQL = 0.30000000000000004?!
SQL floating point precision is broken! Adding 0.1 + 0.2 creates a number with precision errors. This breaks financial calculations! Watch!
#sql #sqltricks #database #sqltutorial #floatingpoint #precision #sqlquiz #codingchallenge #sqlshorts #sqlbugs #numericprecision #sqlwtf

Another excellent post 👌🏽 from Russ Cox 👇🏽🫡:
“Floating-Point Printing And Parsing Can Be Simple And Fast” (https://research.swtch.com/fp).
On HN: https://news.ycombinator.com/item?id=46685317
On Lobsters: https://lobste.rs/s/nbsclr/floating_point_printing_parsing_can_be
#Programming #Math #FloatingPoint #Numbers #PLDI #Parsing #Printing
🚀 New on Johnny’s Software Lab: Handling floating-point errors in C++ without killing performance!
NaNs, infinities, sticky bits, and traps — what works and what’s a trap 🪤.
Read more: https://johnnysswlab.com/floating-point-error-handling-in-c-what-actuall

Floating-point errors are unavoidable, but how you detect and handle them can make the difference between clean, high-performance C++ code and a debugging nightmare. In this article, we explore the practical techniques for handling NaNs, infinities, and other FP errors — from manual checks to sticky bits and hardware traps — and reveal which approaches actually work without sabotaging performance.
Learn about numeric data types (and the number 998,001) in Python
The value 1 / 998,001 has an interesting property, but to see it in Python you need to learn about numeric data types.
Проектирование FPU блока, работающего на частоте 7 ГГц
Данный проект представляет собой современный вычислительный блок, предназначенный для обработки научных и графических данных на сверхвысокой частоте 7 ГГц . Архитектура построена на базе 128-битных векторов и 5-стадийного конвейера.
[[Russ Cox] 부동 소수점 변환의 혁신: 더 쉽고, 더 빠르며, 더 간단하게
Russ Cox가 제안한 새로운 부동 소수점 변환 알고리즘은 기존 알고리즘보다 단순하고 성능이 뛰어납니다. 'Unrounded Scaling'이라는 핵심 프리미티브를 통해 2진수와 10진수 변환을 가속화하며, Go 1.27에 포함될 예정입니다.
https://news.hada.io/topic?id=26107
#floatingpoint #algorithm #performance #go #unroundedscaling
Conditions in the Intel 8087 floating-point chip's microcode
https://www.righto.com/2025/12/8087-microcode-conditions.html
#HackerNews #Intel8087 #FloatingPoint #Microcode #Technology #History #ComputerArchitecture
How to Stop Floating Point Money Bugs
0.1 + 0.2 is not 0.3 in JavaScript.
