frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

Show HN: I made Google Trends for Hacker News by indexing 18 years of comments

https://hackernewstrends.com
331•ytkimirti•2h ago

Comments

ytkimirti•2h ago
Hello HN,

This was a small project of mine after I've found out that I can simply the whole hackernews archive (~48GB) and play around with it.

You can compare terms just like in google trends and you can also see the exact posts & comments from that time.

I like that you can discover what went crazy in the timeline, they just come up as small burst of activity, it's quite fun to play around with it. https://hackernewstrends.com/?q=litecoin&q=dogecoin&q=solana...

I also have a seperate page for the "Who is Hiring?" posts, here is the distribution of programming languages over each monthly "Who is hiring?" post in HN ever. https://hackernewstrends.com/who-is-hiring

Any kind of feedback is welcome.

jupr•1h ago
Honestly the HN archive is very valuable. If you had it all on a local db with everything indexed you basically end up with a offline search engine.

Where is this archive located you speak of?

fragmede•1h ago
It's on firebase, per https://github.com/hackernews/api
cbeach•1h ago
This is excellent.

A minor suggestion - I'd like to be able to render the current graph taller (full height of my browser window).

Also some sentiment analysis on the "people" graphs would be very insightful (particularly for the likes of Edward Snowdon, Julian Assange, Elon Musk and Sam Altman). Perhaps colour the area under the graph red-orange-green based on the sentiment?

ytkimirti•44m ago
Thanks for the feedback, noted the full-screen request.

The sentiment analysis is very interesting, I can do that easily. Could be a new page as well. Did you see this anywhere else or just your idea?

cbeach•40m ago
Just my idea. I'm working on a side project https://newsavista.com/invite/ASAD68923E that aggregates news and tracks news trends and changing sentiment on the major stories. With cheap cloud LLMs (and "free" local LLMs) it turns out to be a trivial feature to build.
clacker-o-matic•1h ago
ooh this is sick! really nice ui too!
NoSalt•1h ago
Woah, great work!

I am really liking the trend for "linux": https://hackernewstrends.com/?q=linux

dgellow•1h ago
Funny how closely that tracks with windows

https://hackernewstrends.com/?q=linux&q=windows

addandsubtract•1h ago
Does the trend only show absolute numbers? Because I think it should be divided by the number of posts during the time frame (day?).
oystersauce8•1h ago
love it
simonpure•1h ago
Hug of death

` /api/hn -> 504 An error occurred with your deployment FUNCTION_INVOCATION_TIMEOUT cle1::c8vgv-1782399959042-aeba3cae05ff `

aNapierkowski•1h ago
yeah we killed it :(
jjordan•1h ago
back in my day we called this a good ole' fashioned slashdotting.
lysace•1h ago
Our startup (~20 people) got slashdotted in 1998 or so. I was the only one randomly awake at the time. Remember watching all the logs from our web server in realtime, ready to immediately kill anything or anyone threatening the overall availability.

512 kbps uplink, I think. Even accidental DoS was trivial. We had a self-hosted little data center at our office with the only available stupidly expensive commercial connection.

Felt some dread having to restart the main (async, single-process) web server a few times to keep things going due to bugs in our code. So many* people on dial-up patiently waiting for the page to load.

It was exhilarating though :).

*) Surely at least a hundred!

mysterydip•40m ago
One of the things I love about HN is having stories like this in the comments from otherwise random unassuming usernames
Onavo•
vachina•1h ago
This is the only HN submission I ever upvoted because it is amazing
frankzero•1h ago
I know right
fragmede•1h ago
If more people spent time on /new looking for awesome stuff and vouching for dead items, HN would be a better place.
ytkimirti•1h ago
Thanks, it was my first ever post here as well, would you look at that
scarecrw•1h ago
Very cool!

I'd love to have some sort of normalization option to separate more subtle positive trends from the general increase in number of posts.

GL26•1h ago
insane ! I don't know if it's possible but it would be huge if we had access to the localisation of the trends
some_furry•1h ago
https://hackernewstrends.com/?q=furries&q=furry

Hmm, did I break something?

dom96•1h ago
Very cool idea. Shows programming language trends pretty well.

https://hackernewstrends.com/?q=Nim&q=Rust&q=Zig

docheinestages•1h ago
But can it discover new trends without having to type the keywords?
flakiness•1h ago
The example comparisons made me smile. Well done!
lazystar•1h ago
nice. i guess AWS still had nothing to fear from GCP/Azure. ty for this
sinuhe69•1h ago
IMO, using AI to assign keywords to a broader group of strict synonymous keywords would make the comparison much more helpful.

Because in general we want to know the trend of categories more than of a word, asking for “auto pilot” for ex. should include “self driving”, FSD etc.

