postgress-intro

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

PostgreSQL is a Relational Database Management System. Alternatives include MS SQL server and mySQL

Question 2

What are some advantages of learning a relational database?

Answer 2

• they are arguably the most used type of database, therefore knowing the SQL language is a transferable skill
• good if you are storing related data (data about teachers, classrooms, and courses for example)
• 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 devs can set up their db’s to reject bad data and not worry about data being half written.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status

Question 4

what is the pgweb command

Answer 4

a web server that gives you a page to connect with and interact with your database

pgweb is a middleman between your browser and data management system (postgresSQL)