Planet PostgreSQL – Radim Marek: We need to talk about ENUMs

Designing a database schema, whether for a new application or a new feature, always raises a lot of questions. The choices you make can have a big impact on how well your database performs and how easy it is to maintain and scale. Whether you’re just getting started with PostgreSQL or consider yourself a seasoned pro, it’s easy to rely on old habits or outdated advice. In this article, I want to take a fresh look at one of those topics that often sparks debate: the use of ENUMs in PostgreSQL.
I have to admit, not so long ago, I would advise “don’t use ENUMs” without thinking about it too much. Relying only on random articles and…

External feed Read More at the Source: https://postgr.es/p/6CK