Hacker News Reader

Parent Full thread

avinassh

> The OP failed to mention that SQLite does have opt-in strict tables

I did not, but probably I did not phrase correctly:

> Strong typed columns are opt-in.

View on HN

You write:

> 18. I hate that it doesn’t have types. It’s totally YOLO:

In the point where you say that you didn’t mention STRICT mode, which seems to directly address your complaint.

That sentence builds up on the previously mentioned sentence about types.

> It is “weakly typed”. SQLite calls it “type affinity”. Meaning you can insert whatever in a column even though you have defined a type. Strong typed columns are opt-in

and then I call it

> I hate that it doesn’t have types. It’s totally YOLO

That's simply self-contradictory, as written. You say that it has (opt-in) types, then say that it doesn't have types. You could say "I hate that it doesn't have types by default", but it would be even more accurate to say "I hate that it doesn't enforce types by default", since it does have types, both strict and not.

Reply on news.ycombinator.com