Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Ask HN: What database should I use for analytics data?.
It uses continuous aggregations so you don't need to manually run rollups every few mins/hours. You don't need to store individual events so it's better for user's privacy.
Here's the link to the sql - https://github.com/sheshbabu/freshlytics/blob/master/src/ser...
There are no comments on this comment yet.
It uses continuous aggregations so you don't need to manually run rollups every few mins/hours. You don't need to store individual events so it's better for user's privacy.
Here's the link to the sql - https://github.com/sheshbabu/freshlytics/blob/master/src/ser...