Show Databases, Tables and Columns in PostgreSQL

Man….why is it that every time I stop using PostgreSQL for more than a month I immediately forget how to list tables and columns? Here’s a listing for posterity. Show Databases MySQL: SHOW DATABASES; PostgreSQL \l Show Tables MySQL: SHOW TABLES; PostgreSQL \d Show Columns MySQL: SHOW COLUMNS; PostgreSQL \d+ tablename Show Yourself Out (exit) […]

Changing the Screen Resolution for Raspberry Pi in Debian Wheezy

The Raspberry Pi has two video outputs, an HDMI output and some stanky old component composite video output that you would expect to see on the back of an old VCR. Using the HDMI output on a newer LCD screen will result in an amazingly crisp image that is quite impossible to read unless you […]

Raspberry Pi VS. Netbooks

The Raspberry Pi was released in February after a development period where it was touted as being an affordable computer for schoolchildren, and immediately sold out to a horde of greedy neckbeards. The two companies doing the manufacturing are still making batch after batch to sell to all of the people who backordered it, myself […]

Simple Dropdown List Example in VB.NET

VB.NET and creating dropdown menus are perhaps the two most annoying aspects of the .NET framework, and a close third is trying to track down .NET information that isn’t written in C# or populated with database queries. What if you want an incredibly simple representation of an HTML dropdown menu that is handled through Razor’s […]

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 […]

Raspberry Pi Ordered and Shipped

The impossible has happened. The Raspberry Pi that I wished to buy back in February finally became available. The order has been made, and it is now due to arrive in mid-September, 7 months after the initial hysteria. Since my first blog posts, I have seen a lot of search queries bringing people to this […]

Netbooks and Tablets

Exactly 2 years ago I ordered an Acer Aspire One from Walmart.com, doubling down on trashhiness yet being blown away by the quality offered by both. For 220 dollars and free shipping, I ended up getting a tasty 1.6GHz processor, 1 gig of RAM, a scrumptious 160 Gb HD, and a deliciously useful Atheros network […]

Apache Won’t Start in XAMPP

You may have encountered a situation in XAMPP where you press the “start” button for the Apache service, you see the green “Running” message for a moment or two, and then the service fails without error. There are two likely culprits for this situation. 1) Another service is using port 80 Port 80 is the […]

Getting Mp3s From a Website Via Source Code

There are plenty of websites that through obfuscation, make it difficult to save the content on them. Most people don’t realize that in order to view or experience the content on a website, all of that data must first be downloaded to their computer. If you visit a webpage that has a song playing, and […]