How to Use Vultr Managed Databases for PostgreSQL with Node.js
PostgreSQLIntroduction Vultr provides production-ready PostgreSQL database clusters that you can use with Node.js to create mission-critical applications. Managed databases automate the most challenging aspects of database administration, allowing you to focus on your app. This guide shows you how to use the Node.js pg library on Ubuntu 20.04 server to pass queries…
Vultr Managed Databases for PostgreSQL Reference Guide
PostgreSQLIntroduction This reference guide for managed PostgreSQL covers all the essential information you need to administer and use your database. This guide assumes you’ve already deployed a PostgreSQL managed database by following our Quickstart guide and want to learn more. To get started, navigate to the Databases section of my.vultr.com. Then, click your deployed database…
Implement Role-based Permissions with PostgreSQL
PostgreSQLIntroduction In a PostgreSQL server, a role is a collection of permissions that you can assign to one or more users. Roles simplify assigning bundled privileges to users in a multi-user environment using a single statement. One great example of a scenario where you can use database roles is an…
How to Speed Up PostgreSQL Queries With Partitions
PostgreSQLIntroduction PostgreSQL database performance is a key factor that is directly affected when querying data from large tables. To reduce memory swaps and table scans, PostgreSQL partitions allow you to split data into smaller manageable tables to speed up queries. This architecture improves your database reliability and overall performance. Partitions…
How to Manage Users in Vultr Managed Databases for PostgreSQL
PostgreSQLIntroduction PostgreSQL is an open-source relational database management system (RDBMS) that lets you create databases and manage records. Vultr Managed Databases for PostgreSQL offer a secure, highly available, and scalable solution you can use in your production applications without managing the database infratsurcture directly. This guide explains how to manage…
How to Implement Case Statement Using Vultr Managed Database for PostgreSQL
PostgreSQLIntroduction PostgreSQL is a high performance database server that allows you to store common data types and use different SQL tools to sort available data. These tools include the SQL CASE statement that evaluates a list of expressions and returns a value based on the possible results. For instance, in a school…