The Joy of Hex

Drunken Monkey Coding Style with a hint of Carlin humor

MySql default timezone

Apr 30, 2016 - 5 minute read - MySql

So lately we have been hitting some interesting egde cases (at least to us) while using the MySql on RDS and in local when using the CONVERT_TZ functions.

MySql database statistics

Apr 19, 2016 - 4 minute read - MySql

One of the projects we are involved with has a data store in RDS, recently I had to figure out the size of the tables and one of the databases. As RDS does not report this diectly, I had to dig through some internet to get my answers, and this post is the result, having all the queries in one place, so next time I need it, I can find it with ease.

To Hugo and Beyond

Apr 2, 2016 - 2 minute read - octopressmigrationhugo

So… It has come to this… Again… I moved from Wordpress a long time ago in favor of Octopress, version 2.x at the time. It worked beautifully, for a while, and then it was time to update, and it was messy, as it did not have a separate content from theme, but I chugged along, it wasn’t like I was writing much. Then a few months ago I wanted to use Octopress 3, and it was a mess, and when I finally got it running, my alloted time was at an end.

On Speakers and Speaking

Feb 1, 2015 - 3 minute read - conferencesspeaking

I started giving talks in various user groups and regional conferences last year, I felt I had something to say, and I got a chance do to it. <sarcasm>now that makes me an expert!!!111</sarcasm> I believe that every developer should at least once stand in front of an audience and give a talk. If you have ever considered giving a talk, you have my utmost support, I know it does not mean much to anyone, but hey… If you actually submit your talk to your UG or some conference, and get a chance to stand in front of an audience (and by audience it is any number of people larger than 1) you have my utmost respect.

Sublime Text psql build system

Apr 11, 2014 - 3 minute read - Sublime TextPostgreSQLautomation

Today I got to work with [Amazon Redshift][aws-redshift]. First thing I did was go through their docs on how to connect to the server.

I tried [Workbench/J][workbench-j] and it works, it is ugly as hell, and requires Java (not a big problem, but I’d avoid it if I can). Then I went to the psql and tried it, but damn, that syntax is long before I got to the good part.