Behalf Of Samuel Neff
> Sent: Friday, February 08, 2008 11:52 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] How to select Strict Affinity or No Affinity
> modes?Attention: DRH
>
> I would like to have strict affinity mode too. In our schemas we use
>
Lite Database
Subject: Re: [sqlite] How to select Strict Affinity or No Affinity
modes?Attention: DRH
I would like to have strict affinity mode too. In our schemas we use
check constraints to enforce strict affinity. Unless you're working in
a dynamic typed environment, I can't imagine why
I would like to have strict affinity mode too. In our schemas we use check
constraints to enforce strict affinity. Unless you're working in a dynamic
typed environment, I can't imagine why you would want to have inconsistent
data within a single database field. Also for consistency with (every?)
I second the strict affinity mode as an optional feature, for the same reasons
as Lee.
A while back I ran into a problem while using the bit and feature of sqlite
and got unexpected results because sqlite changed the type from a 64bit integer
into a real. (I think)... In this case it would
DRH,
">> Can you explain why you think strict affinity mode
>> might be beneficial to you? If somebody can provide a good
>> enough rational to justify strict affinity mode, we might just put it
>> in."
My response to your request for an example of a benefit is that I have
always been an adheren
5 matches
Mail list logo