Replacing EAV with JSONB in PostgreSQL
TL; DR: JSONB can greatly simplify database schema development without sacrificing query performance. Introduction Here is a classic example of probably one of the oldest use cases in the world of relational databases (database): we have an entity, and we need to save certain properties (attributes) of this entity. But not all instances can have the same set of properties, moreover, in […]