[Nottingham] SQLite and 'locking'

Martin martin at ml1.co.uk
Tue Feb 27 12:35:17 GMT 2007

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?


Martin Lomas
martin at ml1.co.uk

More information about the Nottingham mailing list