[Amazon Redshift] Converting unix epoch time into timestamps

Normally in PostgreSQL you could convert to_timestamp(myunixtime) however according to the Redshift documentation this particular function is not available for Amazon Redshift. As an alternative if you would like to convert a unix timestamp (seconds from epoch) into a more useable timestamp you can use the following code…

[Windows 8] Fuzzy Text Issue

After having switched to Windows 8.1 recently I discovered that certain programs would appear to have fuzzy text. Searching Google for the answer led to many fixes which were on a program by program basis involving DPI scaling, however I found one fix that worked for me and fixed…

[Tools] Javascript Multi-line String Builder (and other things too!)

One thing that I find myself doing often as a server dev is taking SQL queries and turning them into strings for use in a server side script. In PHP or any other language that supports multi-line strings out of the box you can simply add a " at the top…

[ubuntu] Screen and cursor tearing when using external monitor.

Just a quick tip to any readers that have encountered issues with screen tearing and mouse trails in Ubuntu when using multiple monitors the following seems to help somewhat. First things first you'll need to be able to gain some control over compiz (your opengl compositing manager in unity). This…

[40K] Imperial Date Generator

Warhammer 40,000 is probably among my favorite universes and so it was an easy decision to make when I was choosing what would be my first GitHub contribution. A live demo can be viewed via this link. I've published a first release of some Javascript that can be used…

Using postgreSQL on Ubuntu (with node.js)

In this post I'll detail how to connect to a postgres database (like Amazon Redshift) with Node.js on Ubuntu and hopefully help you avoid some of the common pitfalls I fell into a few times. I'll go into Redshift and why we're using it another day but this guide…