jmonster/tsohg

Coding challenge - Submission

Live demo at https://ghost-challenge-submission.herokuapp.com

Pre-requisites

easy -- using the preconfigured database

• Node.JS (and npm) must be installed

less easy -- rolling your own database

• Node.JS (and npm) must be installed
• PostgreSQL's ltree extension and uuid-osp extensions must be installed in the DB
• Update .env to appropriate values
• Run graphile-migrate watch in addition to npm start; see Graphile Migrate for more information

How to run

npm install
npm start

Future improvements

• use a built/pruned version of Tailwindcss
• avoid global javascript (e.g. RelativeTime)
• the "upvotes" table should use the logged in user's uuid (rather than users_name)
• shouldn't rely on client/server code to keep the DB consistent; use an on-create hook to increment the value in the "comments" table or consider other strategies to cache this value
• minify public/javascripts/app.js
• indicate which comments have already been liked by the current user using color
• pagination and/or lazy-loading for longer comment threads

Preview