PostgreSQL Data Modeling: Comparing Lookup Tables vs Enum Types for Limited Value Columns
This article explores three data models for strings with few distinct values: a simple string, a lookup table or an enum type.
Read the full articleYou might also wanna read
Different ways to Search Text in PostgreSQL
A guide to choosing between iLIKE, full-text search, trigrams, and vector embeddings for your data
The Gold Standard, Evolved: What's New with PostgreSQL and Why It's Still Your Go-To Database
A journey through the PG Ecosystem since 2020
SQL Basics: Keywords, Data Types, and Operators Explained for Beginners
A technical guide published on DEV Community covers the foundational building blocks of SQL, including reserved keywords, data types, and op
Engineers Detail Technical Hurdles of Rewriting PostgreSQL Database Engine in Rust
Developers attempting to rewrite PostgreSQL in Rust have documented significant technical challenges, including a 12–15% CPU overhead introd
Is software immortal? And can we hide columns in Postgres?
Creating users with no access to certain columns in PostgreSQL tables
Go Value Objects Aren’t Verbose. They’re Bullet Armor.
When you stop using primitive strings for email, price, and userId — and start using Go types — an entire class of data corruption bugs… Con
Comments
Sign in to join the conversation.
No comments yet. Be the first.