postgres-into Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
PostgresSQL a powerful, free, open source Relational Database Management System (RDBMS).
Oracle Database, MySQL, Microsoft SQL Server
2
Q
What are some advantages of learning a relational database?
A
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.
They use the SQL language
For when an application needs to quickly retrieve or store complex data in an organized fashion, a database fills that need nicely.
3
Q
What is one way to see if PostgreSQL is running?
A
sudo service postgresql status
