Cheat Sheets
August 5, 2005 | 40 Comments
I love cheat sheets or euphemistiically, quick references. I find myself becoming quite familiar with something, then not using it for 6 months. After time away from something like that a cheat sheet is the best way of getting back up to speed quickly. Also, good cheat sheets sometimes show me features or functionality I wasn’t previously familiar with. Consider this Cliff Notes for technology.
JavaScript, MySQL, mod_rewrite, CSS, and PHP(Thanks Casey)
VI (PDF)
Perl Regular expressions (PDF)
Java (PDF) (Not so quick…)
Update 2/20/06:
Prototype JS Library - from BorkWeb.
Still looking for a good one on Oracle and always looking for better ones. Also check this site for some more, though I’m not real excited about most of them.
Tags: cheat sheet, cheat sheets, cheatsheet, cheatsheets, cliff notes, css, development, java, javascript, mod_rewrite, mysql, oracle, perl, php, quick guides, quick reference, regular expressions, vi, web, web development
Installing mytop
July 15, 2005 | 3 Comments
Anyone who’s done much MySQL administration probably knows about mytop. mytop is basically a top clone for MySQL. Hugely useful if you want info about what your database is up to, but don’t necessarily have pr want MySQL Administrator installed.
I decided to install this on my FreeBSD box, though I’m sure the instructions would be similar on OSX, Solaris, or any other unix flavor. Sometimes the installation can be cumbersome and everytime I do it I find myself fumbling around trying to remember what I did last time. Unfortunately my systems administration skills aren’t always as solid as I like. So here goes.
1) Get mytop
2) unpack it in some directory (tar xvf mytop-1.4.tar.gz)
3) add in the necessary perl modules (assuming you don’t already have them)
perl -MCPAN -e shell
then at the cpan prompt:
install DBI
install DBD::mysql (this one may fail if your root password for localhost is set. in this case do `force install DBD::mysql`)
install Term::ReadKey
install Term::ANSIColor
install Time::HiRes
4) In the directory where you extracted mytop execute:
perl Makefile.PL
make
make test
make install
5) You can then execute it like:
./mytop -u<user> -prompt -h<hostname>
6) For additional options see: perldoc mytop. Also try hitting ‘?’ when running mytop for runtime options.
Tags: cpan, database, database administration, freebsd, install instructions, mysql, osx, perl, perl cpan, solaris, sql, systems administration, unix