postgres-intro

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

PostgreSQL is a powerful, free, open source Relational Database Management System (RDBMS). Other popular relational databases include MySQL, SQL Server by Microsoft, and Oracle by Oracle Corporation

Question 2

What are some advantages of learning a relational database?

Answer 2

Many problem domains can be modeled well using a relational database. If you are storing related data, then a relational database is probably a good first choice! 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. Relational databases are also arguably the most widely used kind of database.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status