Hacker News Reader

Comment by jitl | Hacker News Reader

The OP failed to mention that SQLite does have opt-in strict tables that enforce types, you just need to do `CREATE TABLE name (stuff TEXT) STRICT`, see https://www.sqlite.org/stricttables.html

Like journal mode being ROLLBACK by default instead of WAL, foreign key constraints being off by default, tables being lax by default is part of SQLite’s dedication to backwards compatibility.

View on HN

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

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