DatabasesSee 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
DatabasesThis session is interactive! There isn’t time to leave everything from your own mistakes. In this session we will share disaster stories related to data and what we learned or changed as a result of those disasters. I have my own lessons learned but working as a technical trainer I learned a lot from others mistakes as well. Come to learn or to share!
DatabasesAs 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.
DatabasesThe 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.
DatabasesDid 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.
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.
DatabasesIn 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.
DatabasesDid 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.
DatabasesDo 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.
DatabasesSince 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
DatabasesValkey 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.
DatabasesThis 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.
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.