New ARC site is up!
My new website on the JFK Assassination Records Collection is now up at jfkarc.info. Stop on by!
-
Recent Posts
Categories
- Book reviews (9)
- History (61)
- Intelligence (4)
- JFK ARC (48)
- Republican China (7)
- Linguistics (3)
- Literature (5)
- Music (1)
- Programming (9)
- Quotidiana (9)
- Recycled papers (2)
- Research methods (8)
- School (34)
- Site news (4)
- Software (12)
- Translation (5)
- Uncategorized (1)
- Writing (1)
Archives
Links to my pages
Category Archives: Programming
Merging two tables in mysql
This is something I occasionally want to do, but I have usually forgotten how to do it, so the recipe goes here on the back of my giant online envelope. There are two ways to merge two tables. One involves … Continue reading
Posted in Programming
Comments Off on Merging two tables in mysql
Group on table joins
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
Posted in Programming
Comments Off on Group on table joins
How to select/display all rows with duplicate values in MySQL
(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
Posted in Programming, Software
Comments Off on How to select/display all rows with duplicate values in MySQL
Capturing system command output in perl
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
Posted in Programming
Comments Off on Capturing system command output in perl
Fixing textwidth in vim
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
Posted in Programming, Software
Comments Off on Fixing textwidth in vim
Mechanized Moodle
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
Posted in Programming, School
Comments Off on Mechanized Moodle
perl win32 OLE arcana: 1
problems with perl Win32 OLE: error 0X800a03ec Continue reading
Posted in Programming
Comments Off on perl win32 OLE arcana: 1
UTF-8 and utf8: Another piece of the puzzle
A case where UTF-8 and utf8 in perl made an important difference. Continue reading
Posted in Programming
Comments Off on UTF-8 and utf8: Another piece of the puzzle
Stupid programming tricks: #1
how to redirect messages and errors from your perl script to a file in the same order that they appear on your screen. Continue reading
Posted in Programming
Comments Off on Stupid programming tricks: #1