New ARC site is up!
My new website on the JFK Assassination Records Collection is now up at jfkarc.info. Stop on by!
Category Archives: Programming
This is one of the more confusing issues of table joins. To make it extra confusing, try an outer join: Select * from ta as a left outer join tb as b on a.key = b.key Both tables have duplicate … Continue reading
(This should be a fub, but the description is too long.) One of the most frequent uses of database tables is to identify duplicate values in your data. Assume you have a table with a list of names, and you … Continue reading
Running system commands from inside a perl script is one of the nastiest of all perl headaches. I suffered grievously when trying to use this method with some pdf file addons, and have scars to show for it. Lately, having … Continue reading
I have had several problems with my program editor Vim recently. Here is how I fixed one of them. There are two directories that I had to mess with: c:\program files\vim [vim directory] c:\users\rabbit [user directory] the vim directory is … Continue reading
One of the main things I use Perl for is to manage my grading chores on Chi Nan University’s Moodle system. Moodle is a very useful teaching tool, one I’ve been using for over 10 years. So if it’s such … Continue reading
A case where UTF-8 and utf8 in perl made an important difference. Continue reading