How to Use Enumerated Data Types with PostgreSQL
In the PostgreSQL database server, an enumerated (enum) type is a custom data type containing a list
PostgreSQLDatabase ManagementEnumerated Data Types
SQL
January 4, 2023
By Francis Ndungu
Articles in category: Database
How to Use Recursive Queries in PostgreSQL
Handling complex data, like social networks and organizational hierarchies, is increasingly relevant
PostgreSQLRecursive QueriesData Modeling
SQL
January 4, 2023
By Arun Nanda
How to Import CSV Data to Vultr Managed Databases for PostgreSQL
A Comma Separated Values (CSV) file is a plain-text file that stores data in tabular format. Usually
PostgreSQLVultr Managed DatabasesCSV
SQL
January 4, 2023
By Francis Ndungu
Introduction to Common Table Expressions (CTEs) in PostgreSQL
This guide explains how to organize complex SQL queries with multiple subqueries using Common Table
PostgreSQLCommon Table ExpressionsData Modeling
SQL
January 4, 2023
By Arun Nanda
How to Use Materialized Views in PostgreSQL
: About Views and Materialized Views For a complex SQL query, it is impractical to rewrite the entir
PostgreSQLMaterialized ViewsDatabase Management
SQL
December 1, 2022
By Arun Nanda
How to Restore a Single Database from a Full MySQL Database Dump
MySQL Dump is a backup utility used to recover your databases and tables in case your database serve
Database DumpDatabase RestorationMySQL
SQL
October 31, 2022
By Nathan Olupot
How to Use the JSON Data Type with PostgreSQL on Ubuntu 20.04
JavaScript Object Notation (JSON) is a modern data exchange format often used in API-based services.
PostgreSQLJSONUbuntu
SQL
September 16, 2022
By Francis Ndungu
How to Repair a Corrupted MySQL Table
MySQL is a Relational Database Management System (RDBMS). An RDBMS is a database management system (
InnoDBDatabase RepairMySQL
SQL
September 16, 2022
By Josh Amata