Good Morning Bubblers,
Currently, I’ve got about 15 data types (I’m using “tables” and “data types” to refer to the same thing here). I have different data types (tables) for donors, the items they’ve donated, donor history, contact history, etc.
Due to reporting issues out of Bubble, and the need for third-party integrations on a transactional level, I’m wondering about the ease of reporting from normalized data tables (separated based on content) vs a monster table (all columns/fields in one table).
From a hierarchy standpoint, data cleanliness, and database efficiency, I understand that normalization is the best practice, but I’m wondering if it’ll cut down on the number of transactions, and merging required to produce an output for my end users.