Just professionally, I'm curious whether they derive has_not_been_viewed_much by... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

noduerme 25 days ago | parent | context | favorite | on: Has_not_been_viewed_much

Just professionally, I'm curious whether they derive has_not_been_viewed_much by some nightly cron process, by an insert trigger on a `user_image_viewed` table, or by some monstrous full table join that HN is currently obliterating.

zach_garwood 25 days ago [–]

There's a scheduled task that runs every month to pull the view data from Google Analytics:

https://github.com/art-institute-of-chicago/data-aggregator/...

https://github.com/art-institute-of-chicago/data-aggregator/...

The site hasn't been hugged to death yet,

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact