February 24-26, 2027
Montreal, Canada
Databases Conference
The list of presentations is subject to change without notice.
Databases
Covers sharding functions beyond simple modulo and hashing, vertical (split) and horizontal sharding, rebalancing and resharding, and post-sharding reliability considerations. Lessons are drawn from 12 years of working with MySQL at scale and are broadly applicable to other databases. Will discuss considerations for Vitess and TiDB, many of which are likely also applicable to PostgreSQL Neki and other distributed solutions.
Databases
I present an introduction to Aspire and why it is the default foundation for all my new projects. I will cover real-world issues encountered while running it across Windows, macOS, and Linux distros, alongside practical uses for the Community Toolkit. Attendees will learn how Aspire handles local orchestration, how to navigate cross-platform gotchas, and how it impacts deployment pipelines when moving workloads into production.
Databases
Once upon a time, a query triggered a crashing bug. After automated failure handling, the application re-sent the query, and MySQL crashed again. This triggered a cascading failure, which resulted in datastore unavailability. Unfortunately, mistakes made during incident response led to avoidable data loss. This talk covers what happened, how we handled the incident, what we learned, and the infrastructure changes we made to prevent recurrence.
Databases
Event Sourcing is a powerful architectural pattern, but many avoid adopting it due to misconceptions about its complexity.
In this session, we will build the concepts step by step and see how they come together in a working application.
I will cover:
- Events
- Streams
- Reconstructing State
- Building Your First Application
- Common Pitfalls
In this session, we will build the concepts step by step and see how they come together in a working application.
I will cover:
- Events
- Streams
- Reconstructing State
- Building Your First Application
- Common Pitfalls
Databases
Distributed databases promise horizontal scale, but they also introduce operational complexity, consistency trade-offs, and cost. Can replicated single-node systems such as MySQL or PostgreSQL handle most workloads? This talk compares distributed and non-distributed architectures, explains their practical limits, and gives developers a framework for deciding when distribution is essential—and when it is unnecessary.
Databases
Avez-vous déjà poussé une migration BD qui a brisé la prod? Réalisé qu’un autre service brise parce qu’il utilisait votre table? Ou attendu 30 secondes qu’une BD démarre pour rouler vos tests?
Voyons une architecture de pipelines CI qui (1) teste chaque migration avant qu’elle n’arrive en prod, (2) vérifie que tous les services sont compatibles, et (3) accélère les tests d’intégration en fournissant des BD pré-migrées avec Testcontainers.
Voyons une architecture de pipelines CI qui (1) teste chaque migration avant qu’elle n’arrive en prod, (2) vérifie que tous les services sont compatibles, et (3) accélère les tests d’intégration en fournissant des BD pré-migrées avec Testcontainers.
Databases
In this talk, you'll learn what Local-First is and why you may want to choose it instead of the traditional web development model. We'll create a simple web application to showcase how this can be implemented using either SQLite or PGLite and PowerSync or ElectricSQL respectively for the sync with the server.
Databases
Explore how MySQL JSON Duality Views enable developers to work with normalized relational data as flexible JSON documents, combining the precision of SQL with the agility of document-style development.
This session introduces the core concepts, practical use cases and benefits of duality views, demonstrating how they can simplify modern application development without sacrificing data consistency or relational integrity.
This session introduces the core concepts, practical use cases and benefits of duality views, demonstrating how they can simplify modern application development without sacrificing data consistency or relational integrity.
Databases
Developers don’t need another theoretical performance talk. They need to see how real MySQL problems get fixed. In this live-coding session, we’ll transform a slow, poorly tuned application into something fast and production-ready using practical techniques you can apply to your own code.
We’ll cover query rewrites, indexing strategies, EXPLAIN plans, schema tweaks, and modern MySQL features that improve performance.
We’ll cover query rewrites, indexing strategies, EXPLAIN plans, schema tweaks, and modern MySQL features that improve performance.
Databases
Data engineering involves repeating patterns: ingesting, transforming, storing, and serving data all follow the same recipe. Many teams have opted to create an in-house framework, with mixed results. Now, with AI coding assistants, some may see these as obsolete, since ETLs can now be built in minutes. Or should we instead write better, more robust, and agile frameworks? This talk will explore the "why" and the "how" of building your own.
Databases
Choosing a database is one of the most important architectural decisions we need to make as software developers — and the options have never been more plentiful. From the relational to key-value, from row-based to columnar, from SQL to NoSQL, we will examine some of the database technologies currently offered through the lens of the design choices and tradeoffs they make.
Databases
Your job is simple: make the ultimate AI oracle that can answer any question by querying every data source in your org. But your users don't even want it - they want to connect their own AI. Enter ontologies: detailed maps of your data and what it means. Join us and learn to shed light on dark schemas, surface better insights and make a truly great AI oracle. You'll make something that's not only useful, but something they'll pay for as well.
Databases
In this presentation we will look at how to deal with time zones. This will particularly be relevant due to the changes in Canada with Daylight Saving Time.
We will see how it is hard to make assumptions on how they work, and explain how they came into existence. We'll focus mostly on how to handle them from within PHP, as well as how we (should) store them in databases. We'll also have a quick look at date manipulation when querying data.
We will see how it is hard to make assumptions on how they work, and explain how they came into existence. We'll focus mostly on how to handle them from within PHP, as well as how we (should) store them in databases. We'll also have a quick look at date manipulation when querying data.
Databases
Vector search is moving from specialized systems into mainstream databases such as PostgreSQL, MySQL, MongoDB, and Elasticsearch. This talk explains how embeddings are created, stored, and indexed; when to combine vector and traditional search; and how to measure speed and result quality. Attendees will gain practical guidance for choosing an architecture and building effective AI-powered search applications.
Databases
Imagine anyone in the business asking questions of the database like they're talking to a person. No SQL. No ticket. No waiting for a developer.
We built it: an MCP with read only DB access that hid PII. Every client who has tried it is hooked.
But AI also finds fool's gold. I'll show how to build one, how to stop confident wrong answers (well, most of them), and how to turn the best questions into trusted reports.
We built it: an MCP with read only DB access that hid PII. Every client who has tried it is hooked.
But AI also finds fool's gold. I'll show how to build one, how to stop confident wrong answers (well, most of them), and how to turn the best questions into trusted reports.
© 2010-2026 ConFoo. All rights reserved. Code of Conduct
Cookie Consent
To provide the best experiences, the usage of cookies are necessary. Some are essential for the proper functioning of the site, while others help us better cater to your interests.