On 8/27/2015 10:06 AM, Nicolas J?ger wrote: > so the only reason to define datatype in sqlite is for the size on > the disk ?
I don't quite see how size on disk has anything to do with it. The main reason to define the column data type is to establish column affinity. > so why not just only using `BLOB` (excepted for `INTEGER PRIMARY > KEY`) ? Feel free to. I'm not sure I understand the question. > being less persmissive wouldn't make querries run faster ? I don't know. I don't have a clone of SQLite that's just like existing SQLite only with rigid type system, with which to compare. -- Igor Tandetnik