enums depend on the database. In general they're better than categorical strings...

beckingz on April 29, 2021 | parent | context | favorite | on: Ask HN: Best practices for modeling B-Trees in SQL...

enums depend on the database. In general they're better than categorical strings (varchar columns) if the number of categories is below 256. The primary benefit is data quality (no typos allowed), but performance benefits also exist.