Hwalgi/Pine
Empowering student voices
hwalgi.org pine.hwalgi.org
Motivation
Hwalgi is a nonprofit that publishes student essays in order to amplify younger representation in modern discourse.
Spec
Hwalgi is a completely custom, ground-up publishing platform and CMS. It's optimized to run at the lowest possible cost and has a focus on accessibility and usability for non-technical users. It includes a frontend for published articles, a submission portal for both submitting works and checking on the status of submissions, and a frontend for reviewers to view, edit, approve, and reject submissions and published works.
Technical Details
Hwalgi is submission-based, and those submissions go through a form that then forwards those POST requests to a Google Sheets endpoint. There's some AppScript work on the Google Sheets side, alongside more crude formula work. Certain parts of the spreadsheet are then posted to an online endpoint that the frontend fetches from and processes.
Pine is not submission based, so it uses a Python script and Github Actions to convert a custom markdown-like file format to templated HTML on commit.
Challenges
Finding brand unity between the two sites without making them indistinguishable was an interesting exercise in what to keep and what to change.
With Hwalgi, finding a way to use tools like Google Sheets and Google Forms for more complicated and programatic tasks than they were intended proved difficult, especially with caching and limitations on the side of Google Sheets. Ultimately, using these products helped keep operational costs down.