%term

The latest News and Information on Databases and related technologies.

Monitoring PostgreSQL With pgmetrics and pgDash

Sep 22, 2021 By Pēteris Caune In Healthchecks

I am currently trialing pgmetrics and pgDash for monitoring PostgreSQL databases. Here are my notes on it. pgmetrics is a command-line tool you point at a PostgreSQL cluster and it spits out statistics and diagnostics in a text or JSON format. It is a standalone binary written in Go, and it is open source. Here is a sample pgmetrics report. Rapidloop, the company that develops pgmetrics, also runs pgDash – a web service that collects reports generated by pgmetrics and displays them in a web UI.

Read Post

Healthchecks

Read more about Monitoring PostgreSQL With pgmetrics and pgDash

DBAle 29: Guess the State of Database DevOps in 2021

Sep 21, 2021 By Redgate In Redgate

Our guest host, and the fountain of knowledge that is, Grant Fritchey, gets into the spirit early enjoying a Beer Can with Chris. Going head-to-head in the ultimate DBAle showdown, Grant pits Chris v Chris as they battle it out to correctly guess insights from the brand new 2021 State of Database DevOps Report.

View Video

Redgate

Read more about DBAle 29: Guess the State of Database DevOps in 2021

DBAle 30: If it ain't DevSecOps...what is it?

Sep 21, 2021 By Redgate In Redgate

With both hosts back on the beer to celebrate a momentous milestone, we talk Kiwis and Shoop (ba doop ba doop), sparking inspiration for a future episode. Chris and Chris break it down with DevSecOps. Fear not, there’s no rapping, just a lyrical breakdown of the place and role of security within DevOps. Something the organizations featured in our bumper News segment could do with learning about. So, grab yourself a beer and cheers to DBAle turning 30.

View Video

Redgate

Read more about DBAle 30: If it ain't DevSecOps...what is it?

DBAle 31: Monitoring matters for modern data management

Sep 21, 2021 By Redgate In Redgate

Is it a beer, is it a muffin or is it a Panda Pop? Who knows but at 9% strength, producer Louise joins our Chris duo as plan B, to monitor proceedings. Very fitting as our discussion focuses on monitoring for the modern data age. We talk busyness, hybrid estates, tooling, Multi-RDBMS, and a surprising amount about car mechanics. In The News we debate scrape or breach, and the potential maximum fines for the latest Facebook scandal. So, grab yourself a beer and tune in – cheers.

View Video

Redgate

Read more about DBAle 31: Monitoring matters for modern data management

How we used Flyway to source control the database - Scott Sauber

Sep 17, 2021 By Redgate In Redgate

Scott Sauber, Director of Engineering at Lean TECHniques Inc., covers the challenges and benefits of source controlling database changes, including a demo of Flyway.

View Video

Redgate

Read more about How we used Flyway to source control the database - Scott Sauber

Flyway demo: database source control and repeatable migrations - Scott Sauber

Sep 17, 2021 By Redgate In Redgate

A short demo with Scott Sauber, covering of how to setup Flyway and use it to source control database changes, as well as take advantage of Flyway's capability to run repeatable migrations - ideal for objects like stored procedures.

View Video

Redgate

Read more about Flyway demo: database source control and repeatable migrations - Scott Sauber

Maximize network traffic insights with extended raw data storage

Sep 16, 2021 By NetFlow Analyzer In ManageEngine

Introducing HighPerf, our highly scalable raw storage database that facilitates smarter analytics, faster troubleshooting, and better bandwidth management.

Read Post

ManageEngine

Read more about Maximize network traffic insights with extended raw data storage

Aiven for PostgreSQL 13 performance on GCP, AWS and Azure [Benchmark]

Sep 16, 2021 By Eero Tuomikoski In Aiven

Welcome to our latest benchmark figures for Aiven for PostgreSQL on AWS, GCP and MS Azure.

Read Post

Aiven

Read more about Aiven for PostgreSQL 13 performance on GCP, AWS and Azure [Benchmark]

Aiven launches Kubernetes Operator support for PostgreSQL and Apache Kafka

Sep 13, 2021 By Jonatas "jojo" Baldin In Aiven

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.

Read Post

Aiven

Read more about Aiven launches Kubernetes Operator support for PostgreSQL and Apache Kafka

SQL vs NoSQL databases

Sep 10, 2021 By Ron Powell In CircleCI

Application developers have a choice between two main categories of database: SQL (Structured Query Language) and NoSQL (Not Only SQL). SQL databases, also known as relational databases, have been in use for over 40 years. Despite their age, SQL databases remain extremely popular with developers. Of the top 10 results on DB-Engines’ list of most popular database management systems in September 2021, six were relational, or SQL-based.

Read Post