Mmmm blog.

Well, I might be a bit behind the news, but I am definitely excited about this!

Let’s face it, Glee isn’t quite perfect (as much as I wish it was). Since it’s inception it’s received mixed reviews, and I can’t help but agree with opinions from both sides.

Glee was still wavering in the first half of season one I think, and I reckon Joss Whedon could ride in on his musical-horse and do something about that.

Joss Whedon rocks.

I like Joss Whedon’s writing and directing, as do many. His ability is proven, and I think he has a knack for creating real drama and emotion that audiences connect with, always encapsulated and/or intertwined within that clever subtle humour (eg. Buffy, Firefly).

(How could we forget that totally awesome musical episode of Buffy: Once More With Feeling?)

From the look of the most recent episodes, and what I’ve heard about the second-half of season one of Glee, it’s looking to mature.

And now, we’ve got Joss too.

When I came back from my trip to Australia, I noticed all my Google searches from Chromium were searching Google Australia (google.com.au). This sucked, because I wanted to use google.co.uk again to get local results.

There’s many articles on the internet about changing the Google “base URL” in Chromium. After reading some, I visited www.google.com/ncr (“no-country-redirect”) to get Chromium to read the new base URL. This worked, but then I was stuck searching google.com.

Finally, I gave up Googling and decided to hack it myself.

Manipulating cookies

From what I read, the base URL for Google can be fixed by clearing all your cookies and then visiting your local Google. However, I didn’t want to clear all cookies for all my sites - only the ones for Google.

Chromium doesn’t have a cookie manager built in, but thankfully the developers had the wise idea of using sqlite as the cookie storage backend. This means it is relatively easy to manipulate the cookies you want using sqlite.

Opening Chromium cookie database with sqlite

Firstly, I quit Chromium. Next:

dsimmons:~ dan$ cd Library/Application\ Support/Chromium/Default/
dsimmons:Default dan$ sqlite3 Cookies
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> delete from cookies where host_key like '.google.co.uk';
sqlite> delete from cookies where host_key like '.google.com';
sqlite> exit
dsimmons:Default dan$ 

All done! My Google cookies are gone.

Upon restarting Chromium, I went to “www.google.co.uk”, restarted Chromium again, and voila! Searches from Chromium now use my local Google.

It is also good to know that cookies in Chromium can be easily manipulated using basic SQL:

sqlite> .headers on
sqlite> .tables
cookies  meta   
sqlite> select * from cookies limit 5;
etc. 

Have some fun!