Category Archives: Programming

Timezone Solution for mySQL

I am new to SQL languages and I recently spent about two hours trying to bring some order to timestamps in my PTM project. It was obvious that I should store universal UTC/GMT date/times in the database. It was not so clear how to convert these back to local time. Examples I found on the […]

A Video Script That Degrades Gracefully

A few years ago I was looking for a clean way to embed mp4 video into my blog. Prior to HTML5 the best approach was a¬†Flash-based video player. Of course there is no Flash on iPhones and similar devices. Plus many people avoid Flash because of bugs and security concerns. So I modified this script […]