[Nottingham] SQLite and 'locking'

Michael Erskine msemtd at yahoo.co.uk
Tue Feb 27 13:53:51 GMT 2007

On Tuesday 27 February 2007 12:35, Martin wrote:
> > 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?

You wouldn't have any status field(s): you would have a "seat_problems" 
or "seat_info" table that would list all problems with all seats and that has 
a foreign key pointing back to the id of the seat.

Michael Erskine.

Riffle West Virginia is so small that the Boy Scout had to double as the
town drunk.

All New Yahoo! Mail – Tired of Vi at gr@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html

More information about the Nottingham mailing list