News for hackers. Stuff that matters.

A comment on Hacker News Activity Analysis with GPT-4 Agent. Parent comment

Re:Hacker News Activity Analysis with GPT-4 Agent by supportengineer on Wednesday December 20, 2023 @02:45PM (#38712752)
>> janky lookup table of every date in existence

Having a date dimension provides an elegant solution in many cases.

[ Parent | on HN ]
Re:Hacker News Activity Analysis with GPT-4 Agent by posting_mess on Wednesday December 20, 2023 @02:57PM (#38712876)
If I was analysing TB's of data via SQL, yeah i'd probably agree its better not incur the transfer overhead to perform this check - if it was small org, id say its not great.

Also once you start saying "i want secondly/minutely breakdowns", the dimension (neat term) gets pretty...large (probably less than the TB of data though)

[ Parent | on HN ]
Re:Hacker News Activity Analysis with GPT-4 Agent by nonethewiser on Wednesday December 20, 2023 @02:54PM (#38712848)
Joining against a generated series is also trivial.
[ Parent | on HN ]
Re:Hacker News Activity Analysis with GPT-4 Agent by tomrod on Wednesday December 20, 2023 @02:52PM (#38712823)
It can. A function that generates date objects between two date objects is also pretty performant for specific uses.
[ Parent | on HN ]