This website has been made using Node.js, EJS, Express.js and MySQL.

To run this application locally, make sure you have MySQL, Node.js, and NPM installed on your machine.

Setup

Dependencies

To install Node dependencies:

npm install express ejs mysql body-parser

Database Setup

The sql/ folder contains files that can be ran to create the database & insert dummy data. Make sure you have generated the database before running the server. If there is nothing in the database, the websites may show up blank.

If you're running MariaDB instead of MySQL, run create_db_arch.sql instead.

Start Server

Start the server by running node index.js.

---

TODO

• Topic index page
• User index page
• User profile page
• Post index page
• Set up SQL database & scripts
• Post submission page
  • Check for topic membership
• FIX : change membership columns to utilise user & topic names instead of IDs
  • Make user & topic names their primary keys?
• Put topic name in post URL
• User search functionality
• Post search functionality
• Topic search functionality
• Registering
• Create topic page
• Add a 'Join Topic' button

---

Extensions

• Login/logout
• Ability to delete posts
• Comments/replies
• Styling/front-end design
  • Colour scheme
  • Credentials pop-up
• User/topic profile pictures
• Render posts with markdown