3 ms·

> 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.

• jitl 2y ago
  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.
  • avinassh 2y ago
    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
    • ghusbands 2y ago
      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.