Tuesday, February 3, 2009

Helix3 2008R1

So, I recently was asked to get data off of a laptop for a friend. I took the laptop home with me and noticed that I left my old Helix CD at my parents' house. "Not a big deal, I can just download the latest iso!"

So first thing I noticed was the use of Gnome, but wait, look further, it's actually Ubuntu! Cool! But wait, I just want to recover some data and I don't need Gnome to be running, it costs too much overhead! Bah!

I was not even able to append a boot parameter to boot in console-only mode (or at least I wasn't able to find one). Fine, I got the files off anyway!

I also noticed an "install" option. That's cool! Maybe I'll be more curious and even test it out.

Cheers!

UPDATE
Ok, silly me! To go about booting into console-only mode the answer was really just in my face! If you hit F6 at the Helix menu, you can edit the boot parameters. Just delete splash and that's it! Though, Gnome still loads so you'll just have to do a Ctrl+Alt+[F1-F6] to get to one of those console screens.

Thursday, January 29, 2009

Winmail.dat Attachments For Linux Thunderbird

This is only going to be a rant and a link to Andrew Beacock's blog post solving that pesky winmail.dat attachment issue for linux users.

I never had this issue until this morning when a project manager sent over an email with an attachment.

Sheesh Microsoft, can we stop making the proprietary apps please!?

Friday, January 23, 2009

Regular Expressions in MySQL

Do you need to limit your SQL results and LIKE '%foo%' isn't giving you a narrow enough result list?

Well, I'm sure you know how to narrow down those SQL results with a regex! So all there is to it is the REGEXP operator! Yay!

Example:

SELECT * FROM table WHERE column REGEXP 'data[0-9]';


You get the point; now enjoy! Cheers!

Friday, January 16, 2009

MySQL Search and Replace

I recently had to update some information in MySQL. Yes, I'm sure you're thinking, "yea, so...that's easy!". But, the way the data was entered in the column was more like an entire paragraph! The information I needed to change was only a last name in the paragraph. So, obviously I didn't want to type out the entire paragraph again with my edits just so i can UPDATE the table. So instead, MySQL has a nice replace function built in. Yay!

The code will look as follows:
UPDATE your_table set your_column=replace(your_column,'Smith','Jones');

And now your_column will replace all occurrences of "Smith" with "Jones".

Cheers!

Wednesday, January 14, 2009

Hello, Android SDK


So in an attempt to stay on budget and yet keep myself entertained through this recession, I finally set up my Android SDK on one of my computers. I also finished up my first app! Ok, ok, so it's the generic "hello world" app that all newbies start off with, but hey I still haven't decided what I'd like to build. It's always just fun to tinker around a system anyway.
Let the fun begin!

Cheers!

Tuesday, January 13, 2009

Where's My Ubuntu Screensaver Admin?!

I think this will probably be more of a reminder for me, but in case anyone else has this curious issue with Ubuntu Gutsy Gibbon, then read on!

For whatever reason, I do not have "Screensaver" listed under System>Preferences. I'm using XScreenSaver since gnome-screensaver seemed to just freeze after any amount of time. Anyhow, if you need to configure your settings for XScreenSaver all you need to do is type in xscreensaver-demo in a shell. Tada!

Sheesh, I had to google that every time and then follow it up with a "doh!" once I read what to do!

Cheers!

Tuesday, January 6, 2009

It's 2009 and I Am Back!

Well, it has been over two months since my last post. I have been unfortunately out of ideas on what to blog about. So, perhaps I will slowly stray away from my usual format of blogging about technical recipes and code to bantering on about anything random. Hmmm...we'll see.

Anyhow, happy 2009! I was given an awesome present of a [t-mobile] G1. Yay! I've only had it for a little bit over a week now, but it is awesome. I've managed to get root thus far; but stay tuned for more updates.