@ian_h Wow, that sounds like a true nightmare. I'd wager nobody there ever looked at the database values too.

I like that... "store in the DB as UTC, no exceptions!"

My worst nightmare was developing a booking funnel application for a well-known auto glass replacement company in the US. The development and hosting was in the UK, but the company insisted that the date/time info was stored in the EST timezone due to HQ being in Columbus, Ohio IIRC, and it had to be "humanly readable" in the database too (no unix timestamps etc... why? your guess is as good as mine!).

This was an absolutely massive nightmate having to do conversions between the dates/times with the server set to UTC.... but then of course, there was something like 48 or so States to cover too... a couple of which I found out at the time don't follow summer time changes either. This was back in ~2009.. the application was written using ZendFramework, that was hosted inside of a "page" component in Typo3... I'll leave the rest to your imagination 😃

I wonder if there are any companies working on a nice GUI or mobile app to hook into a Github and set this up automatically. Not that it's hard to do ourselves, as you've demonstrated, but I can imagine that being a potentially useful SaaS.

Thanks all! I really appreciate the feedback!

Yeah, I've definitely got stuck in the "try again, still broke" loop before. These tips and prompts are great. Thanks!

Love the way you structure your lessons. Speedrun some bits, explain each step of the way. Really good stuff!

Oh and I am 100% guilty of doing the "it didn't work, try again" and adding layers of slop to my vibes 🤣

Taking good notes!

I like that prompt. Going to start using it in my daily workflow. Thanks!

Nice method! It's similar to a style that I've figured out over the past couple of months. Telling it to write a markdown file and open a new chat is a common thing I do, and it seems to help.

Just in case anyone else is looking for it:

https://research.trychroma.com/context-rot