Information is visible only for attendees

Topics

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.

Attendees: (30)

Organizer

Josep Egea Sánchez
Events: 60
Topics: 8

Sabre
Events: 1
Topics: 0

Quentin de Metz
Events: 1
Topics: 1

Nacho Abad
Events: 5
Topics: 0

Fernando García Samblas
Events: 35
Topics: 1

Samuel Jervier
Events: 1
Topics: 0

Ismary Cruz
Events: 13
Topics: 1

Thomas Romera
Events: 1
Topics: 0

Terral Guillaume
Events: 1
Topics: 0

Emilie paillous
Events: 1
Topics: 0

Alejandro Hoyos
Events: 1
Topics: 0

Moaz Khalifa
Events: 1
Topics: 0

Lucas Bonin
Events: 1
Topics: 0

Alex Fernández
Events: 1
Topics: 0

Zeus Perez
Events: 2
Topics: 0

Romain Péchayre
Events: 1
Topics: 0

Benjamin Lefevre
Events: 1
Topics: 0

Alfonso Alba
Events: 33
Topics: 3

Gavaar
Events: 5
Topics: 0

ponkt
Events: 1
Topics: 0

marandasojo
Events: 9
Topics: 0

Gabriel Engel
Events: 1
Topics: 0

Iván González
Events: 3
Topics: 0

Carlos I. Peña
Events: 1
Topics: 0

Mathieu Sanchez
Events: 1
Topics: 0

Juan Esparza
Events: 1
Topics: 0

Benjamin Darcet
Events: 1
Topics: 0

Martin Cabrera
Events: 42
Topics: 0

Manuel Molina Cuberos
Events: 9
Topics: 0

Omar Alvarez
Events: 1
Topics: 0