[bind10-dev] Enum types, was Adding another index to the records SQLite3 table

[Stephen Morris]

On 02/10/12 15:24, Shane Kerr wrote:
> Both PostgreSQL and MySQL have an ENUM type, so at least in those 
> cases we can get the benefits of both text for readability and 
> integers for speed (I think). SQLite is too "lite" for this, of 
> course....

What I've seen done in other places is to use integers, but have a
separate two-column lookup table that relates the numeric value to a
text string.

If people just want a readable form of the table, provide a view that
joins it with the lookup table.

Stephen