Output a Postgres or MySQL Query to CSV

I find myself needing to output CSV from database queries a lot, and like an Alzheimer’s patient I am constantly forgetting how to do it. Here’s the quick run-down on how you get queries from your database into a CSV file. Postgres \f ‘,’ \a \t \o /tmp/output.csv SELECT column_id, column_name FROM table_name; \o \q […]

Block Trend Micro’s Bots

Trend Micro is a company famous for its anti-virus software, yet not very famous for its invasive website crawling. It isn’t exactly something that the company would want to make public, considering how hypocritical the actions are. Websites have files named robots.txt, which tells search engines and other bots areas that are off limits, but […]

Hosting Japanese Exchange Students

Education things The Japanese folks that study in America all end up improving their English drastically, even in short amounts of time. Here in Japan, even though the people are clever, the education system is so incredibly broken and ineffective that they never reach their full potential until they go overseas. Japanese education involves a […]

North Korea’s Constitutional Reboot

With North Korea’s constitutional reboot, all mentions of communism have disappeared. The country has doubled down on it’s concept of juche, or “self-sufficiency”, which is a terribly ironic term for their “constantly beg other nations for help” strategy. While conceived in 1979, the concept of juche only really took off once the USSR fell and […]