Moving these posts to Saturday morning's, so this'll be a bit of a shorter update than usual. Now that the plants vs zombies section of the course is complete we are moving on to 3D development from here on out. It's a nice change

This has been a particularly fun week of gamedev. The current course project has wrapped up (just finished lecture 181), a clone of plants vs zombies, and I get to start on a completely new course project starting tomorrow~ Click here to play in your browser [https://valkrysa.itch.io/

What a way to get a weekly dev blog started off right, one good week of progress followed by two weeks in the desert with little computer access! First a quick dev update and then see below for vacation pictures. Well in the few days of the week before I

Normally in PostgreSQL you could convert to_timestamp(myunixtime) however according to the Redshift documentation [http://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html] this particular function is not available for Amazon Redshift [http://aws.amazon.com/redshift/]. As an alternative if you would like to convert a

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

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

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. [http://www.valkrysa.com/2017/03/14/experiments-40k-date-generator/] I've published

In this post I'll detail how to connect to a postgres database (like Amazon Redshift [http://aws.amazon.com/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

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 may

For awhile now MySQL Workbench would crash about a fourth of the time when trying select tables to alter via the UI. Just typing out the raw queries to alter, update, etc worked just fine but trying to use the UI to do anything would result in a crash rather