Typeless is the default though? Why wouldn't you want the types to be reliable w... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

seanwilson on May 9, 2022 | parent | context | favorite | on: I'm all-in on server-side SQLite

Typeless is the default though? Why wouldn't you want the types to be reliable when you're reading/writing from the backend in the general case?

mbreese on May 9, 2022 [–]

I believe typeless is the default because of largely historical reason. Namely, typeless was the original mode and strict mode was added later. But, that’s not the only reason. There is a whole page on why typeless is a feature and not a bug.

https://sqlite.org/flextypegood.html

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact