Hacker News new | ask | show | jobs
by throw_away_623 148 days ago
Postgres supports enum that would fit this use case well. You get the readability of text and the storage efficiency of an integer. Adding new values used to require a bit of work, but version 9.1 introduced support for it.