phpMyAdmin Designer

Flashback to 1997. phpMyAdmin with the Designer view gives us an Access-ish design space with InnoDB-supported foreign keys, whee! For some stupid reason it’s a little tricky to set this up – you have to set up a special phpmyadmin database to track the extra layout information, and then configure phpMyAdmin to use it.

(continued…)

I updated my Google framed results script that I use every day on my portal. Try it out and let me know what you think! Free attaboy to the first user. See the wiki for details.

UPDATE: v0.03, mo betta. Use the same link above.

To get around this, just turn off “automatically select mirror” and you’ll get the nice full list of mirrors to select from. In my case, it was repeatedly selecting software-mirror.com, even though it was not up-to-date and kept failing. Switched to a Georgia Tech mirror and I was golden.

Window->Preferences->Install/Update->Automatically select mirrors-> uncheck
Help->Software Updates->Find and install...->Search for updates->Finish
(the mirror selection screen appears)

iptraf is great to quickly monitor network usage. Just don’t forget Heisenberg’s uncertainty principle (or, to be more technically correct, the observer effect) – using iptraf over a proxied ssh connection adds about 6.6 kbps of usage just for the tool used to measure usage. Fun fun! :>

Here’s a script that you can run to measure bandwidth in the background, removing some of the overhead of trying to visually display in realtime the very thing you’re measuring:

#!/bin/bash

if [ -e /var/log/iptraf/bandwidth.txt ]
then
    rm /var/log/iptraf/bandwidth.txt
fi

export SAMPLETIME=1
export SLEEPTIME=62
iptraf -B -t $SAMPLETIME -i all -d eth0 -L bandwidth.txt
sleep $SLEEPTIME
cat /var/log/iptraf/bandwidth.txt|grep kbits

TurboTax Online worked out marvelously once again for me this year, this time using Gentoo linux AMD64 + Firefox 2.0 + KGhostView (for PDF’s) + Gentoo’s nsplugin wrapper for 64-bit-browser flash support + my bank website (which uses PDF’s and flash(?!)) + OpenOffice Calc (for a worksheet to crunch charity numbers, medical expenses, etc.). The Turbotax “compatibility check” stated that you need Windows or Mac OS X, but linux took me from start to filed with zero problems, including always-available help and access to a great community-driven FAQ system that made even my fairly complex tax return as simple and clear as possible. Whee!