In PostgreSQL a varchar is also a text type column but with an added length check. So it's actually just slower to insert and not more space efficient, as far a

In PostgreSQL a varchar is also a text type column but with an added length check. So it's actually just slower to insert and not more space efficient, as far as I know. So SQLite is not alone in this.