Re:Rethinking Database Programming
by bazoom42 on Wednesday August 19, 2026 @03:45AM
(#49358304)
What happens if a query compares a string to a number?
[ Parent
| on HN ]
Re:Rethinking Database Programming
by mike_hearn on Wednesday August 19, 2026 @04:08AM
(#49358523)
You get a type error from the database.
As far as I can tell, some engines will implicitly coerce types so “7” = 7
But when do you get that type error?
This is the important bit.
You get it after the app is deployed, the query is ran and a result is expected.
When do I get a type error from my language if it's statically typed? That's right, before I even deploy.