SQLite more laid back than the D-O-double-G
SQLite only supports a simple set of data types and the only one that really matters is "INTEGER PRIMARY KEY" so you can have it auto-increment. In fact, by default, I can declare the columns as anything I want and it doesn't even throw a warning.
sqlite> CREATE TABLE t2(c1 wtf, c2 yomama); sqlite> INSERT INTO t2 VALUES(1, 'blah'); sqlite> SELECT * FROM t2; 1, blah
This is all documented and explained so I can't complain to much but it's still an interesting concept.