PostgreSQL, also called Postgres, is one of the most popular SQL database management systems (DBMS) ever.
It is Open Source, free for personal and commercial use, and it has a long history that started in 1996, building on top of other software that dates back to the 1980’s.
PostgreSQL is a really complete and full-featured general purpose relational database.
It provides support for most of the SQL standard, and also builds on top of it its unique set of features, to provide us a great tool.
You can find the project homepage at https://www.postgresql.org.
We can interact with a PostgreSQL database using many different programming languages. Internally, being a relational database we’ll use SQL to insert, query and manipulate the data.
More Postgres tutorials:
- How to install Postgres
- Postgres user permissions
- How to list all users in Postgres
- How to list all databases using Postgres
- How to switch database using Postgres
I am going to write a lot of Postgres tutorials in the near future. I will link them here.
Pssst! Also check my latest YouTube video
I am writing a book on how to create a successful blog as a developer.
It will be released late February.
Signup to my newsletter to get 2/3 free chapters in your inbox in the next few weeks!