Vultr Docs Latest Articles Marketplace Apps Product Docs BETA

Articles in category: SQL

Set Up Highly-available PostgreSQL Replication Cluster on Ubuntu 20.04 Server

Set Up Highly-available PostgreSQL Replication Cluster on Ubuntu 20.04 Server

To ensure high availability, reliability, and fault-tolerance, the PostgreSQL database server suppor

PostgreSQLReplication ClusterUbuntu

February 28, 2022

By Francis Ndungu

How to Use the Postgresql Hstore Data Type on Your Linux Server

How to Use the Postgresql Hstore Data Type on Your Linux Server

PostgreSQL is one of the most advanced relational database management systems (RDBMS). It has extens

Linux ServerPostgreSQLhstore

January 20, 2022

By Francis Ndungu

How to Use Views in MySQL 8

How to Use Views in MySQL 8

In MySQL, views are virtual tables for running pre-defined queries. Thus, they re suitable in databa

Database SecurityViewsMySQL

September 28, 2021

By Francis Ndungu

How to Use Scheduled Events with Mysql 8.0

How to Use Scheduled Events with Mysql 8.0

MySQL scheduled events are time-based SQL statements executed by the scheduler thread at a specific

Database ServerMySQLScheduled Events

By Francis Ndungu

How to Work with JSON Data in MySQL

How to Work with JSON Data in MySQL

JavaScript Object Notation (JSON) is a popular data-interchange format because it is easy to seriali

JSONDatabase ServerMySQL

By Francis Ndungu

How to Use MySQL Regular Expressions

How to Use MySQL Regular Expressions

MySQL provides a powerful way to perform complex text-based searches through the regular expressions

Regular ExpressionsDatabase ServerMySQL

By Francis Ndungu

How to Manage Password Policies in MySQL 8

How to Manage Password Policies in MySQL 8

MySQL is the world s most popular open-source database management system that offers on-demand scala

Password PoliciesDatabase ServerMySQL

By Francis Ndungu

How to Install, Configure, Backup, and Restore PostgreSQL on Ubuntu 20.04 LTS

How to Install, Configure, Backup, and Restore PostgreSQL on Ubuntu 20.04 LTS

PostgreSQL is an open-source Object-Relational Database Management System (ORDBMS) that supports mos

PostgreSQLDatabase BackupUbuntu

By Francis Ndungu

1 ...4 5 6 7 8 9