Digitalparking Leads the Smart Parking Revolution in Switzerland
Aiven for PostgreSQL® ensures business critical database runs without interruptions.
Operations | Monitoring | ITSM | DevOps | Cloud
The Place Where Modern Operations & Technology Come Together
Top PostgreSQL Monitoring Tools in 2023
Armed with the right PostgreSQL monitoring tools, database administrators and developers can identify potential bottlenecks, troubleshoot problems and make informed decisions to optimize their database environments. Monitoring PostgreSQL databases provides invaluable insight into their performance, health and overall efficiency.
What is Graphite?
What is Graphite? Simply put, Graphite is an open-source enterprise-ready time-series database. So what is a time-series database? Well, a time series is a series of data points indexed (or listed or graphed) in time order. Time Series databases have excellent benefits over traditional databases in terms of high performance, higher writes, improved scalability, better reliability, and many more.
Why monitoring server estates from a single pane of glass is key
The last few years have seen a big change in the size, make-up, and nature of database estates. Data is growing both in volume and complexity, it is now normal to have workloads as well as data in multiple public clouds, and organizations are increasingly using different kinds of databases for different use cases.
How we tame high cardinality in time series databases
Part 1 of the series of posts which talk about engineering design decisions to make high cardinality work in time-series databases.
Getting Started with SQL Queries
Welcome to our tutorial on executing basic queries on pgAdmin, the intuitive GUI tool for managing PostgreSQL databases. In this video, we'll cover essential SQL commands such as SELECT, UPDATE, DELETE, and INSERT, and demonstrate how to utilize them effectively on pgAdmin. Whether you're a beginner or looking to refresh your SQL skills, this tutorial provides valuable insights and practical examples. Additionally, we'll share helpful resources like SQL cheatsheets and codecademy's SQL commands article to further enhance your understanding.
How Worldline uses Grafana Enterprise and Grafana Mimir to run its platform-as-a-service at a global scale
According to the World Bank, two-thirds of adults around the globe currently make or receive digital payments. Businesses have come to expect quick, reliable processing, and one company at the forefront of that is Worldline. The global payment service provider (PSP) is a leading payment processor and payment provider in Europe, with about 3.4 billion e-commerce transactions made in 2022.
Relational Databases: Exploring Indexes and Transactions
Indexes serve as the key to unlocking the immense potential of relational databases, enabling swift and optimized data access. They act as a roadmap, allowing the database engine to locate specific data quickly, ultimately enhancing query performance. Understanding the nuances of indexes and employing the appropriate indexing techniques can significantly impact the efficiency of a database system.
Managing the challenge of migrating to the cloud
Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud. As many have discovered, it’s not simply a case of ‘lift and shift’.
The promise - and the perils - of GitHub Copilot
There’s been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation. At the back end is OpenAI Codex, a modified version of the GPT-3 Large Language Model (LLM) used in ChatGPT. At the front end it integrates with code editors like Visual Studio and JetBrains to automatically generate code.
Creating Databases, Schemas, and Tables on pgAdmin
In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.
What is Database Administration?
In today's digital age, data has become the lifeblood of businesses and organizations. With the exponential growth of data, the need for efficient and secure management has become paramount. This is where database administration comes into play. Database administration is a crucial role in ensuring the smooth operation and maintenance of databases. It involves a wide range of tasks, from designing and implementing databases to monitoring and optimizing their performance.
Deploy Testing Environments with Production-Like Data using Bunnyshell and Neon Serverless Postgres
In this webinar we explored the power of Bunnyshell and Neon in deploying production-like testing environments. Bunnyshell, an Environment as a Service platform, enables developers to instantly spin up ephemeral environments on Kubernetes. Neon provides a fully managed multi-cloud Postgres with a generous free tier, making it easy to launch serverless Postgres with a single command.
MySQL high availability made charmingly easy
In a previous blog, we talked about patterns to run a database in a highly available manner. In this blog, we present our recipe for MySQL high availability. We will also explain how our solution interacts with K8s objects to provide some of its features.
Improving query performance in Grafana Mimir: Why we dropped mmap from the store-gateway
In recent months, we have been working on improving the performance of Grafana Mimir, the open source, horizontally scalable, highly available, multi-tenant TSDB for long-term storage of your metrics.
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction.
Creating Databases, Schemas, and Tables on pgAdmin
In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.
Installing FerretDB through Civo Marketplace - Civo.com
In this video @KunalKushwaha introduces FerretDB, an open-source alternative to MongoDB built on PostgreSQL. It explains how to install FerretDB through the Civo Marketplace, highlighting the prerequisites and installation process. The video covers basic CRUD operations using FerretDB, including creating, reading, updating, and deleting documents. It also mentions the benefits of using FerretDB, such as its open-source nature, transparency, simplicity, and supportive community.
Q2 Round Up: Roadmap Review & Q3 2023 Look Ahead
Many thanks to everyone who joined us for our recent virtual meetup, during which we discussed some of our Q2 2023 highlights, including features highlights, the 2023 roadmap for VictoriaMetrics and of course: The launch of VictoriaLogs! In this blog post, we’d like to share a summary of these highlights.
Connecting PostgreSQL to pgAdmin
In this tutorial, we'll guide you through the process of connecting PostgreSQL to pgAdmin, a popular GUI tool for managing PostgreSQL databases. Whether you're a beginner or an experienced user, this video will provide you with step-by-step instructions on establishing a seamless connection between PostgreSQL and pgAdmin. Additionally, we'll showcase how Aiven's PostgreSQL service seamlessly integrates with pgAdmin, enabling you to efficiently administer your database.
How to visualize time series from SQL databases with Grafana
Relational databases like MySQL, PostgreSQL, Oracle, and others have a wealth of time series data locked inside of them. Often this data can be used to enhance observability dashboards, or keep track of important application factors, like how many users have signed up for a service. In this article, we’re going to show you how to visualize any time series from any SQL database in Grafana using the time series visualization.
Breaking the memory barrier: How Grafana Mimir's store-gateway overcame out-of-memory errors
Grafana Mimir is an open source distributed time series database. Publicly launched in March 2022, Mimir has been designed for storing and querying metrics at any scale. Highly available, highly performant, and cost-effective, Mimir is the underlying system powering Grafana Cloud Metrics, and it’s used by a growing open source community that includes individual users, small start-up companies, and large enterprises like OVHcloud.
Scale up: a MySQL bug story, or why Aiven works
Why use Aiven for MySQL service when you could just roll your own? The simple answer: managed services make economies of scale work for you.
Monitoring Microsoft SQL Server login audit events in Graylog
One of the most important events you should be monitoring on your network is failed and successful logon events. What comes to most people’s minds when they think of authentication auditing is OS level login events, but you should be logging all authentication events regardless of application or platform. Not only should we monitor these events across our network, but we should also normalize this data so that we can correlate events between these platforms.
7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide
Are you looking to modernize and migrate your data but have questions about the complex organizational challenges? We recently hosted the webinar: Overcoming Organizational Challenges in Data Modernization and Cloud Migration: A Guide for Senior IT Leaders.
How to get the best of lexical and AI-powered search with Elastic's vector database
Maybe you came across the term “vector database” and are wondering whether it’s the new kid on the block of data retrieval systems. Maybe you are confused by conflicting claims about vector databases. The truth is, the approach used by vector databases has been around for a few years.
Getting Started with PostgreSQL: Setup Postgres Service
Welcome to our introductory video where we focus on setting up the PostgreSQL service on Aiven. In this tutorial, we'll guide you through the initial steps of creating and configuring your PostgreSQL database on the Aiven platform. While this video primarily covers the setup process, we have exciting plans for future videos where we'll dive into connecting with a client and exploring advanced functionalities. Stay tuned for upcoming episodes that will help you make the most out of PostgreSQL on Aiven. Subscribe now and join us on this journey as we unlock the full potential of PostgreSQL in conjunction with Aiven's managed services!