September 2021: How denormalizing our Postgres turned great
hosteado por Josep Egea Sánchez en Twitch (Virtual) www.twitch.tv, 30.09.2021 a las 19:30Evento Online https://twitch.com/madridrb
Temas
How 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.
Participantes: (30)
Josep Egea Sánchez
Eventos: 60
Temas: 8
Sabre
Eventos: 1
Temas: 0
Quentin de Metz
Eventos: 1
Temas: 1
Nacho Abad
Eventos: 5
Temas: 0
Fernando García Samblas
Eventos: 35
Temas: 1
Samuel Jervier
Eventos: 1
Temas: 0
Ismary Cruz
Eventos: 13
Temas: 1
Thomas Romera
Eventos: 1
Temas: 0
Terral Guillaume
Eventos: 1
Temas: 0
Emilie paillous
Eventos: 1
Temas: 0
Alejandro Hoyos
Eventos: 1
Temas: 0
Moaz Khalifa
Eventos: 1
Temas: 0
Lucas Bonin
Eventos: 1
Temas: 0
Alex Fernández
Eventos: 1
Temas: 0
Zeus Perez
Eventos: 2
Temas: 0
Romain Péchayre
Eventos: 1
Temas: 0
Benjamin Lefevre
Eventos: 1
Temas: 0
Alfonso Alba
Eventos: 33
Temas: 3
Gavaar
Eventos: 5
Temas: 0
ponkt
Eventos: 1
Temas: 0
marandasojo
Eventos: 9
Temas: 0
Gabriel Engel
Eventos: 1
Temas: 0
Iván González
Eventos: 3
Temas: 0
Carlos I. Peña
Eventos: 1
Temas: 0
Mathieu Sanchez
Eventos: 1
Temas: 0
Juan Esparza
Eventos: 1
Temas: 0
Benjamin Darcet
Eventos: 1
Temas: 0
Martin Cabrera
Eventos: 42
Temas: 0
Manuel Molina Cuberos
Eventos: 9
Temas: 0
Omar Alvarez
Eventos: 1
Temas: 0