Blog | tips

Tips and tricks

Back to main blog

All posts

13 September 2021

Aiven launches Kubernetes Operator support for PostgreSQL and Apache Kafka

To make life easier for database admins and simplify DevOps, Aiven now offers a Kubernetes Operator for Aiven for PostgreSQL and Aiven for Apache Kafka services. Find out how you can use it to manage your whole service stack.

& Auri
31 August 2021|By

Solving the knapsack problem in PostgreSQL

12 August 2021|By

Metrics and graphs with M3 and Grafana

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.

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.

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.

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.

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!

20 May 2021

Analysing Netflix shows with pgAdmin and PostgreSQL

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

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.

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.

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.

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.

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.

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!

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.

& 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.

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.

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!

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.

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.

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!

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.

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.


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.