How to Preserve Past Order Details Amidst Customer Information Changes?

I'm facing a scenario in my e-commerce setup where after an order is marked as Done, any subsequent changes made by the customer to their information (like shipping address) are reflected incorrectly in past orders. I stumbled upon a blog post that discusses three solutions in PostgreSQL: 1. denormalizing the Order table 2. using Temporal Tables 3. storing snapshots as JSON blobs. I am keen to understand which of these methods, or any other recommendations you have, effectively tackle this issue while being scalable for a small business setup. I value insights from individuals who have witnessed or implemented these solutions in various company sizes and am interested in learning about what worked or didn't work in your experience. Source [Link](https://dev.to/egorpavlikhin/temporal-tables-or-json-storage-3gbg)