February 22-24, 2023
Montreal, Canada

Databases Conference

Databases Découvrez comment nous avons bâti un système pour gérer les stats d’un système e-commerce. La solution est capable d’ingérer et de calculer les stats, de manière scalable. Découvrez pourquoi nous avons choisi Elasticsearch et comment nous l’utilisons. Vous découvrirez aussi les problèmes que nous avons vécus et comment nous les avons contournés.
Databases In software development, change is pretty much the only constant factor. In fact, embracing change is one of the twelve principles behind the Agile Manifesto. However, changing event sourced applications can be very challenging.

In this talk, we’ll explore how to deal with projection updates, event updates and versioning, and existing privacy legislation (such as the GDPR).
Databases In this presentation, we will explore this seemingly simple aspect of working with database in details. We will talk about how to group queries together in the meaningful way so you’re not overwhelmed with amount of details but find the right queries to focus on. When you should focus on tuning specific queries or when it is better to focus on tuning the database. We will also look at other ways to minimize user facing response time.
Databases One of the perks of joining Microsoft's Azure SQL team is being granted the opportunity to learn about inner workings of SQL Server.

Frankly, not only did I learn them, but I'm happy to share them!

We will talk about Pages, Extents, Indexes, Transactions and how it all works under the hood.

Oh, and did I mention that lots of it is true for other Relational DBs as well?
Databases Les bases de données savent gérer des colonnes JSON depuis des années déjà, et
ces colonnes permettent d'accélérer le développement en simplifiant le code, les
migrations, et la maintenance.

À travers cette présentation, nous allons voir comment étendre Doctrine pour
avoir le meilleur des deux mondes : des colonnes en JSON, et des objets PHP
fortement typés.
Databases Architecting a perfect resilient Kubernetes based Kafka deployment requires careful consideration of several edge case scenarios.
In this session, you will learn about :
Successful disaster recovery strategies in Kafka ecosystem like Active-active, Active-passive replication, multi regional stretched clusters etc.,
* How some of these DR techniques evolve, when Kubernetes is the chosen deployment platform
* Related Automation or CI/CD tools
Databases Vitess (vitess.io) is a framework built on top of MySQL for horizontally scaling MySQL. It was designed at Google for scaling YouTube through hyper-growth and has since then been release to Cloud Native Compute Foundation (CNCF) were it is considered a "graduated project".

I will guide you through the basic architecture and the most important components and features.
Databases Beer brewing can be fun, but combining brewing with IoT device hacking is even more fun. It is possible to connect and collect data about almost anything, including the fermentation process inside a closed fermenter using open source technologies. In this presentation, the speaker will introduce basic concepts of IoT devices, how to collect the data efficiently and how to use various tools to store, extract and manipulate that data.
Databases Database mistakes are easy to make. Join us and learn from mine! From poor schema design to lock contention and botched migrations, you'll learn about database traps and how not to fall into them. You'll learn where databases are the best choice and where they aren't and how to fix mistakes early so they don't haunt you forever. Whether you're a beginner or an experienced DBA, hearing about my missteps will help keep you on the safe path.
Databases Backups are important! Everyone makes mistakes, bugs are easily overlooked, hardware will fail eventually. If you don't want to lose data when disaster strikes, your backups will be your saviour. In this talk I will guide you through some of the most common backup techniques for MySQL that we use in 2023. I will explain the strengths and weaknesses of each solution.
Databases In this session, we discuss storing JSON in our database and how the tools in MySQL can make that task a bit easier. We will start with a discussion of why you might want to store data as JSON. We will then demonstrate how you can store/update/retrieve JSON data stored in a relational database table. Lastly, we talk about how we can use relational data as JSON and vice versa.
Databases 2022 was an exciting year in the open source database industry, with more choice, more cloud, and key changes in the industry. We will dive into the key developments over 2022 and new ones of 2023, including the most important open-source database software releases in general, the significance of cloud-native solutions in a multi-vendor, multi-cloud world, the new criticality of security challenges, and the evolution of the open source industry.
Databases While PostgreSQL is a mature database, it packs a punch when it comes to features. This is a talk to talk about various features of PostgreSQL like.
* Crosstab queries (Pivot Table)
* Window functions
* JSON operations
* Full text search queries
* Row level security
Databases Redis sait faire bien plus que du stockage clé/valeur simple.
Grâce à des structures de données évoluées et a ses performances hors du commun,
il devient un allié très puissant à ajouter dans sa stack préférée.

A travers une série d'exemples, des trucs & astuces, nous verrons comment
utiliser Red

Explore all 152 sessions