How to Install MySQL on Ubuntu 24.04
MySQL is an open-source relational database management system (RDBMS) based on the structured query
Database ManagementUbuntuMySQL
SQL
July 1, 2024
By Mostafa Ibrahim
Articles in category: SQL
Implement Role-based Permissions with PostgreSQL
In a PostgreSQL server, a role is a collection of permissions that you can assign to one or more use
PostgreSQLRole-Based Access ControlDatabase Management
SQL
January 28, 2022
By Francis Ndungu
How to Implement Arrays with Vultr Managed Databases for PostgreSQL
In the PostgreSQL server, the array data type allows you to define a column that holds comma-separat
PostgreSQLArraysManaged Databases
SQL
January 3, 2023
By Francis Ndungu
How to Use the PostgreSQL Ranges Data Type on Ubuntu 20.04 Server
A range is a sequential series of data. In a PostgreSQL database server, you can store a range of va
PostgreSQLDatabase IndexingUbuntu
SQL
June 22, 2023
By Anonymous User
AI-powered Search with pgvector and Vultr Managed Database for PostgreSQL
Among the most challenging aspects of relational databases is the ability to work with vector data a
AI-powered SearchPostgreSQLpgvector
SQL
August 21, 2023
By Francis Ndungu
Choose WordPress Database Backend: Managed MySQL vs Self Hosted
A WordPress database is a key backend component that determines the general site performance, respon
WordPressManaged DatabaseMySQL
SQL
October 6, 2023
By Humphrey Mpairwe
How to Speed Up PostgreSQL Queries With Partitions
PostgreSQL database performance is a key factor that is directly affected when querying data from la
PostgreSQLDatabase PartitioningDatabase Queries
SQL
November 12, 2023
By Francis Ndungu
How to Install PostgreSQL on Ubuntu 24.04
PostgreSQL is an open-source advanced Relational Database Management System (RDBMS) designed to hand
PostgreSQLDatabase SecurityUbuntu
SQL
June 12, 2024
By Bagaskara Guruh T