News for hackers. Stuff that matters.
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?
Re:Rethinking Database Programming by mike_hearn on Wednesday August 19, 2026 @04:08AM (#49358523)
You get a type error from the database.
Re:Rethinking Database Programming by bazoom42 on Wednesday August 19, 2026 @11:50AM (#49363164)
As far as I can tell, some engines will implicitly coerce types so “7” = 7
Re:Rethinking Database Programming by moljac024 on Thursday August 20, 2026 @03:37AM (#49371567)
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.