How to Securely Store Passwords Using PostgreSQL
Applications that deal with user accounts need to authenticate (establish the identity of) the user
PostgreSQLPassword Hashingpgcrypto
SQL
February 1, 2023
By Arun Nanda
Articles in category: Database
How to Securely Deploy QuestDB on a Vultr Cloud Server
QuestDB is a time-series database application that is fast and suitable for digesting large data. A
QuestDBCloud ServersDatabase Security
SQL
February 1, 2023
By Anonymous User
How to Use the PostgreSQL UUID Data Type
Universally Unique Identifiers (UUIDs), also known as Globally Unique Identifiers (GUIDs), are 128-b
PostgreSQLUUIDDistributed Databases
SQL
January 23, 2023
By Francis Ndungu
How to Use the PostgreSQL Date Data Type
The PostgreSQL server is one of the most advanced database management systems for creating modern da
PostgreSQLData TypeTimestamps
SQL
January 23, 2023
By Francis Ndungu
Introduction to Using Indexes in PostgreSQL
When you run a SELECT query on a table, the database engine goes through each row sequentially, unti
Performance OptimizationPostgreSQLDatabase Indexing
SQL
February 1, 2023
By Arun Nanda
How to Backup and Restore PostgreSQL Databases with pg_dump
Pg_dump is a PostgreSQL backup utility tool that allows database administrators to export databases
PostgreSQLpg_dumpDatabase Backup
SQL
January 3, 2023
By Humphrey Mpairwe
How to Calculate Distances with PostgreSQL
Many modern applications need to calculate distances - between two people, between a business and a
PostgreSQLearthdistancecube
SQL
January 3, 2023
By Arun Nanda
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