Melodious Games

Melodious Games

The blog of a proud and noble software developer.


Featured

[Amazon Redshift] Converting unix epoch time into timestamps

Posted on .

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…

Featured

[Windows 8] Fuzzy Text Issue

Posted on .

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 wor…

Featured

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

Posted on .

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 and bot…

Featured

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

Posted on .

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 open…

Featured

[40K] Imperial Date Generator

Posted on .

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 …

Featured

Using postgreSQL on Ubuntu (with node.js)

Posted on .

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 gui…

Featured

Redis: Delete all keys LIKE

Posted on .

Sometimes in Redis you want to delete a mass of keys that were created accidentally, there are too many to clear out one by one and FLUSHDB is certainly out of the question. For those of you who are more familiar with the SQL family, MySQL for instance, you ma…