Colin Charles Agenda

I’m told WordWeb, a dictionary application for Windows, allows you to find words, quite unlike the MacOSX dictionary. I’ve never even found a usable dictionary when I use Linux, that doesn’t require me to go online.

The whole idea is that if I search for the phrase cure all, I get back a thesaurus entry that suggests the word panacea. OK, that example alone wasn’t so great, because cure-all tends to be a word in these dictionaries. WordWeb Online allows me to have a “reverse dictionary” result, which I think is just fabulous (as long as I have access to an Internet connection).

Does such a Mac app exist? Seems WordWeb exists for the iPhone, but their Java app, requires an Internet connection.

What’s interesting is that they sell the dictionary data. They are powered by MySQL, and if you’re wanting to grab their dictionary data in either tab separated plain text files or a MySQL database, you fork out a mere USD$999.

That’s a lot of money for a database file. I have no intention of spending that much money, considering the restrictive licensing on their site. So I searched, and found GCIDE_XML – described as “The GNU version of The Collaborative International Dictionary of English, presented in the Extensible Markup Language”. I tried to see if it had reverse dictionary search results, but it didn’t.

So, does anyone know if there’s English dictionary data out there, for MySQL, that doesn’t cost a bomb and is comparable, to WordWeb? Of course, it also comes with sensible licensing, will be an added bonus.

There’s a good podcast from Chris Messina and Larry Halff, about what really happened at Ma.gnolia. If you’re at all interested in what happened (i.e. how did they lose all their bookmark data), don’t hesitate to watch the video. I took some quick notes:

• half a terabyte database file got corrupted
• a mysql 5 database
• everything was running even though there was corruption, and eventually, the site went down
• backup system also failed, as it didn’t backup the data from mysql
• backup was just backing up corrupted data (file sync over a firewire network was the backup mechanism)
• a Rails application, he now recommends clouds over running your own infrastructure for startups
• a couple of xserves (for database, etc.) and four intel mac minis as front end web servers
• the site didn’t actually make any money

So I don’t know if Baron can rescue Ma.gnolia, per se, but I think the problem was largely:

Doing a file sync over the Firewire network, as the backup mechanism

You can’t safely backup MySQL that way. I don’t know what mechanism was used, but it sounds like rsync, and as much as I love rsync, I wouldn’t use it to backup a live running MySQL database that way.

With two servers, there should have been MySQL replication.

I’m curious if the data recovery Baron talks about is that of using the utility ddrescue? After all, ddrescue gets the raw data off the block device, without even trying to mount it. After that, you can attempt to recover the MySQL data off disk. In fact, I was surprised that the Ubuntu folk have a very nice Data Recovery page – no information about extracting MySQL databases, but its nothing a little hackery won’t get you.

I tried to ping Larry on Twitter, to ask what engine they were using… No response, per se. Good luck, and I hope the users get their data back, in time!

Look what arrived in the mail! MySQL 5.1 Release t-shirts!

The front

The back – with all our names

We made something similar for the MySQL 5.0 release and 10th anniversary, and sold that. I don’t know if we have plans to sell the MySQL 5.1 t-shirts, but if you think you’d like to buy one, maybe drop me a comment and if there’s enough requests for it, I’m sure we’ll try to sort something out.

Bernard Leong writes about some Cisco video conferencing hardware:

the Cisco TelePresence 1000 (made for the home user – we are told the price is US$79K) and the Cisco TelePresence 3000 (made for companies – and the price is US$299K)

How many home users are willing to shell out US$79K for a video-conferencing kit? Why not just use Skype?

I was watching some TV earlier, and Oprah uses Skype. She brought on Jennifer Aniston’s two dogs, and Owen Wilson from Maui. Full screen (some large-ish TV). Clear. Powered by Skype.

Apparently, Oprah has been doing this for a while. I think Cisco isn’t going too far with their TelePresence stuff for the home. Can’t imagine many a business (SME-sized) wanting such an expensive system, either.

What about open source video? Video over SIP? Don’t really see anything being as mainstream as Skype (which does audio and video, just fine, despite being proprietary).

The fun with Maxis Broadband continues. I last wrote about the real story behind Maxis Broadband, which apparently is quite a favourite amongst Google searches. Today, @hantu asks on Twitter: $99 mobile unlimited or $138 maxis broadband?.

Lets delve into this a little deeper. I have the RM99 mobile unlimited connection, so that my E71 can surf the Internet. It allows me to check and send email on the go, post updates to Twitter, perform quick Google searches, and when I’m waiting for someone, read my Google Reader feeds. I estimate I use about 150MB or so per month, and this will probably grow in size, as I have JoikuSpot installed, and can share it with my iPod Touch. If I had an iPhone (and used it), I can imagine my data usage being a lot higher.

I’ve also had a Maxis Broadband SIM card, that I pay RM143 per month for. No, its not RM138, because they decided to send me a bill, which costs RM5/month. Nothing I do, can stop me from receiving said paper bill (not even threatening to stop their services). Do I use the Mobile Broadband services? Yes I do – I average 2GB per month, sometimes more, depending on where I choose to work for majority of the time.

