Messy data != Messy code / Dropping ACID: Schema design for e-commerce


Details
We're not going to let a pandemic stop us. This time we'll be pushing Symfony straight into your living rooms, with our first ever online event.
Please note You must register via the gotowebinar link beforehand to receive your unique attendee URL. If you're sharing this event with a friend, they must also register to receive their own link: https://attendee.gotowebinar.com/register/1941991927655624971
We have two amazing speakers lined up for this special Coronavirus edition of the UK Symfony meetup:
Michelle Sanver from Liip (https://www.liip.ch/en), who is a seasoned conference speaker and implementer of PSR-8, will guide us through how her team built a clean architecture to collate data from different sources, keeping it manageable for years to come in her talk "Messy data != Messy code".
Follow Michelle at https://twitter.com/michellesanver/
Andreas Braun, driver engineer at MongoDB (https://www.mongodb.com/) and maintainer of the Doctrine ORM, will give us insight and advice on strategies for designing more efficient database schemas by using features we often overlook in "Dropping ACID: Schema design for e-commerce".
Follow Andreas at https://twitter.com/alcaeus/
As ever, there are prizes to give away. This month we have Jetbrains licences, and Matthias Noback has very generously donated two digital copies of his new book, "Object Design Style Guide". Make sure you're there to be in with a shot of winning...
We'll kick off at 18:00. You'll need to supply your own beer and pizza this time!
Video infrastructure for the meetup is kindly provided by Spinks (https://www.wearespinks.com/), with additional support by Stack Overflow Talent (https://stackoverflow.com/talent/en).
Additional raffle prizes are kindly sponsored by Level 5 (https://level5.co.uk).
Thanks to MyBuilder (https://mybuilder.com) for organisational support.
Messy data != Messy code
The role of our API in Switzerland is to consume a lot of data that was not meant for a digital age and to transform it into beautiful output, for one of the biggest retailers in Switzerland. This is a journey of consuming a lot of data and APIs from different sources and in different formats. Some of them made us laugh, some of us got migraines. We built a smooth architecture to consume and output data. I am proud of our architecture that we seamlessly upgraded to keep the latest versions, now Symfony 4 along the way. I want to share with you how we managed to keep this API up to date for over 5 years and the architecture that we use to make it happen.
Dropping ACID: Schema design for e-commerce
When designing a schema for e-commerce applications, we have to keep certain things in mind: data retention rules require duplicating large chunks of data, leading to complex schemas in any relational database. Modern database systems can help us solve this problem, but we seldom use their features when designing schemas. In this talk, we will take a look at some strategies on how to design more efficient schemas for certain database systems, and how to effectively drop ACID at work.

Messy data != Messy code / Dropping ACID: Schema design for e-commerce