Vultr Docs Latest Articles Marketplace Apps Product Docs BETA

Articles in category: SQL

How to Implement Case Statement Using Vultr Managed Database for PostgreSQL

How to Implement Case Statement Using Vultr Managed Database for PostgreSQL

PostgreSQL is a high performance database server that allows you to store common data types and use

PostgreSQLCASE StatementVultr Managed Database

December 5, 2023

By Francis Ndungu

How to Use Triggers in PostgreSQL

How to Use Triggers in PostgreSQL

Triggers in PostgreSQL allow developers to define rules and actions which can be executed without th

PostgreSQLDatabase ManagementTriggers

By Ashish Kumar Panda

How to Implement PostgreSQL Stored Procedures

How to Implement PostgreSQL Stored Procedures

In PostgreSQL, a stored procedure is a user-defined function that runs multiple queries to automate

PostgreSQLStored ProceduresDatabase Management

By Francis Ndungu

How to Encrypt Data Columns in PostgreSQL

How to Encrypt Data Columns in PostgreSQL

Databases that contain sensitive information often need multiple layers of security to protect that

PostgreSQLData Encryptionpgcrypto

February 1, 2023

By Arun Nanda

How to Securely Store Passwords Using PostgreSQL

How to Securely Store Passwords Using PostgreSQL

Applications that deal with user accounts need to authenticate (establish the identity of) the user

PostgreSQLPassword Hashingpgcrypto

February 1, 2023

By Arun Nanda

How to Securely Deploy QuestDB on a Vultr Cloud Server

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

February 1, 2023

By Anonymous User

How to Use the PostgreSQL UUID Data Type

How to Use the PostgreSQL UUID Data Type

Universally Unique Identifiers (UUIDs), also known as Globally Unique Identifiers (GUIDs), are 128-b

PostgreSQLUUIDDistributed Databases

January 23, 2023

By Francis Ndungu

How to Use the PostgreSQL Date Data Type

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

January 23, 2023

By Francis Ndungu