[Nottingham] SQLite and 'locking'

[Martin]

Martin Garton wrote:
> On Tue, 2007-02-27 at 11:59 +0000, Martin wrote:
>>
>> Then it's a simple case (later) to add new status options for additional
>> states such as seat broken, seat too dirty, baby seat, oversized seat,
>> ... all without breaking too much of the existing code.
> 
> How do you indicate a dirty baby seat?

Use a bit field instead of enumerating, or even add more enumerations...?


> In general i strongly dislike "status" fields and prefer separating
> things into different fields in all but the most trivial of cases.

Which is the more expensive: One column of enumerations or multiple
columns of flags/counts?


Cheers,
Martin

-- 
----------------
Martin Lomas
martin at ml1.co.uk
----------------