Quentin de Metz stellt das Thema vorHow denormalizing our Postgres turned great
It's often considered best practice to normalize the database structure to avoid data redundancy and incoherence.
In Pennylane's accounting platform we've found that this actually does not always help with data coherence, and even introduces additional complexity in managing data access.
Our combination of denormalizing some of our data, enhancing some of ActiveRecord's methods, and introducing default behaviors in our application models has enabled us to greatly simplify access control management and given us confidence that our production data is in a consistent state.
