Nicolas Williams wrote:
> On Wed, Sep 02, 2009 at 05:44:38PM -0400, Shaun Seckman (Firaxis) wrote:
>
>> I'm just curious how difficult it would be to add
>> support for booleans in SQLite. This would most likely involve adding a
>> new type affinity as well as adding "true" and "false" keywords to the
>> lexer. There's much more that could be done but I'm just looking for
>> rudimentary support.
>>
> ...
>> I would just like to reduce some memory
>> overhead as well as use those keywords instead of creating integer
>> fields using 0 and 1.
>>
>
> SQLite3 uses a variable length encoding for integers on disk, so you
> will gain no space on disk by having a native boolean type.
And according to http://www.sqlite.org/fileformat.html#record_format,
there's even a special optimization for the integers 0 and 1.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
