Databases

Nginx Reverse Proxy for Kibana: How to Configure

August 21, 2024

This tutorial shows you how to configure Nginx reverse proxy for Kibana. It shows you the simplest way to secure your Kibana through configuring Nginx. Set up your Kibana to allow access only to authorized password-protected users.

Read more

How to Deploy PostgreSQL on Kubernetes

August 15, 2024

PostgreSQL is a reliable and robust relational database system featuring ACID compliant transactions. This tutorial provides two methods of PostgreSQL deployment on Kubernetes - using a Helm chart or manual configuration creation.

Read more

How to Deploy MySQL on Kubernetes

August 14, 2024

Deploying a functional database in a containerized environment can be a demanding task. This article will show you how to deploy a MySQL database instance on Kubernetes using persistent volumes, the feature that enables stateful apps to overcome the problem of the inherent transience of the K8s pods.

Read more

How to Create a Collection in MongoDB

August 1, 2024

MongoDB collections are essential when managing data and creating a database. This guide shows two ways to create a collection in MongoDB.

Read more

How to Create an External Table in Hive

July 31, 2024

External tables in Hive are used to access and query data stored outside of a database. Follow the steps of this tutorial to learn how to create, query and drop external tables.

Read more

How to Find Duplicate Values in MySQL

July 25, 2024

Learn how to find the duplicate entries in your MySQL databases. The guide shows three different ways to find duplicates in a MySQL table.

Read more

How to Create a Database in MongoDB


Create new MongoDB databases and add data collections by using the commands presented in this article. The use, insert and find commands are crucial tools that allow you to perform basic administrative tasks on your database servers.

Read more

How to Export MySQL Data to CSV

July 18, 2024

This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

Read more

How To Create New MySQL User and Grant Privileges


This article explains how to create a new MySQL non-root user and grant various types of privileges.

Read more

PostgreSQL Drop Database with Examples

July 11, 2024

This tutorial teaches you how to remove (drop) a database in PostgreSQL using two different methods.

Read more