How to Install the PostGIS Extension for PostgreSQL
PostGIS is a full-fledged Geographic Information System (GIS) data modeling tool. It has many GIS-sp
PostgreSQLDatabase ManagementPostGIS
SQL
January 12, 2023
By Arun Nanda
Articles Tagged: Database Management
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
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 Use MySQL with Python
Python is a general-purpose programming language that focuses on code readability. It s suitable for
Database ManagementPythonMySQL
Python
June 9, 2022
By Francis Ndungu
How to Work With PostgreSQL Joins
A PostgreSQL JOIN models logical relationships when retrieving data from multiple normalized databas
PostgreSQLSQL JoinsDatabase Management
SQL
June 9, 2022
By Francis Ndungu
How to Perform Full-Text Search on a PostgreSQL Database
A PostgreSQL full-text search allows you to find records that match certain keywords with a high deg
PostgreSQLDatabase ManagementFull-Text Search
SQL
April 14, 2022
By Francis Ndungu
Install Apache Cassandra on Ubuntu 20.04
Apache Cassandra is an open-source NoSQL database engine used to store large amounts of data in a di
Database ManagementApache CassandraUbuntu
NoSQL
October 5, 2021
By Anonymous User
How to Calculate Age From Date of Birth Using TIMESTAMPDIFF in MySQL
When you re creating an age-sensitive application such as a hospital or an insurance company applica
Database ManagementTIMESTAMPDIFFMySQL
SQL
March 9, 2021
By Francis Ndungu