Adding a non-nullable TEXT field

[Ruslan Zasukhin]

On 8/13/14, 5:54 PM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:

> For now any Valentina's TEXT field is nullable. You can not make it not-null
> (your "not null" was ignored.).
> We just thought it is no reason to have not-nullable text/blob/picture fields.
> Internally, empty data takes one blob-segment but null-data takes zero
> segments. On the other hand "not null" is sort of constraint which can be
> required by your business logic. Probably we have to allow not-nullable
> BLOBs...

I think I don't agree :)

Yes 10K records  with NULL  -- 1 bit per record

10K records with 1 empty segment size, e.g. 128 bytes
    1Mb on disk 

Sense?


I think BLOB field if very needed can coupled with a BIT field to simulate
this NULL.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]