Week8_Skills

Full-stack project with all the JS knowledge gained in "Turn into coders" bootcamp.

General purpose

At the end of our bootcamp period we've decided to group in a web application all the JS knowledge

User stories

As a user I want to:

1. see JS skills in a "tree view".
2. filter skills by:

• bootcamp prerequisites
• bootcamp learning outcomes
• others (post bootcamp)
• bookmarks

3. bookmark skills i'm interested in:

• favorites
• already known
• interested to learn

User mapping

Wireframe

Setup 💻

• clone Repo
• create a Postgres DB importing our db_schema.sql & db_data.sql
• npm i
• run with npm run dev for local testing

Try it on Heroku!

• user example: [email protected]
• password example: iannis

Stretch goals

Repository structure

• server.js
• public
  • index.html
  • main.css
• src
  • router.js
  • handler.js (could several files)
  • database
    • db_connection.js
    • db_populate.js
    • db_schema.sql
    • db_data.sql
  • queries
• test

Database schema

2 tables:

• users
  • id (auto incremental)
  • username
  • email
  • PASSWORD
• posts
  • id (auto incremental)
  • title
  • content
  • like BOOLEAN
  • FOREIGN KEY (user_id) REFERENCES users (id)