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
- Go to the PostgreSQL download page
- Follow the instructions
macOS
- Go to the PostgreSQL download page
- Follow the instructions
Ubuntu
- Go to the PostgreSQL download page
- Follow the instructions
Arch
pacman -S postgresql
Further Reading
Questions
- What's your favorite SQL database?