MYSQL – Create CSV File With Fieldnames For Headers

October 19, 2014

Recently, I went to dump a MYSQL table into a CSV file, with the fieldnames in the first line of the file.




This simple enough in Oracle’s SQLPLUS, so I did some internet searches to determine the syntax.

Instead of the simple MYSQL syntax, I found a number of relatively complex solutions. Some involved MYSQL scripts, and others utilized Unix string parsing commands.

However, I came up with a much simpler solution using one simple MYSQL command:

Read the rest of this entry »


Installing Gimp on Redhat 6.4

October 4, 2014

Gimp is the GNU Image Manipulation Program. It is a freely distributed piece of software for tasks like photo retouching. I wanted to use it to crop photos, like Irfanview does so easily on Windows.

Unfortunately, like so many other software installations on Redhat Linux, the install was not straightforward and required overcoming errors. 😦  Here’s how to install gimp on Redhat 6.4.

gimp - GNU Image Manipulation Program

gimp – GNU Image Manipulation Program

Read the rest of this entry »

Installing Talend Open Studio For Big Data 5.5.1 on Redhat 6.4

September 20, 2014

Recently, Talend Open Studio For Big Data was recommended for me, so I thought I’d try it out.

But as I’ve so often encountered with Java on Linux, the install was a long process, full of java error stacks, google searches, research, trial and error, debugging, forum posts, and so on. Sigh, not again!

Here’s what I did to get Talend Big Data to install and work.  Big errors I encountered are detailed at the bottom.


Talend Open Studio 5.5.1

Talend Open Studio 5.5.1


Download Talend Big Data Software:

Read the rest of this entry »

Install Sqlite And Query Firefox Log Files Using SQL

September 10, 2014

Firefox saves a lot of log information in RDBMS files that can be queried in sqlite, using standard SQL commands.




To query the files, you have to have the right version of sqlite. Turns out that an old version was installed with my Redhat Linux 6.4 installation and I had to upgrade it in order to see the data. Here is how you can install the software and query the logs.


When I ran sample sqlite queries I found on the web, I got lots of errors:

sqlite3 ./cookies.sqlite 'select count() from moz_cookies'
Error: file is encrypted or is not a database

Read the rest of this entry »

Four Ways To Install Software On Linux

September 9, 2014

New to Linux?  Here’s some information that might be useful.

Linux is different from Windows in how software is installed. In Windows, starting with a CD, DVD, or an executable file, you run an executable file and install the software, usually via a GUI with prompts.


Redhat Desktop

Redhat Desktop


However, in Linux, there are at least 3 or 4 different ways to install software:

rpm packages
yum (related to rpm)
Unzip a file into a directory
Run an executable file or script   Read the rest of this entry »

Statistical Analysis on Changing Work Values in the USA

June 18, 2014


Statistical analysis of the USA General Social Survey (GSS) data shows that work values changed radically after the 2008 recession. What used to be the most important value, “Work important and feel accomplishment” became the least important. What used to be the least important values, “Short working hours”, and ” No danger of being fired” became the most important in 2012.


Core Values

Core Values



Background:   Read the rest of this entry »

The Variability of Resumes In The Hiring Process – Irrational Behavior

June 15, 2014

This spring I took an online course from Coursera, Irrational Behavior, as taught by Dr. Dan Ariely. It was a fascinating course, one that I enjoyed immensely.

Irrational Behavior with Dr. Dan Ariely on Coursera

Irrational Behavior with Dr. Dan Ariely on Coursera

See my comments on the course from my previous post on Irrational Behavior and Hoarding.

The other writing assignment in the course, was to “Design An Experiment”.  In this course, “experiment” refers to a psychological experiment.  Not a physics, chemistry, or computer science experiment.

From the guidelines – “Design An Experiment” – Please include the following in your paper:
A brief summary of previous (relevant) research. Be sure to use and cite at least one piece of research or theory that your experiment builds on.
Research question. What do you want to find out?
Your hypothesis. What do you think you will find?
A brief overview of the proposed design including identification of your independent and dependent variables.  For more details, check out this guide.
Implications. If your study turns out the way you expect it to, what does that mean?


I’ve often thought of the shortcomings of resumes. As so, in many ways, using resumes is rather irrational.  So, I designed an experiment to test the variability of resumes. Read the rest of this entry »

%d bloggers like this: