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.

This is a static site. If you have any comments please start a thread in the fediverse and tag me or send an email.