postgres Flashcards
What is PostgreSQL and what are some alternative relational databases?
An open-source relational database. Others include MySQL, SQL Server (Microsoft), and Oracle
What are some advantages of learning a relational database?
They are good for storing related data. They can store and modify data in a way that makes data corruption as unlikely as possible. Also, they are arguably the most widely used kind of database.
What is one way to see if PostgreSQL is running?
sudo service postgresql status / top
What is a database schema?
A collection of tables that defines how the data in a relational database should be organized
What is a table?
Where relational databases store data (tables can also be known as relations). A list of rows, each row having the same set of attributes (columns)
What is a row?
Each row in a table makes a record of the “spreadsheet”
What does express.static() return?
middleware
What is the local __dirname variable in a Node.js module?
the directory name of the current module
What does the join() method of Node’s path module do?
joins all given path segments together
