Guide

A guide to Apache Kafka^® tiered storage with Aiven and Terraform
A guide to what tiered storage is, and how you can start using it with Aiven for Apache Kafka® and Terraform. We’ll set up a cluster, load the data and observe the metrics.
- Apache Kafka®
- Terraform
- Data
- Guide
- DevOps
SQL query optimization: a comprehensive developer's guide
An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.
- PostgreSQL®
- MySQL
- Guide
- AI
- Data
- Performance optimization
Managing data drift with Apache Kafka^® Connect and a schema registry
Use Karapace, an open source Apache Kafka® schema registry, to prevent data errors by managing the data model across databases
- Developer
- Apache Kafka®
- Data
- Guide
Change Data Capture from Azure SQL to Apache Kafka^® with Debezium
Implement a real-time change data capture workflow from an Azure SQL database using Aiven for Apache Kafka® and Debezium
- Apache Kafka®
- Data
- Guide
- Integration
Controlling non-production Aiven Services with the CLI
Running non-production services when they’re not needed can waste money. Learn how to start and stop them as needed, using the Aiven CLI.
- Aiven API
- Guide
Image recognition with Python, OpenCV, OpenAI CLIP and pgvector
Vector embeddings are key to ML, and here we describe how to use OpenCV, OpenAI CLIP and pgvector to generate vectors and use them to perform image recognition on a corpus of photos.
- PostgreSQL®
- Data
- Machine learning
- Guide
Picking a baby name with PostgreSQL^® and FuzzyStrMatch
Choosing the name of your new child is really serious, so as a data professional you will naturally want to reach for PostgreSQL®. Find out more below.
- PostgreSQL®
- Guide
Start using OpenSearch^® with NodeJS
Great search and aggregation features can make a big difference to your application. Read on to see how to use OpenSearch® with your NodeJS.
- OpenSearch®
- Integration
- Guide