Postgres Intro

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

PostgreSQL is an open source Relational Database Management System (RDBMS).
Some other relational database management systems are MySQL, SQL Microsoft, MongoDB, Redis and Neog4

Question 2

What are some advantages of learning a relational database?

Answer 2

• A quality of many relational databases is that they support good guarantees about data integrity. They can store and modify data in a way that makes data corruption as unlikely as possible. This means that developers can set up their database to reject “bad” data and not worry about data being “half written”.
• Relational databases are arguably the most widely used kind of database
• Knowing the SQL language is a very portable skill given that there are so many relational databases driven by almost the same language.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

Use the “top” command in the terminal