Recent submissions

Comment · 5 months ago
“Just abandon your hobbies and interests!”

Be fucking serious

Comment · 6 months ago
Expenses were more on purpose, they amortized a bunch of hardware depreciation now instead of over 5-7 years with the new tax changes. This is pure greed
Comment · 6 months ago
Prince is a sociopathic liar
Comment · 4 years ago
No, I definitely still use Git on solo projects, there’s no reason not to do so.
Comment · 4 years ago
if you had a lossless source then sure, otherwise lossy to lossy transcoding is not great.
Comment · 4 years ago
which interestingly enough can also have things abbreviated, ie Invoke-Web-Request can be used as iwr.
Comment · 4 years ago
They stopped including it a while ago, I think they stopped with the XS.
Comment · 4 years ago
Or, if you get a wired->BT adapter like the FiiO uBTR, it’s another device you have to remember to keep charged.

(Btw there are 3.5mm to lightning adapters that let you charge while listening, just not made by Apple)

Comment · 5 years ago
"Bet. Enjoy!" works for both.
Comment · 5 years ago
This looks super interesting and basically exactly what I was looking for in a db product, definitely going to be checking this out!
Comment · 5 years ago
I've heard a lot of good things about Linode over the years, they slipped my mind while thinking of the more manual options. I'll have to check them out!
Comment · 5 years ago
Seen GAE referenced across several comments and apparently Snapchat started on GAE as well (lol not that this has any chance or even need in the big success case of scaling up so much) so it's definitely something I will look into!
Comment · 5 years ago
GAE/Cloud Run are certainly possibilities, I'll have to look into them.

> 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.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton