basically what happened is my roommate told me about an idea for some project that they don't have the time to make, and ever since then i've been obsessing over that, and that's why it's 1:31 am now and i'm trying to troubleshoot a monstrous postgres query filled with date comparisons and timezone sensitive stuff and gtfs edge cases
after some more fiddling i made it probably maybe work with results that might indeed be what i need
and this was just one single yak i had to shave for this project's backend
wish me luck