Readme Topics

Possible topics:

Why Postgres / SQL databases (or not)?

• SQL vs NoSQL databases:
  • differences
  • pros and cons
• When to use which and why? Give example use cases.
• Why do some projects use both?

Choosing tables structure and joining

• Best practices in table structures (e.g. normalization)
• What is a primary key and why is it useful?
• How do you join separate tables?
• Differences between inner / outer joins
• Give a practical example of a database with at least 2 tables.

PG with Node and Heroku

• How to connect to a local pg database from your node server;
• How to apply some SQL commands of your choice to retrieve and modify a database;
• How to create a heroku test app with postgres and access the database with SQL commands:
  • from node;
  • from the command line.

Importing, exporting and migrating databases

• How to import databases from an existing project
• How to export databases.
• Migrations in Postgres.

Script Injections

• What are HTML script injections?
• What are some examples?
• How can you protect against them in your apps?

Testing databases

• If not mocking the database, how do you ensure you don't fill your database with test insertions?
• Research and figure out how to use a mocking library.
• What are some advantages and disadvantages of mocking?
• What exactly needs testing about the database?