How can I speed up a SQL query? This video showcases how to optimize a SQL query on MySQL or PostgreSQL for free using AI and a tool called EverSQL by Aiven. In the example shown, the query performance on a MySQL database went from 20 seconds to 0.5 seconds only by pasting the SQL and additional metadata in the EverSQL by Aiven UI and applying the indexes and SQL rewrite suggestions. Check out these resources to learn more:(links to any tools or resources you used in the video, our docs/trial if appropriate)

What's in the Workshop Recipe? Apache Kafka is the industry de-facto standard for data streaming. An open-source, scalable, highly available and reliable solution to move data across companies' departments, technologies or micro-services. In this workshop you'll learn the basics components of Apache Kafka and how to get started with data streaming using Python. We'll dive deep, with the help of some prebuilt Jupyter notebooks, on how to produce, consume and have concurrent applications reading from the same source, empowering multiple use-cases with the same streaming data.

During this webinar, our product team discusses: Speakers: Bob Krygowski | Product Director, Platform Filip Yonov | Product Director, Streaming John Kennedy | Product Director, Databases AIVEN DATA PLATFORM The Aiven Platform is more than a collection of open source services for streaming, storing and analyzing data. The platform ensures that all services run reliably and securely in the clouds of your choice, are observable, and can easily be integrated with each other and with external 3rd party tools.

Real-time demands come from decision making. Whether this is summoning a ride, ordering food, placing a trade or picking the next movie to watch. Services that cannot meet user demand at speed are going to deliver a bad experience and lose costumers' trust. How do we fix this? Data!! 📊

What can you do with data? Caching, processing, streaming, persistence... For its infrastructure, each of these components need: implementation, hosting, reliability and security. This is a lot of work and time, especially considering every project has specific requirements and specifications which translate into new data infrastructures. What if you could manage all of this in one unified platform? Watch the video and find out how with Aiven.

In this session you'll learn how to interact with the OpenSearch cluster with the help of OpenSearch NodeJS client - create an index, add documents, search and aggregate data. At the end we’ll visualise results with OpenSearch Dashboards and sink the data from Apache Kafka. Prerequisites: During the workshop you’ll create an Aiven account using the free trial.

Ever considered bringing OpenSearch’s powerful capabilities to your GCP data infrastructure, but not sure where to start? Tune in to our webinar to hear top tips from Aiven’s technical experts and OpenSearch gurus. Expect to learn: AIVEN DATA PLATFORM The Aiven Platform is more than a collection of open source services for streaming, storing and analyzing data. The platform ensures that all services run reliably and securely in the clouds of your choice, are observable, and can easily be integrated with each other and with external 3rd party tools.

In this video, Jenn will walk you through how to use the “One Click Deploy” option to deploy your PostgreSQL® and Redis®* services.

Get an introduction to Apache Kafka® Tiered Storage which enables more effective data management by utilizing two different storage types—local disk and remote cloud storage solutions such as Amazon S3, Google Cloud Storage, and Azure Blob Storage. This feature offers a tailored approach to data storage, allowing you to allocate frequently accessed data to high-speed local disks while offloading less critical or infrequently accessed data to more cost-effective remote storage solutions. Tiered storage enables you to indefinitely store data on specific topics without running out of space. Once enabled, it is configured per topic, giving you granular control over data storage needs.

Join our CEO and co-founder Oskari as he sits down with Revenir Ai's CTO Brian Wagner as they discuss AI, security and compliance and how collaboration and specifically open-source leads to better solutions.