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