Lesson: Using PostgreSQL

Lesson overview

Install & setup PostgreSQL in Express

Lesson outline

The following items define the scope of the lesson. The lesson outline is flexible; you can improve, expand, and omit items whilst writing lesson content (make sure the pull request description mentions that).

• Brief introduction to PostgreSQL
• Instructions on installing PostgreSQL on Linux/MacOS (use an external resource if too lengthy)
• Instructions on setting up PostgreSQL via node-postgres in Express
• Code examples of basic querying
• Ask learners to go back to mini message board project and implement the database

Acceptance criteria

If the requirements here are not met, the work effort is not complete.

• Lesson conforms to the outline above (unless outline has been modified).
• Lesson follows our Layout Style Guide.

Additional information

Get the lesson template

Download the lesson template using the following command (replace lesson_name with the actual lesson name):

curl -o <lesson_name>.md https://raw.githubusercontent.com/TheOdinProject/curriculum/main/templates/lesson-template.md