Postgres Intro Flashcards

1
Q

Why do we use databases in Web development?

A

Store information, to access the information across multiple devices, secure centralized data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is PostgreSQL and what are some alternative relational databases?

A

An open source relational database, MySQL, SQL, Oracle, SqlLite

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are some advantages of learning a relational database?

A

Its a great place to store data and understand where the info you need is stored

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is one way to see if PostgreSQL is running?

A

TOP , sudo service postgresql status

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

what does PgWeb do

A

Grabs your postgres database and visualizes it for you.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly