On 31 Oct 2017, at 12:54pm, Eugene Mirotin <emiro...@gmail.com> wrote:
> This field is actually boolean, but also nullable. From other languages > (like Python and JS) I actually assumed the NULL check is faster than value > comparison. In SQLite, NULL, 0 and 1 are all special cases and take the same amount of filespace/memory to store. > Will improve later (for now it's definitely not a bottleneck). Agreed. If that bit of your program is already in place, and you understand the problems of doing logic with NULL values, then it’s not a priority. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
