SQLite's flexible datatype approach is mentioned in "Distinctive Features Of SQLite"[1], "Quirks, Caveats, and Gotchas In SQLite"[2] and detailed in "Datatypes

SQLite's flexible datatype approach is mentioned in "Distinctive Features Of SQLite"[1], "Quirks, Caveats, and Gotchas In SQLite"[2] and detailed in "Datatypes In SQLite"[3]. I find it surprising that apparently many devs use SQLite without knowing any of this. Pretty much the first thing I try to find out about languages or databases new to me that I might want use is the datatype support. [1] https://www.sqlite.org/draft/different.html https://www.sqlite.org/draft/different.html [2] https://www.sqlite.org/draft/quirks.html https://www.sqlite.org/draft/quirks.html [3] https://www.sqlite.org/draft/datatype3.html https://www.sqlite.org/draft/datatype3.html