postgres-intro Flashcards

1
Q

What is PostgreSQL and what are some alternative relational databases?

A

is an open source Relational Database management system. it is the most advanced open source databased of its kind. MongoDB, Redis, Neo4j (nosql)

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

What are some advantages of learning a relational database?

A

when working with datas that are interconnected to each other. Something with relationship.

They provide good guarantees about data integrity.
Can store and modify data in a way that makes data corruption as unlikely as possible.

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

What is one way to see if PostgreSQL is running?

A

sudo service postgresql status also in top

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