marky1991•1h ago
I would not like this. This is the kind of change that made google search so annoying. (Eg what if I want to track the history of 'self-driving' vs 'auto pilot' in sales pitches? Or more basically, what if the system wrongly interprets me wrongly?) Better to support | or similar old-fashioned search engine syntax and dwis and not dwim.
Pikamander2•1h ago
Synonym functionality is good as long as there's an easy way to disable it, either globally or by wrapping the term in quotes.
cloudkj•1h ago
This is great, I was just hoping to find a tool like this and specifically scoped to "Show HN" posts? Is there a way to do that?
ytkimirti•1h ago
Great idea actually, I'll add that as well for sure
rightbyte•1h ago
Nice. Is the data points y-axis normalized by total amount of comments at that time?

Edit: Nvm seems like absolute count if you click the graph.

jdw64•1h ago
COOOOOOOOOOL!!!!!!
drchaim•1h ago
too slow or broker right now
ytkimirti•1h ago
We had to take the site down for a second, it'll be online in a few minutes. Thanks for trying it out
smalltorch•1h ago
Reminds me of this side project I'm working on.

https://gitlab/here_forawhile/torum

It's a HN clone, that syncs with HN that allows you to basically establish smaller private communities who can discuss anything that's on HN without actually being on HN.

It also indexes and let's you search through the DB which I find is really useful to find things that peak my interest.

hk__2•1h ago
Fixed link: https://gitlab.com/here_forawhile/torum
all2•30m ago
*pique

'peak' refers to the top of a thing, commonly mountains

joelres•1h ago
Really beautiful, informative, and functional layout. Great work!
chris_money202•1h ago
Love this, seems to struggle with newly indexed words. Will try again when the FP load is gone
arjie•1h ago
One useful feature would be to normalize by total so that I can see changes in something as opposed to just total site growth. Right now I have to chart a single generic parameter but if I pick poorly it’ll confuse the issue.
jahala•1h ago
Really cool! Where would you get the data for something like this? Is it open, or its scraped?
kaelyx•1h ago
Hello, /api/hn -> 502 {"error":"Your database has been temporarily rate-limited, please contact support@upstash.com for further details."}
NooneAtAll3•1h ago
I'd be interested in "google ngram for hacker news" instead
ytkimirti•46m ago
What is missing from it? I've used ngrams as well and I this was partly inspired by that.
ProofHouse•1h ago
Yup your upstash is rate limited
corv•1h ago
The 'flash vs html5' chart looks strange juxtaposed with that conclusion
al_borland•32m ago
There are a few technologies with pretty generic names which don’t lend themselves so well to this kind of trend analysis.

I was curious about Atom. According to the trend it’s still neck and neck with VS Code. But are people really talking about Atom the text editor that much still, or other types of atoms?

fg137•21m ago
I think Google Trends is actually smart enough to suggest which topic you want to see for the same keywords -- it understands the semantics.
igcorreia•48m ago
The colors of the lines of the big graph are inverted compared to the smaller ones.
bluecoconut•48m ago
Very cool!

one subtle consistency bug that made it hard for me to interpret when I was clicking around: the small thumbnail plot vs the full plot often (always?) seem to use different colors.

The blue / orange gets assigned to the opposite labels in the A vs. B when you click, which made it confusing to understand.

mkgeorge7•43m ago
This is actually very cool!
mkgeorge7•43m ago
This is actually very cool@
SoKamil•35m ago
Are those raw numbers or adjusted for active users at given point in time?
kpw94•35m ago
The huge spike of "lk-99" in science & frontier tech is amusing...

This is cool concept, would love a positive/negative sentiment computed for each comment that refers to a given word, so you can see trends of "cloudflare (positive)" vs "cloudflare (negative)" where first one counts comments only if sentiment confidence is greater than say 0.6 and the other one counts comments only if sentiment is less than 0.4 (assuming [0,1] sentiment score)

k33n•28m ago
This is quite useful at-a-glance
Aachen•27m ago
Google Trends is about searches

This is about published text. More like if Google Trends counted word occurrences on webpages. Or if Google Ngrams counted webpages instead of books

People don't write much about non-newsworthy things whereas many people search "burger" anytime they want a burger delivery. The datasets aren't usable in the same way

morkalork•16m ago
Now if Algolia had a dataset of what people are searching for on HN that'd be it
Aachen•10m ago
Was considering that as well, but I doubt that people use Algolia in the same way that they use Google
Aachen•7m ago
Someone asked an imo good question (that I was going to vouch for, idk why it was dead), but deleted it. Not sure why, but so I'll not credit the username in case they don't want that and changed some words for stylometrics avoidance

