Databases

The latest News and Information on Databases and related technologies.

Getting Started with SQL Queries

Jul 24, 2023 By Aiven In Aiven

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.

View Video

Aiven

Read more about Getting Started with SQL Queries

How Worldline uses Grafana Enterprise and Grafana Mimir to run its platform-as-a-service at a global scale

Jul 21, 2023 By Gina Lopez In Grafana

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.

Read Post

Grafana

Read more about How Worldline uses Grafana Enterprise and Grafana Mimir to run its platform-as-a-service at a global scale

Relational Databases: Exploring Indexes and Transactions

Jul 21, 2023 By Aiswarya S In Atatus

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.

Read Post

Atatus

Read more about Relational Databases: Exploring Indexes and Transactions

Managing the challenge of migrating to the cloud

Jul 21, 2023 By Matt Hilbert In Redgate

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

Read Post

Redgate

Read more about Managing the challenge of migrating to the cloud

The promise - and the perils - of GitHub Copilot

Jul 20, 2023 By Matt Hilbert In Redgate

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.

Read Post

Redgate

Read more about The promise - and the perils - of GitHub Copilot

Creating Databases, Schemas, and Tables on pgAdmin

Jul 20, 2023 By Aiven In Aiven

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.

View Video

Aiven

Read more about Creating Databases, Schemas, and Tables on pgAdmin

What is Database Administration?

Jul 19, 2023 By OpsMatters In OpsMatters

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.

Read Post

OpsMatters

Read more about What is Database Administration?

MySQL high availability made charmingly easy

Jul 18, 2023 By Mohamed Wadie Nsiri In Canonical

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.

Read Post

Canonical

Read more about MySQL high availability made charmingly easy

Improving query performance in Grafana Mimir: Why we dropped mmap from the store-gateway

Jul 17, 2023 By Charles Korn In Grafana

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.

Read Post

Grafana

Read more about Improving query performance in Grafana Mimir: Why we dropped mmap from the store-gateway

How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone

Jul 17, 2023 By Ivo Miller In Redgate

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.

Read Post