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

11–20 of 126 posts

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

#11

Post by ushakov »

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

funny to hear that

i actually migrated from Wordpress to Zola

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

#12

Post by ushakov »

eatonphil wrote: post #6
tjwds wrote: post #5

Earlier quoted context omitted.

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

Check out this thread for recommendations on static site generator plugins on top of Wordpress. Best of both worlds for folks who want high-level publishing. https://news.ycombinator.com/item?id=31396961

you don't even need those

a cache with long-enough TTL will do the magic for you

https://mish.co/posts/always-cache-your-website/

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

#14

Post by [deleted] »

ushakov wrote: post #12
eatonphil wrote: post #6

Earlier quoted context omitted.

Check out this thread for recommendations on static site generator plugins on top of Wordpress. Best of both worlds for folks who want high-level publishing. https://news.ycombinator.com/item?id=31396961

you don't even need those a cache with long-enough TTL will do the magic for you https://mish.co/posts/always-cache-your-website/

[deleted]

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

#16

Post by minimaxir »

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_CONTAINS(title, "Ask HN: Who is hiring?")
    )

    SELECT FORMAT_TIMESTAMP("%Y-%m", `timestamp`) as year_month,
    COUNT(*) as num_toplevel_posts
    FROM `bigquery-public-data.hacker_news.full`
    WHERE parent IN (SELECT id FROM whoishiring_threads)
    GROUP BY 1
    ORDER BY 1
Which results in something like this: https://docs.google.com/spreadsheets/d/13yGlJzFpVzZ-WNHAOsdo...

Still a bit of room to clean up the query, though, and there are some differences from the chart in the post.

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

#17

Post by speakspokespok »

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.

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

#18

Post by ryandrake »

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 actually hiring anyone. Was going to call it "Who's Not Hiring?"

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

#19

Post by pm90 »

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 just want to say, in a comment that furthers the discussion in no way, that having something like this available for free is just incredible.

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

#20

Post by tedmiston »

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

Putting the Cloudflare CDN free plan in front should solve the hug of death problem.

https://www.cloudflare.com/performance/ensure-application-av...

Post reply on HN