Author Archives: admin

Postgres dump to CSV

Posted on September 7, 2011 by admin

I was recently having an issue doing a dump to a CSV file from psql command line. Some bug with a permissions error. The fix was to do run it from the shell like so: $ psql -c “COPY (SELECT … Continue reading →

Posted in postgres | Leave a comment

Useful Linux Command Reference

Posted on September 1, 2011 by admin

A list of a bunch of day to day commonly used linux commands. General Commands #copy a folder using scp (use -r) $ scp -r /path/to/folder user@hostname:/path/to/destination/ #create a symlink $ ln -s /destination/folder /origin/folder #remove directory and its contents … Continue reading →

Posted in linux | Leave a comment

WordPress MySQL Setup Commands

Posted on September 1, 2011 by admin

I do this so often that I wanted to create a little reference tutorial of MySQL command needed to get your WordPress install up and running. MySQL Commands First we are gonna create the database for this WordPress install. I … Continue reading →

Posted in mysql, wordpress | Leave a comment

Install PHP on CentOS

Posted on September 1, 2011 by admin

Installing PHP is as simple as running the following yum command $ yum install php If you also need support for MySQL in your PHP install then also run the following: $ yum install php-mysql You will probably also need … Continue reading →

Posted in mysql, php | Leave a comment

Beginner HTML5 Game Development – Part 5: Multiple Key Press

Posted on August 30, 2011 by admin

One common issue we will have to face with making our games is multiple keypress events, meaning we will press multiple keys at the same time. For instance if we have an avatar that we want to move diagonally and … Continue reading →

Posted in Games, HTML5 | Leave a comment