Blog | tips

Tips and tricks

Back to main blog

All posts

01 November 2021

***Copy this to make a new post (40-90 chars)

Write a teaser description of the post. End with a CTA like "Find out..." or "Read on..." (150-160 chars)

Crabby
13 September 2021|By

Aiven launches Kubernetes Operator support for PostgreSQL and Apache Kafka

31 August 2021

Solving the knapsack problem in PostgreSQL

The knapsack problem: how to use limited luggage space to pack only and all the items you're most likely to need? Enter PostgreSQL! Come and find out how to use the world's best open source database to help you pack.

Francesco
12 August 2021

Metrics and graphs with M3 and Grafana

Monitoring and graphs go together like milk and coffee. Read on to find out how to use M3 to monitor your systems, and Grafana to make the results easier to understand.

Lorna
09 August 2021

How retail and eCommerce can leverage open source cloud technology

In our latest webinar, Alex Timlin and Jan Hegewald explore the challenges facing retailers, looking at ways that open source cloud technologies can support eCommerce and help companies get started with digital transformation. Read on for the key points – or watch the full webinar.

04 August 2021

Get started with Apache Superset and PostgreSQL

Data visualization can condense huge amounts of raw points into images that can drive business decisions. Apache Superset is emerging as a reliable open source tool for the dataviz world. Read on to find out how to use it to create data visualizations from an existing PostgreSQL table within an Aiven environment.

Francesco
23 June 2021

The pursuit of happiness with Python and PostgreSQL

The world is seldom perfect, and the same goes for real-life data. Read on to find out how to clean up the data in your PostgreSQL database so that it's usable for analysis.

Francesco
21 June 2021

Observe your PostgreSQL metrics with Terraform, InfluxDB and Grafana

Read the latest instalment of the Terraform adventures to find out how to plug PostgreSQL into Grafana and really see what the metrics are saying.

Jonatas
15 June 2021

TIG Stack: Using Telegraf, InfluxDB and Grafana on Aiven

Performance monitoring is an essential aspect of every project, in both the digital and traditional world. Read on to find out how to use the TIG stack (Telegraf, InfluxDB, Grafana) to visualise the health status of your laptop.

Francesco
03 June 2021

Aiven databases and Terraform for fun and profit

Terraforming is hard and long-term, but managing your databases with Terraform is the exact opposite. Read to find out how to manage your Aiven databases with this cool tool!

Jonatas
20 May 2021

Analysing Netflix shows with pgAdmin and PostgreSQL

Learn how to use pgAdmin with PostgreSQL by... watching movies? Find out more!

Francesco
12 May 2021

5 tips for choosing a DBaaS vendor

In managed cloud infra, David Esposito has seen it all from both sides of the table. Now he offers his best 5 tips for selecting a service provider. If you're thinking of moving to managed infrastructure in the cloud, watch or read his take on this now.

David
10 May 2021

Teach yourself Apache Kafka and Python with a Jupyter Notebook

Learn the basics of Apache Kafka Producers and Consumers by building an interactive notebook in Python.

Francesco
01 May 2021

Quickly developing REST APIs with PostgREST

Write a teaser description of the post. End with a CTA like "Find out..." or "Read on..." (150-160 chars)

Crabby
01 May 2021

Why your boss should choose Aiven

Write a teaser description of the post. End with a CTA like "Find out..." or "Read on..." (150-160 chars)

Crabby
28 April 2021

Tips for designing payloads

Event-Driven systems are increasingly our future and that's one reason why so many developers are adding Apache Kafka to their tech stacks. In this post, Lorna Mitchell gives tips for designing payloads for your Kafka to achieve a solid data structure.

Lorna
30 March 2021

Your first Aiven API call

Aiven's API is totally wizard, with its nifty token authentication and JSON-formatted data, but you don't need magic to use it. Read on for tips on how you can put it to work in the real world.

Lorna
25 March 2021

Using Kafka Connect JDBC Source: a PostgreSQL example

How to update an old app-to-database design to include Kafka? Find out how to use Kafka Connect to integrate to an existing system and use up-to-date tech tools without disrupting the original solution.

Francesco
18 March 2021

Welcome to your Aiven demo

We continually improve the accessibility and usability of Aiven services. Recently we launched a new welcome tour feature--read on to discover what it’s about!

Auri
17 March 2021

Data and disaster recovery

We humans don’t like to think about disasters, but that doesn’t stop them from happening. Read to find out how you should prepare your data for the worst, even while hoping for the best.

James
& Chris
26 February 2021

Aiven for PostgreSQL for your Go application

Applications and databases go together like milk and cookies; on the menu today is a PostgreSQL-flavored cookie with a splash of refreshing Go milk. I've picked two of my favorite Go libraries as samples; read on to find out how to use them to connect to and work with your Aiven for PostgreSQL service.

Lorna
17 February 2021

How to stand up multiregion PostgreSQL with Pulumi

To improve the performance of your PostgreSQL database, consider setting up a multiregion service that will allow you to isolate read-intensive workloads to replicas while keeping write workloads on the primary. To learn how, read this tutorial where Trevor Kennedy explains the process using Aiven and Pulumi.

Trevor
17 February 2021

Discover exoplanets with PostgreSQL sample data

PostgreSQL is and remains one of our most popular and growing storage platforms. In this post, Lorna Mitchell populates an empty PostgreSQL database with cool data about exoplanets. Read to learn how!

Lorna
10 February 2021

Create your own data stream for Apache Kafka with Python and Faker

How can you test an empty data pipeline? Well, you can't, really. Read on and let Aiven's Developer Advocate Francesco Tisiot walk you through creating pretend streaming data using Python and Faker.

Francesco
10 February 2021

Broker communication in Apache Kafka 2.7 and beyond

Apache Kafka is moving away from ZooKeeper, slowly but surely. How does this impact broker communication in the latest version of Apache Kafka? How is Aiven preparing for the future? Read on to find out.

Auri
01 February 2021

Kafka v. RabbitMQ - a comparison

Today's post is all about queues and how to choose a solution that fits your application's requirements. We'll go over the key design features of RabbitMQ and Apache Kafka and outline how they process queues differently. Read on, and we'll help you decide which is a better match for you!

Lorna
26 January 2021

Building a modern data architecture

Corporate data architectures tend to have long shelf-lives, especially if their development began sometime around when the pre-internet Dark Ages were just ending. It's not surprising that these ancient edifices no longer support modern business goals. Read how to modernize your ancient data environment and set your business up for the future.

Auri
25 November 2020

How to avoid high-load disasters in managed database services

Black Friday is THE peak load time of the year, the great holiday of the retail world. The combination of a short timeline and good deals overloads servers all over the world and makes it the classic case for peak load fault tolerance. Find out now what you can do if your services show signs of overload.

Auri

Let‘s connect

Aiven for Apache Kafka, Aiven for Apache Kafka Connect, Aiven for Apache Kafka MirrorMaker 2, Aiven for M3, Aiven for M3 Aggregator, Aiven for Apache Cassandra, Aiven for OpenSearch, Aiven for PostgreSQL, Aiven for MySQL, Aiven for Redis, Aiven for InfluxDB, Aiven for Grafana are trademarks and property of their respective owners. All product and service names used in this website are for identification purposes only and do not imply endorsement.