postgres-intro Flashcards
1
Q
What is postgreSQL and what are some alternative relational databases?
A
An open source and free relational database. Uses SQL as the querying language. Alternatives include: MySQL (also free), SQL server by microsoft, and oracle by oracle corp.
2
Q
What are some advantages of learning a relational database?
A
Good for storing related data. Support good guarantees about data integrity. Makes corruption of data least likely. Relational databases are very flexible and forgiving.
3
Q
What is one way to see if PostgreSQL is running?
A
‘top’ command in your dev-env or use ‘sudo service postgresql status’ ‘sudo’ means super user do
