Skip to content

A full-stack web application for managing and displaying courses in a CV format, built with Node.js, Express, EJS, and a PostgreSQL relational database. Built as part of the Backend-Based Web Development course at Mid Sweden University utilizing a template repo.

License

Notifications You must be signed in to change notification settings

sarasjodin/my-express-pg-course-lab

Repository files navigation

my-express-pg-course-lab

Open Live Demo

App Status


About this web app

A full-stack web application for managing and displaying courses in a CV format, built with Node.js, Express, EJS, and a Postgres relational database.


User interface for managing CV courses User interface for managing CV courses

Features

  • ✅ Users can add, list, and delete courses stored in a Postgres database
  • ✅ Server-side form validation using validator and custom logic
  • ✅ Course data includes code, name, syllabus URL, and progression (A/B/C)
  • ✅ Responsive layout built with semantic HTML and CSS
  • ✅ Clean URL routing using Express Router
  • ✅ EJS view engine for dynamic server-rendered pages
  • 🔍 Focus on accessibility, data integrity, and simple modular structure

Tech Stack

  • HTML / CSS / JavaScript
  • Node.js / Express.js
  • EJS (Embedded JavaScript Templates)
  • Postgres
  • dotenv
  • validator / sanitize-html (for input validation & sanitation)
  • Render (for server deployment)
  • GitHub (for version control and repo management)

Installation

npm install
npm run dev

More About This Project

A full-stack web application for managing and displaying courses "in a CV format", built with Node.js, Express, EJS, and a Postgres relational database.

Users can:

  • Add new courses via a form
  • View all stored courses
  • Delete (and optionally update) courses

Each course includes:

  • Course code,
  • Course name,
  • Syllabus URL,
  • and progression (A–C)

Includes server-side validation, responsive layout, and follows best practices in backend web development. Built as part of the Backend-Based Web Development course at Mid Sweden University.


Folder Structure

part of folder structure Part of folder structure

Security

  • ✅ Dependabot active
  • ✅ Security policy configured
  • ✅ Automatic CodeQL analysis

License

MIT – see LICENSE.md for details.


About

A full-stack web application for managing and displaying courses in a CV format, built with Node.js, Express, EJS, and a PostgreSQL relational database. Built as part of the Backend-Based Web Development course at Mid Sweden University utilizing a template repo.

Topics

Resources

License

Security policy

Stars

Watchers

Forks