A dolphin jumps over an elephant, illustrating the competition between MySQL and PostgreSQL. Which is best for you?
A dolphin jumps over an elephant, illustrating the competition between MySQL and PostgreSQL. Which is best for you?

PostgreSQL and MySQL are both widely used open source database management systems (DBMS) that also support some noSQL features. Coincidentally, or not, both are available through Aiven.

When you’re looking for a reliable managed database solution, which one should you pick?

How are managed PostgreSQL and MySQL different?

PostgreSQL and MySQL are very similar in the uses they are put to — well, they’re relational databases, you can’t really use MySQL as a coat rack ( although it can make toast). That said, we can dig out some differences.

Applications

One big limitation on your freedom of choice is applications that expect to find a particular database. Flask…


An astronaut is the odd one out among the pigeons sitting on a lamppost. The question is, is Kafka a database?
An astronaut is the odd one out among the pigeons sitting on a lamppost. The question is, is Kafka a database?

It’s stormy times on the internet, and the waters are seething. The rolling waves strike hard against the shores of Kafka, leaving behind arguments for and against this Great Question: Is It A Database?

Here’s a handy tl;dr for this article: Yes and no. It depends.

If you keep your eyes on Kafka’s logical niche in data architecture, and kind of squint, then yes — you could call it a database. It takes in data and gives out data, after all. It contains information about events that have occurred (insofar as it’s configured to of course). …


An elephant never forgets — and nor does PostgreSQL. Join the happy elephant on an exploration of Postgres fundamentals.
An elephant never forgets — and nor does PostgreSQL. Join the happy elephant on an exploration of Postgres fundamentals.

This post is all about PostgreSQL. We’ll cover a few of the many things it does, how it does them, why it does them that way, and what’s unique about PostgreSQL that has made it a go-to data store today. We’ll also consider the advantages of a managed and hosted PostgreSQL solution, and finally look at how to get started.

PostgreSQL is a flexible open-source object relational database management system with features meant to meet changes in workloads, from single machines to data warehouses to web services with many concurrent users. …


An elephant watches movies in a PostgreSQL tutorial from Francesco Tisiot
An elephant watches movies in a PostgreSQL tutorial from Francesco Tisiot

Can you learn how to use pgAdmin with PostgreSQL by… watching movies? Francesco Tisiot thinks so. Grab some popcorn and read on!

PostgreSQL is the perfect database for a huge variety of business cases, from IoT-type fast insertions to bulk analytics workloads. We even make it possible to explore exoplanet data!

Database interaction can be performed at various levels: command line tools are great for people glued to their keyboards… but some people prefer a slick point-and-click UI that shows all the information without having to write tons of commands. …


An owl sits on some scales, weighing up M3 against the time series database competition
An owl sits on some scales, weighing up M3 against the time series database competition

M3 is the shiny new thing in time series databases. In this post, we’ll compare it to some more established players and highlight the differences.

Let’s start things off with a tip: if you’re new to time series databases, you might want to start with our blog post An introduction to time series databases or An introduction to M3. And if you’re interested in using M3 as part of an observability solution, go ahead and read our case study about how Aiven did it internally.

M3: A Time series data platform

M3, birthed from the massive metrics scalability needs at Uber, bills itself as a metrics…


A woman looks through binoculars at David Esposito’s 5 tips for choosing a DBaaS vendor
A woman looks through binoculars at David Esposito’s 5 tips for choosing a DBaaS vendor

☞ ☞ ☞ Click to watch the “5 Tips for choosing a DBaaS vendor” video

When it comes to running managed infrastructure in the cloud, Solution Architect David Esposito has been on both sides of the table: As a platform architect, he worked with microservice applications doing streaming IT automation. And as a solutions architect, he’s worked with a lot of different companies, tech stacks, and problem spaces picking the right tool for the job.

Here are five tips on when and why you might want to work with a cloud based database service provider and how you can go…


A girl flies on a book in a tutorial for Apache Kafka
A girl flies on a book in a tutorial for Apache Kafka

One of the best ways to learn a new technology is to try it within an assisted environment that anybody can replicate and get working within few minutes. Notebooks represent an excellence in this field by allowing people to share and use pre-built content which includes written descriptions, media and executable code in a single page.

This blog post aims to teach you the basics of Apache Kafka Producers and Consumers through building an interactive notebook in Python. If you want to browse a full ready-made solution instead, check out our dedicated github repository.

Language support and multi-window GUI: the case for JupyterLab

One of the main actors in…


Francesco Tisiot feeds the SQL
Francesco Tisiot feeds the SQL

Apache Flink is an open source framework for data processing in both stream and batch mode. It supports a variety of different data platforms, including Apache Kafka and any JDBC database. Flink’s superpowers come in a variety of languages: from the more traditional Java and Scala, all the way to Python. And for Python there is pyFlink that you can use with the best Machine Learning libraries available.

However, in the data world, one of the most commonly-known languages is SQL. From data analysts, to scientists and engineers, SQL is usually part of the toolkit of data practitioners. SQL provides…


A squirrel bites into a nut, trying to get to the protein-rich core of Apache Flink
A squirrel bites into a nut, trying to get to the protein-rich core of Apache Flink

Apache Flink is an open source framework and distributed processing engine for stateful computations over unbounded and bounded data streams. Sound like a mouthful? Read on for a comprehensive overviews of this powerful software solution, and a look at how companies use Flink to expand the way they process data.

What is Apache Flink?

Flink is an open source framework and distributed, fault tolerant, stream processing engine built by the Apache Flink Community, a subset of the Apache Software Foundation. Flink, which is now at version 1.11.0, …


An octopus protects a treasure trove of valuable data
An octopus protects a treasure trove of valuable data

Once upon a time, you went with Prometheus for your metrics solution, and odds are that you lived happily ever after. After all, Prometheus offers a multi-dimensional data model, simple operations and a powerful query language, PromQL. This makes it ideal for keeping tabs on huge amounts of data in a cloud-based environment. Maybe you’re also using Kubernetes, which Prometheus also integrates with very well. And it’s also a fully independent, open source project that nevertheless has a robust following and commercial support options.

So, if Prometheus is so great, why are we saying you should invest in the M3…

Aiven

Your database in the cloud, www.aiven.io

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store