[sic] is a community about everything that piques your curiosity and interest Read about getting an account here.
The marching cubes one is simply amazing... here you go from a bunch of 3D points into imaging the human body in 1987.
What are some applications for this scale of integer multiplications? Statistical models?
sqlite3 is older than the current type system usage trends. There were strongly typed languages back then, but it was for niche/research uses. People wrote in C. That's why it provides those little helpers and it's not absolute about types. I bet if it was written with say, Ocaml it would be strongly typed from the get go.
I want everything typed but I'm not a polemic. Sqlite has chosen to be a raw bytes database with some metadata and checks on top to help you type those bytes if you want. Application logic can have control over the data's type validity. Adding types to sqlite3 is just another layer of logic that might even duplicate effort.
Let's scratch that itch!
In src/build.c:1046 the parser checks the validity of an object (table, index, view or trigger). If writable_schema=ON it skips the error checks in the CREATE TABLE statement. Dangerous but convenient. If the schema is corrupt, these checks wouldn't catch it.
Weirdest book contenders: