Be fucking serious
357 karma · joined October 23, 2018
Be fucking serious
(Btw there are 3.5mm to lightning adapters that let you charge while listening, just not made by Apple)
> I'd suggest porting to key/value pair DBs like mongo or firestore.
Why? The data set feels pretty "relational" to me (contests have divisions, divisions have scorings and results, results have players, players have sponsors) and seems to fit SQL. To be fair though, I've not used Mongo or Firestore or a NoSQL db in general before.
The "scorings" part is the only thing that tripped me up designing a schema since it varies between divisions in a contest as well as between contests themselves, so I ended up w/ a JSONB column for scoring rubric for divisions and then in the results table there's both final_score and scoring_breakdown columns, the beakdown being another JSONB column w/ the individual category results.
2016 article: http://osxdaily.com/2016/01/12/howto-sideload-apps-iphone-ip...
Their name is John Bolton and they're the National Security Advisor of the USA.