> The concept seems pretty comparable. From the title I had a good idea of what it was; when clicking on it, the visual presentation felt familiar & intuitive. \n\n Being a little less literal can be useful!

That's why I'm pointing it out: the title leads you to think they're the same metric, the page looks visually similar, and so you treat it as the same data type; but when you read the data through this lens, you draw wrong conclusions. It took me a while, scrolling down the examples, before I realised why it felt so off and that my mindset is wrong. It's what's being written about currently, not what people on HN are actually looking for

It's indeed not about being nonliteral, it's for me about having been confused about the data being shown

linzhangrun•24m ago
Great job! I've also been wanting to do similar statistics recently, wanting to know when LLMs becoming the absolute dominant topic on HN. Now it seems like half of the posts were about LLMs.
zX41ZdbW•22m ago
I host a publicly open database with Hacker News data at https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...

So you can create any sort of similar services in a single SQL query and an HTML page.

I also hosted it as a publicly accessible data lake, which you can query from everywhere: https://github.com/ClickHouse/ClickHouse/issues/29693#issuec...

It is also updated in real-time.

jtolmar•21m ago
It looks like some of these terms aren't indexed (or the site is just too hug of deathed right now), but I'd like to see the graph of like, social media, iot, cryptocurrency, ai.

The transition between crypto and ai on the graphs is already pretty funny. https://hackernewstrends.com/?q=crypto&q=chatgpt

Cider9986•19m ago
Scrolling is totally broken for me.
dwoosley•18m ago
Almost all of the major vulnerability and hack are just single spikes at the time it happened and it tails off after that… except Stuxnet. Stuxnet is was much more interesting that most other attacks since it was very political and openly published. Of course, the thing that attack was about is still a news headline today as well
ltrg•17m ago
It would be super interesting to see if HN mentions serve as a leading indicator of company performance/valuations -- I wouldn't be surprised.
thomasgeelens•17m ago
oeeh hug of death, congrats!
stopachka•16m ago
Nice! Would love a brief explanation of the infrastructure. I see the Powered by "Upstash Redish Search", but why choose Upstash Redis Search vs something else?
chfritz•10m ago
great idea! Now, you are running into the same issue Google Trends had to solve: term disambiguation. For instance, "atom" is ambiguous in a comparison of editors like this: https://hackernewstrends.com/?q=sublime&q=atom&q=vscode. Given LLMs it might be possible to use an embedding vector (with context) instead of a text string for indexing, and if you do, this problem might go away.
Insanity•8m ago
This looks quite nice! But suspiciously absent data points.. no Java or Go for the languages? Seems odd. No Amazon in companies, yet I think it's often mentioned.

I wondered if "go" got filtered out because it's also just a regular word.

Either way, very cool!

1h ago
Its funny that these days the bottleneck is usually the data layer. Servers are so powerful now that even your average $5 server can handle HN levels of load if configured correctly.
docheinestages•1h ago
If this project is an ad for their product (Upstash, promising "Highly Available, Infinitely Scalable"), then the last thing they'd want is a hug of death :/
ryan_n•1h ago
Oof that would be hilarious/tragic
steve1977•1h ago
Downstash
y1n0•1h ago
Must stash
ytkimirti•1h ago
We will be with you shortly :)
Roonerelli•1h ago
I get

/api/hn -> 502 {"error":"Search entry should have an initialized schema, command was: [\"SEARCH.AGGREGATE\",\"hn\",\"{\\\"$or\\\":[{\\\"title\\\":{\\\"$eq\\\":\\\"anthropic\\\",\\\"$boost\\\":5}},{\\\"text\\\":{\\\"$eq\\\":\\\"anthropic\\\"}}]}\",\"{\\\"by_month\\\":{\\\"$dateHistogram\\\":{\\\"field\\\":\\\"time\\\",\\\"fixedInterval\\\":\\\"30d\\\"}},\\\"top_authors\\\":{\\\"$terms\\\":{\\\"field\\\":\\\"by\\\",\\\"size\\\":6}},\\\"by_type\\\":{\\\"$terms\\\":{\\\"field\\\":\\\"type\\\",\\\"size\\\":4}}}\"]"}

superxpro12•1h ago
/api/hn -> 502 {"error":"Your database has been temporarily rate-limited, please contact support@upstash.com for further details."}
esafak•1h ago
A cache would help.

Show HN: I made Google Trends for Hacker News by indexing 18 years of comments

https://hackernewstrends.com
342•ytkimirti•2h ago•84 comments

Deno 2.9

https://deno.com/blog/v2.9
43•enz•34m ago•5 comments

Ford rehires 350 engineers after AI fails to preserve expertise or train juniors

