SQLite datatypes are advisory so it pretty much just accepts anything you give it.

PostgreSQL definitely says no to schema violations.

These are both features.