February 26-28, 2025
Montreal, Canada

Databases Conference

The list of presentations is subject to change without notice.
Databases See a demonstration of how developers can quickly build microservices with Micronaut and GraalVM Native Image. Discover how combining GraalVM Native Image and Micronaut can lead to efficient, highly performant, and optimized applications targeting environments like Kubernetes or serverless platforms. Learn to access an Oracle Autonomous Database (ADB) using the Micronaut framework with Micronaut Data—and how to use Micronaut, AOT, and GraalVM
Databases There isn’t time to learn everything from your own mistakes. Every disaster story provides a lesson we can use to do better next time. In this interactive session, I'll share my disaster stories related to data and I want you to share your as well. Come to learn or to share! We can all commiserate over the horror stories and all leave a little wiser!
Databases As a Data Engineer, optimizing database performance is crucial. This talk covers factors affecting query performance, including the database engine, data structures, algorithms, query optimizer, indexes, and data access methods, along with hardware innovations. You'll leave with practical insights to make informed decisions, boost performance, and minimize costs for your team’s operations.
Databases The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behavior.
Databases Did you know you can use JavaScript to create stored functions and stored procedures in MySQL? Join me in this session where we will discuss the benefits of using JavaScript to create stored functions and procedures, give a high-altitude overview of how JavaScript is converted to a language MySQL can understand, demonstrate multiple examples, and show some debugging techniques.
Databases In IT, efficiency is everything.

How did a single team at OVHCloud reduce its critical databases infrastructure size from 390 machines to just 27 by still dealing with the same amount of databases?

In this talk, you’ll learn the importance of efficient database design and how you can increase performance and decrease workload to ensure your information system is ready to scale with your business.
Databases In this talk, you’ll learn what the difference is between Local-first and Offline-first and why you may want to choose local-first instead of the traditional web development model. We'll dig into how WebAssembly can help as we create a simple web application that uses Postgres in the browser via PGLite. For the data sync with the server, we'll use ElectricSQL.
Databases Did you know you can run MySQL on a Raspberry Pi and replicate the data to the cloud?

In this session, we will cover how to install MySQL on a Raspberry Pi, give a brief overview of how to store data on this MySQL instance, demonstrate an application that can visualize that data, and finally, how you can replicate that data to a MySQL instance running in the cloud.
Databases Do you store data in a MySQL or PostgreSQL database in JSON? One of the more amazing functions is JSON_TABLE(), which temporarily lets you transform that data from JSON into a relational table for processing with SQL (Aggragates, CTE, Windowing Functions, comparators). Great news, eh? Well, the bad news is that the documentation is not exactly helpful, and there are more than a few tricks to make life easier that you will see in this session.
Databases Since the creation of my presentation, Postgres and the Artificial Intelligence Landscape, artificial intelligence use has exploded, with much anticipation about its future. This talk explores many of the advances that has fueled this explosion, including multi-dimensional vectors, text embeddings, semantic/vector search, transformers, generative AI, and Retrieval-Augmented Generation (rag). It then covers how databases and how the valuable data
Databases Valkey is less than a year old but has come as a strong replacement for Redis (they changed to a non-open source license). Valkey is an open-source in-memory storage, used as a distributed, in-memory key–value database, cache and message broker, with optional durability. Valkey is memory-based, and because of its design, Valkey offers low-latency reads and writes, making it particularly suitable for use cases that require a cache.
Databases This talk explores the evolving landscape of vector search in databases, a significant shift in data retrieval. Once limited to specialized systems, vector search is now being integrated into mainstream databases like PostgreSQL, MySQL, and Elasticsearch. We'll cover vectors, embeddings, indexing strategies, hybrid search approaches, and performance metrics, offering insights into vector search impact on data retrieval and AI apps.

Explore all 191 sessions