Hacker News new | ask | show | jobs
by nasretdinov 16 days ago
The only really confusing part to me is that SQLite has separate STRING and BLOB type.ls. I always thought SQLite only really supports INTEGER, REAL and TEXT (aka BLOB) types. And even then the types aren't enforced. So it's really interesting to see that you still somehow can distinguish TEXT from BLOB for example.

P.S. I meant default settings -- I know that strict mode, etc, exists, but it's not the default, so few people change it