Information gathering: a JSON file or a pre-mae DB weren't available, an manual entry wasn't an option.
2
Speed: for immediate responses and data access.
Solutions
1
Web Scraping: information has been scraped from Supernatural's Fandom Wiki website using Puppeteer.
2
LowDB: compared to traditional DBs like MongoDB or Postgres, lowdb allows to work on local JSON files.
Project status
The project is deployed on Render and collects a few users every month. Of course this is a recreational API, so it is only used by students looking to learn HTTP requests. The API is listed on Marcels Cruz repository public-apis, which collects free APIs. Future improvement include the use of a more advanced database and and query optimization. I created a documentation page using Bootstrap and GitHub pages, available in the links section.