Intro

I am creating a new series about PostgreSQL.

In this short article, we will learn how to install it.

What is PostgreSQL?

• a free and open-source relational database management system (RDBMS) to manage data
• primarly uses SQL (Structured Query Language) to write commands
• primarly stores data in tables consisting columns and rows
• can get easily connected to backend applications (e.g. in Node, Python, Java etc.)
• comes with a terminal-based front-end named psql

How To Install it?

Windows

1. Go to the PostgreSQL download page
2. Follow the instructions

macOS

1. Go to the PostgreSQL download page
2. Follow the instructions

Ubuntu

1. Go to the PostgreSQL download page
2. Follow the instructions

Arch

1. pacman -S postgresql

Further Reading

• PostgreSQL Homepage
• PostgreSQL Download
• PostgreSQL on Wikipedia
• SQL Syntax

Questions

• What’s your favorite SQL database?

Hi! I'm Michael 👋 I'm a problem solver and mentor. My goal is to build great products and help you to become a better developer.