Databases

How To Monitor Your Managed PostgreSQL Database Using Nagios Core on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Monitor Your Managed PostgreSQL Database Using Nagios Core on Ubuntu 18.04

Database monitoring is key to understanding how a database performs at various points in time. It can help you uncover hidden usage problems and bottlenecks, and will also allow you to be in the loop of everything that is happening to your database. In this tutorial, you will set up PostgreSQL database monitoring in Nagios Core using the check_postgres Nagios plugin and set up Slack-based alerting.

Read more
How To Query Tables and Paginate Data in Flask-SQLAlchemy — step-by-step Python tutorial on Progressive Robot

How To Query Tables and Paginate Data in Flask-SQLAlchemy

In this tutorial, you’ll use Flask and Flask-SQLAlchemy to create an employee management system with a database that has a table for employees. You’ll use the Flask shell to query a table, and get table records based on a column value. You’ll retrieve records on certain conditions. You’ll order the results by a column value, and count and limit query results. Finally, you’ll use pagination to display a certain number of records per page in a web application.

Read more
An Introduction to Queries in MySQL — step-by-step Linux tutorial on Progressive Robot

An Introduction to Queries in MySQL

In this guide, we will discuss the basic syntax of SQL queries as well as some of the more commonly-employed functions and operators. We will also practice making SQL queries using some sample data in a MySQL database.

Read more
Verstehen relationaler Datenbanken — step-by-step DevOps tutorial on Progressive Robot

Verstehen relationaler Datenbanken

Datenbankmanagementsysteme (DBMS) sind Computerprogramme, mit denen Benutzer mit einer Datenbank interagieren können. Ein DBMS ermöglicht es Benutzern, den Zugriff auf eine Datenbank zu steuern, Daten zu schreiben, Abfragen auszuführen und andere Aufgaben im Zusammenhang mit…

Read more
An Introduction to Document-Oriented Databases — step-by-step Databases tutorial on Progressive Robot

An Introduction to Document-Oriented Databases

This conceptual article outlines the key concepts related to document databases and discusses benefits of using them. Examples used in this article reference MongoDB, a widely-used document-oriented database, but most of the concepts highlighted here are applicable for most other document databases as well.

Read more
CHAT