Información solo visible para los participantes

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)

Organizer

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