https://www.bloomberg.com/news/articles/2026-06-25/ford-has-been-rehiring-quality-inspectors-afte...
433•alanwreath•1h ago•201 comments

Zig's New BitCast Semantics and LLVM Back End Improvements

https://ziglang.org/devlog/2026/#2026-06-25
88•kouosi•2h ago•22 comments

You can't unit test for taste

https://dev.karltryggvason.com/you-cant-unit-test-for-taste/
167•kalli•1d ago•65 comments

Apple increases MacBook and iPad prices by 20%

https://www.ft.com/content/0f067265-2baf-4b6e-8fb2-ed56daef6f3c
210•bazzmt•2h ago•157 comments

Half-Life 2 in a Browser

https://hl2.slqnt.dev/
529•panza•10h ago•216 comments

Tw-fade: pure CSS scroll-driven edge masking

https://pete.design/tw-fade
24•petekp•3d ago•7 comments

Anthropic says Alibaba illicitly extracted Claude AI model capabilities

https://www.reuters.com/world/china/anthropic-says-alibaba-illicitly-extracted-claude-ai-model-ca...
682•htrp•21h ago•1110 comments

Show HN: Turn native language audio into flashcards and shadowing practice

https://lingochunk.com/try
44•alder•5h ago•23 comments

Windows 10 quietly gets one more year of support and updates

https://www.neowin.net/news/windows-10-quietly-gets-one-more-year-of-support-and-updates/
29•bundie•57m ago•12 comments

LastPass notifies users of yet another data breach

https://9to5mac.com/2026/06/23/lastpass-notifies-users-of-yet-another-data-breach/
331•mooreds•6h ago•147 comments

OpenAI unveils its first custom chip, built by Broadcom

https://techcrunch.com/2026/06/24/openai-unveils-its-first-custom-chip-built-by-broadcom/
786•jamdesk•23h ago•449 comments

SoftBank 2026 AGM [pdf]

https://group.softbank/media/Project/sbg/sbg/pdf/ir/investors/shareholders/2026/shareholders-meet...
33•dmmalam•4h ago•8 comments

Wikipedia Workers in Britain set global first by seeking union recognition

https://utaw.tech/news/wikipedia-recognition
194•chobeat•9h ago•182 comments

Cloudflare launched self-managed OAuth for all

https://blog.cloudflare.com/oauth-for-all/
298•terryds•14h ago•130 comments

Show HN: MiniPCs.zip – Charting the Pareto frontier of Mini PCs

https://minipcs.zip
45•yathern•4d ago•22 comments

IBM Debuts First Sub-1 Nanometer Chip Technology

https://newsroom.ibm.com/2026-06-25-ibm-debuts-worlds-first-sub-1-nanometer-chip-technology
7•porridgeraisin•1h ago•0 comments

Puzzling Success of Overparameterization: Lottery Tickets or Escape Dimensions?

https://infoscience.epfl.ch/entities/publication/9a49779b-f9f8-448d-b3d1-737c78455309
38•rbanffy•1d ago•7 comments

Blogging can just be stating the obvious

https://blog.jim-nielsen.com/2026/blogging-stating-the-obvious/
383•Curiositry•17h ago•116 comments

Lianda and the Long March

https://blog.georeactor.com/books-06-26b
8•mapmeld•1d ago•0 comments

Medical students are using popular research tool to pump out misleading studies

https://www.science.org/content/article/medical-students-are-using-popular-research-tool-pump-out...
133•rndsignals•14h ago•72 comments

Bohemia Interactive: Cold War Assault Remastered Source Code on GitHub

https://github.com/BohemiaInteractive/CWR
167•dewey•2d ago•42 comments

LuaJIT 3.0 proposed syntax extensions

https://github.com/LuaJIT/LuaJIT/issues/1475
208•phreddypharkus•16h ago•130 comments

Physicists Track and Trap the Elusive Neutrino

https://www.quantamagazine.org/how-physicists-track-and-trap-the-elusive-neutrino-20260624/
5•ibobev•1h ago•0 comments

GLM-5.2 is a step change for open agents

https://www.interconnects.ai/p/glm-52-is-the-step-change-for-open
336•vantareed•2d ago•192 comments

Dostoyevsky isn't difficult

https://www.autodidacts.io/dostoyevsky-isnt-difficult/
213•surprisetalk•3d ago•269 comments

Show HN: StartupsBR – A map of Brazilian startups

https://www.startupsbr.com/sao-paulo
49•leonagano•6d ago•22 comments

RubyLLM: A Ruby framework for all major AI providers

https://rubyllm.com/
439•doener•1d ago•75 comments

Show HN: Secs-man, a secrets manager you can (not) rely on

https://github.com/Fran314/secrets-manager-rs
18•Fran314•4h ago•14 comments