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…
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). …
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. …
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. …
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…
☞ ☞ ☞ 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…
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
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…
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, …
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
