Heads up, I have added something that I think you will find useful. I have added a MySQL reference to the Library! This is more than a cheat sheet, I try to explain the things that are going on in there as we do it, so it should be a good way to not only see how to do specific things, but also understand them as well. Check it out here and see what you think, if you see anything wrong with it or you have some tip of you own you’d like me to add, drop a line and let me know. Enjoy!
Archive for the ‘How To’ Category
2
Solarum’s MySQL Reference
23
Labeling Hard Drives In Linux
Recently I got another external USB hard drive for backing up data. I plugged it in and everything was great except for one thing. The drive came up with the name (label) that Seagate put on there by default. So I was looking a drive mounted at “/media/FreeAgent Drive”, ugh, that sucks. So, I did a little digging and came across this awesome article that covers the many different ways to label your drive. It was interesting that it all basically comes down to your file system, but this article has most everything covered. Check it out …
30
64-bit Linux Running Google Gears In Firefox
Description and Problem:
Google Gears is a plug-in that extends your browser to create a richer platform for web applications. There are many Web applications that currently make use of Google Gears. Some of these include Google Docs, Google Reader, MySpace, Picasa, Zoho and (the reason for this post) now even WordPress. Google Gears, or simply just Gears as it is now known, not only enables offline browsing of supported sites, but it can also greatly improve the performance of these sites and web applications like WordPress. This makes working with supported web applications much nicer.
Now, my problem (and many others of you out there) has been that I am running 64-bit Ubuntu (8.04 Hardy Heron) and Google has not made a 64-bit version of their Gears software. They cite lack of time and testing resources, but my guess is it’s not that important to them since there probably aren’t too many 64-bit users out there. Luckilly for us, Gears is an open source project. This is now a prime example of the beauty of open source software, in that some really smart people created an “unofficial” patch that allows you to install and run Gears on 64-bit Linux in Firefox. In my case it’s Ubuntu and Firefox 3.x, but I have read folk that have had success with SuSE and others as well. It only took me about five minutes once I found the patch.
Here are the steps I took to get this installed, up and running:
Grab the latest version of the Gears binary that has been patched for 64bit at http://www-personal.umich.edu/~swolchok/gears/, I used this command:
wget http://www-personal.umich.edu/~swolchok/gears/gears-linux-opt-0.4.9.0.xpi
Open Firefox and choose File->Open File and browse to where you saved the file you just downloaded. It should open an install window, you want to press the “Install Now” button to start the install.
Once the install is complete, press the “Restart Firefox” button to restart Firefox and complete the installation.
Summary:
For me, upon the initial restart, I got an error about this addon not being compatible with my architecture. Despite that it seems to work fine, and I haven’t gotten any more errors since then, so I would suggest you simply ignore that error.
Lastly, go to a site that is supported, add it to Gears and enjoy! If you have any questions or comments, post ‘em below.
16
PowerUp Your Shell With Your Profile
How about some neat-o shell tricks for everyone to play with? I figured out some neat things the other day while trying to add some functionality to my shell, specifically through scripts or the profile. What I found was that the magic is in the profile!
Have you ever wanted to have commands that performed certain functions from quick keystrokes rather than long command lines? Of course you have, that’s why we all set aliases in our profiles like ‘ll’ instead of ‘ls -al’ and the like. But what if you want or need more functionality than simple command shortening? That’s what I was after, more function in a smaller form. Some way to pass variables to aliases to get more out of them. Ah, but you can’t pass variables to aliases, so we are stuck right? Wrong, that’s where the functions come in to play.
6
Update to the PERL round function
Mr. Thierry H. was kind enough to post a comment with a nice little mod to the PERL round function I posted a while back. With his addition, you can now specify how many digits to show on the right of the decimal. Pretty neat, check it out.
27
apt-get quick reference
For all you Debian and Ubuntu nuts out there, and especially the newbies, there is a nice little apt-get quick reference that has been added to the library. Take a look and get to apt-ing!



