In PostgreSQL, an integer column refuses the text 'lots'. SQLite stores it without a word. Every value carries its own type, and a column's declared type is only a preference. Knowing exactly how that works saves you from some very strange bugs.