Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Hacker News “Who is Hiring?” top-level comments over time

blog.joewoods.dev

Post reply on HN
Print view View original

21–30 of 126 posts

Re: Hacker News “Who is Hiring?” top-level comments over time

#21

Post by tedmiston »

minimaxir wrote: post #16

A reminder that all Hacker News posts and comments are available on BigQuery and can be queried for free: https://console.cloud.google.com/marketplace/details/y-combi... (the `full` table is up-to-date; ignore the others) Here's a query for a rough reproduction of what's asked in the title: WITH whoishiring_threads AS ( SELECT id FROM `bigquery-public-data.hacker_news.full` WHERE `by` = "whoishiring" AND REGEXP_CONTA…

I suppose that massive spike is the beginning of the pandemic.

It's interesting to see March 2020 (the highest month of all time) and April 2020 (the lowest month since early 2016) back to back.

Re: Hacker News “Who is Hiring?” top-level comments over time

#22

Post by jeffbee »

ryandrake wrote: post #18

I started and abandoned a little side project a while ago where I wanted to see which employers tended to have the exact same (or fuzzy-the-same) "Who's Hiring" post month after month. Goal would be to find some signal about which posts were actually resulting in hiring (in other words, the company didn't come back with the same posting) and which ones were just trawling for the same job month after month without act…

You know I've wondered that about companies that post hiring announcement here constantly, in particular Tesorio ( https://news.ycombinator.com/from?site=tesorio.com ) which as far as I can tell post every time the rate limit permits them to do so. After 7 years are they a healthy successful company or is it just endless spam?

Re: Hacker News “Who is Hiring?” top-level comments over time

#23

Post by paxys »

tjwds wrote: post #2

Thanks for hugging my site to death! It's hosted on a $5 DO droplet and I'm honored to have this problem. https://archive.ph/AVbPV

A $5 DO droplet will easily handle peak HN traffic with a bit of optimization. Set cache headers, cache static assets on the server side (or even better, with an external CDN), or even cache the entire page if there's no dynamic content.

Re: Hacker News “Who is Hiring?” top-level comments over time

#24

Post by leet_thow »

jeffbee wrote: post #22
ryandrake wrote: post #18

I started and abandoned a little side project a while ago where I wanted to see which employers tended to have the exact same (or fuzzy-the-same) "Who's Hiring" post month after month. Goal would be to find some signal about which posts were actually resulting in hiring (in other words, the company didn't come back with the same posting) and which ones were just trawling for the same job month after month without act…

You know I've wondered that about companies that post hiring announcement here constantly, in particular Tesorio ( https://news.ycombinator.com/from?site=tesorio.com ) which as far as I can tell post every time the rate limit permits them to do so. After 7 years are they a healthy successful company or is it just endless spam?

Their last funding round was a Series A nearly 3 years ago.

Re: Hacker News “Who is Hiring?” top-level comments over time

#25

Post by freedomben »

tjwds wrote: post #5
eatonphil wrote: post #3

Earlier quoted context omitted.

Do you serve static files? Static file server on a $5 DO droplet should handle the HN front page. There's also free tiers on many CDNs like Fastly/Cloudflare. Github Pages is also free.

I used to use zola hosted on Github Pages, but I wanted to improve the publishing workflow, and WordPress was a good fit for that. (Notes on the migration here: https://blog.joewoods.dev/technology/technical-notes-on-migr... )

I run a few big sites on WordPress, and would totally recommend you use the simply static plugin, and configure nginx to serve those cached files directly so it never hits php. I also usually put cloudflare in front as well, but you can have a screaming fast wordpress site that scales really far by itself without it just with that trick.

If you need some dynamism, w3 total cache is also a great choice.

If you're not an nginx hacker, there are some great examples around the internet. This page is pretty helpful: https://wordpress.org/support/article/nginx/

Re: Hacker News “Who is Hiring?” top-level comments over time

#26

Post by Frotag »

coip wrote: post #8
andrewxdiamond wrote: post #4

Earlier quoted context omitted.

For simple static sites like this, sticking a default Cloudflare stack in front helps a lot

you’d (I’d) think ~managed cdn serving an s3/blob origin would be a no brainer. Hell, GitHub pages even: BYODomain, + hosting/automation/cdn… Where’s the free lunch in that line of thinking? which cases are a droplet better in?

Being able to recycle the vps for other self-hosted apps is nice (eg vpn, dns-level adblock, etc).

Also not having to learn another tech for something you'd only have to set up once every year or few years.

Re: Hacker News “Who is Hiring?” top-level comments over time

#27

Post by tjwds »

speakspokespok wrote: post #17

Your blog post starts by discussing posts being down this month (June 2022) but the graph provided starts in 2011. For the sake of the discussion, a second graph that starts June 2021 to current, and in monthly increments would be more enlightening. Because ultimately I think that's what we all want to know. In your copious free time would you mind adding that? Thank you for writing this.

Sure: https://dev.joewoods.dev/img/june-to-present.png

But my website seems to have disappeared, so I'll have to update the post later!

Re: Hacker News “Who is Hiring?” top-level comments over time

#29

Post by [deleted] »

minimaxir wrote: post #16

A reminder that all Hacker News posts and comments are available on BigQuery and can be queried for free: https://console.cloud.google.com/marketplace/details/y-combi... (the `full` table is up-to-date; ignore the others) Here's a query for a rough reproduction of what's asked in the title: WITH whoishiring_threads AS ( SELECT id FROM `bigquery-public-data.hacker_news.full` WHERE `by` = "whoishiring" AND REGEXP_CONTA…

[deleted]

Re: Hacker News “Who is Hiring?” top-level comments over time

#30

Post by polote »

paxys wrote: post #23
tjwds wrote: post #2

Thanks for hugging my site to death! It's hosted on a $5 DO droplet and I'm honored to have this problem. https://archive.ph/AVbPV

A $5 DO droplet will easily handle peak HN traffic with a bit of optimization. Set cache headers, cache static assets on the server side (or even better, with an external CDN), or even cache the entire page if there's no dynamic content.

Even without optimization. Peak HN traffic is in the 20 req per second order of magnitude
Post reply on HN