In my head, I’ve been thinking, with the economy being the way it is: why am I paying RM143 and RM99 for mobile data? I noticed Maxis had a “Multi-SIM” service, in where you pay RM15/month, and you get a second SIM for your number. I thought that this was the way out – get a second SIM for my primary number, pay an extra RM15 and share the 3G connection (the second SIM to be placed in my broadband modem, a Huawei E220).

To my dismay, I visited the Maxis store and was told I couldn’t do this. If I wanted a second SIM, my services don’t extend to it. That means, I have to pay RM15 + RM10 + RM99 for the second SIM. Could I have found two idiots at the Maxis Centre in Klang – quite possibly – I think her name was Lina, and her supervisor was no better.

Maxis has an FAQ that suggests I can get a second SIM card, and just place it in my broadband modem. Imagine, only paying RM99+15 (RM114) rather than RM242.

My only solace? I don’t pay RM143 any longer. I only pay RM118, as I have Mobile Broadband and I am a Maxis postpaid customer. If you listen to the customer service representative, you’ll realise that you’re paying RM124 per month. I however think the customer service rep, is just being a plain idiot, and this can be fixed.

Why don’t I just use JoikuSpot, or tether via Bluetooth, to my Nokia E71? Because of battery life. The last time I tethered to my Nokia E61i, I had about 2 hours of battery life, before the phone got really hot in my pants pocket, and the battery went almost flat. Not having a working phone, is of course, unacceptable, which is why I’ve gone the mobile broadband route.

So, Andy, what’s your best choice? It depends on your usage. If you’re using your phone a lot, get an unlimited data package for RM99. If you don’t need access too much, consider Bluetooth tethering, which will work OK (maybe you have to carry a phone charger around). If you need to sit in cafes a lot, or work away from your desk and proper Internet connection, consider the Mobile Broadband package, at RM143/RM138/RM118 (paper bill/no paper bill/Maxis postpaid Bolt-on program).

If I ever get this multi-SIM bullshit figured out, I’ll be sure to write about it, and let you all save money. If any other provider (Celcom, DiGi, U mobile) offer it, don’t hesitate to leave a comment behind.

I decided to experiment with Google Friend Connect today, after seeing the “Social bar” being used on the Open Source Bridge site. I had even set aside some time to start writing some code; to my surprise, Google did all the magic for me, and it didn’t even take me longer than five minutes to setup.

It was as simple as setting up a new site, uploading two files into ~/www/, then editing my WordPress theme’s footer.php and adding the auto-generated code before the </body> tag (I did it after the <?php wp_footer(); ?> call though).

I immediately joined my own site. At first, I setup a profile, but then realised that I could import my profile from my usual Google one. Heck, I could even import a profile from Twitter! One thing I found odd, was that to edit my profile, I had to do it from the social bar itself (from the far left column).

The social bar – click for a larger version

On the far left column, you can join the site, or edit your profile and settings. Next to that, you can see the activity stream throughout the site. Next to that, you’re given the option to add comments. And on the far right, you can see like-minded visitors who’ve joined, and even become friends with them.

What does the social bar do for me?

1. It allows members to join my blog and be part of my community. Do you remember MyBlogLog (a Yahoo! service)? Well, Friend Connect allows me to have MyBlogLog type features, with no problem whatsoever.
2. It allows comments from members. These can be fine grained comments – either for the particular page, or for the whole site. In my experimentation, I’m using it for the whole site naturally. On a blog, if you’re going to write a comment of substance, you’re going to do it with the commenting facility available on the blog – however, if you just want to write throwaway comments, one-liners, “me too” replies or have one of those “chatboxes” that blogs tend to have, you’ll find the Friend Connect Social Bar to be quite useful.

I’ll be the first to admit, that its probably not too useful for me, per se, but I can see its usefulness for sites that require a lot of collaboration.

Sites that I think can benefit from Friend Connect? Kenny Sia – the Chatterbox can be replaced with the comments in Friend Connect, and frankly all the one-liner comments will be better suited for the Social bar’s comments (maybe on a per-page basis?) – plus, he’ll get a “community” for free. LiewCF can also benefit – the “members” feature provided by MyBlogLog (he currently boasts 1,441 members) can probably grow with Friend Connect, and all those one-liner comments again, can go into the comments of the Social bar. Not picking on either site, but I think they can “socialise” their sites a lot better.

MyBlogLog is kind of a walled garden. You need to have an account there (on Yahoo!). Friend Connect tends to be a bit more useful – you can either use a Google, AIM, Yahoo! or OpenID account to login (a lot of bloggers will already realise they have OpenID for free – wordpress.com, livejournal, et al provide this). I think it can be a bit more useful if it supported logins from Windows Live/MSN accounts too – after all, a large proportion of my non-geek friends are MSN users.

And if I join another community, that information is cross-pollinated to my other communities. As a site owner, you can even see “reports” of how social your site is, over time – this whole idea of data mining (ok, analytics) is highly useful.

What if you decided to use comments on your blog, for just that – comments. But use the Social bar to enter “blog suggestions”. Smells like Skribit, to some extent. Do I see myself keeping the Friend Connect Social bar at the bottom of my blog for long? Who’s to say. Let’s see if a community builds up around it. I think this will be most useful for sites that really want conversations amongst readers, something like the foss.my site, or other social sites.

Are you using Google Friend Connect? How? What are your thoughts on it? Don’t hesitate to share them in the comments (or via the Friend Connect Social Bar!).