Wubbadub/ClubHub

Implement Database

Closed this issue · 4 comments

bndnio commented
  • Choose DB type
  • Spin up
  • Interface with web server/routing
Inschato commented

We need to determine exactly what our data we're manipulating, relations they have, and expected load. I think regardless we should just choose PostgreSQL because Jason Trill strongly suggested it and it's highly likely it will do everything we need it to. There are node libraries available for it too, of course.

Inschato commented

Spun up the empty DB and created some basic user partitioning.

Time to date: ~3 hours research, ~1 hour implenting

hwkr commented

@Inschato can you work on getting the server to talk to the database? Just pushing and pulling values at this point.

Inschato commented

New branch on https://github.com/Wubbadub/ClubHub/tree/feat/12/db

Implemented:

  • API get request for site data (It currently doesn't check if the site's active flag is set or not)
  • unused API calls for creating and updating sites

To do:

  • user related API calls (getting and saving user data)
  • update timestamps in appropriate places (when updating a site)
  • optionally add timestamps to admins relation (to track how long someone has been an admin for a particular site)
  • directory related API (probably a separate feature/issue)