Lætitia Avrot est Field CTO pour EDB. Elle a commencé son aventure Postgres en 2007. Elle a rapidement dû apprendre aussi le métier de DBA Oracle et SQL Server. Elle s'est beaucoup amusée sur des projets à fortes contraintes de haute disponibilité, des pannes en production, la mise en place de plan de reprise d'activité, la répartition de charge, les données géographiques... Elle est impliquée dans la communauté en tant que trésorière de PostgreSQL Europe, co-fondatrice de Postgres Women et contributrice reconnue du projet PostgreSQL.

• Twitter
• Linkedin
• Blog

2023 -Chasing unicorns : 0 dataloss and 99.999% availability

• ► Vidéo
• #TALK

If you're a database architect, you've already encountered a situation when you ask for RTO and RPO and people answer they don't want any data loss and downtime is not an option either. If you discuss with people aware of the CAP theorem, they will temper their demands by asking for 99.999% availability, emphasizing they didn't ask for the impossible 100%... In this conf talk, we'll explore the CAP theorem, what it means for RDBMS and what tradeoffs need to be made. Then we'll explore several practical use cases and we'll try to classify their data loss and availability.

2022 -Meet NULL the UNKNOWN

• ► Vidéo
• #TALK

NULL in SQL is a pretty tricky concept. Wether you think you know it all or you admit that you could learn some things about it, come see this talk!

After some explanations, this session will turn into a crazy quiz and I challenge you to achieve a faultless performance!