Using Postgresql To Perform Tasks In A User Local Time Zone

One of the benefits of side projects is giving yourself a chance to see new solutions to problems you have already tackled.For nearly seven years, KickoffLabs has had the option to send weekly or daily emails about the previous days progress to our customers. To try and keep it relevant we have always done our best to send it around 8 am local time.To accomplish this, we grab the users timezone when they sign up and then have a cron job set up to execute every hour.