MySQL

The world's most popular open source database

Contact a MySQL Representative


  • MySQL.com
  • Developer Zone
  • Partners & Solutions
  • Customer Login
  • DevZone
  • Downloads
  • Documentation
  • Articles
  • Forums
  • Bugs
  • Forge
  • Blogs
 
  • Pages

    • About me
    • Bio
    • Press Release: “Kaj Arnö Appointed MySQL VP of Community Relations”
  • Blogroll

    • Ein Finnlandschwede in Bayern
    • En finlandssvensk i Bayern
    • It’s some interesting topic
    • Kaj Arnö blog aggregation
    • No Software Patents!
    • Planet MySQL
  • Recent Posts

    • How we fixed the MySQL.com Power Outage
    • A Remote-Attendee’s Look at OSCON
    • MySQL Librarian: Capturing Community Insights
    • MySQL: Powering a New World Religion
    • The Embedded Reporter in the Half-Marathon
    • Berlin Open 09: Social Networking
    • Search the planetary archives, and tag your blog entries
    • SELECTing SELECT statements for Wordpress MU blogging statistics
    • How do MySQL users keep track of digital pictures?
    • Presenting and blogging in Chinese
    • On the Merits of Voting
    • The Future of MySQL
    • The Great Open Cloud Shootout: Videos and other links
    • Karen’s Commitments to the MySQL Community
    • What hasn’t changed with MySQL
  • Tags

    Alexander Arnö Black Swan Blogging Blogs Brazil Call for Papers Call for Participation CfP Community Contributions David Axmark Event scheduler Football FOSDEM Growth Innovation Ivan Nikitin Language Launch Mårten Mickos Michael "Monty" Widenius Mountains MySQL MySQL 5.1 MySQL AB MySQL Forge MySQL User Conference MySQL Users Conference Nassim Nicholas Taleb Open Source Oracle Paris Partitioning Photography Running Runnism Runnismus Social Networking South Africa Sun Microsystems Sun Tech Days Thank you Travel Twitter Use case
  • Archives



  • Categories

    • Architecture of Participation
    • Connectors
    • Documentation
    • Events
    • Falcon
    • GPL
    • GUI
    • Licensing
    • MySQL
    • MySQL Cluster
    • MySQL Proxy
    • MySQL Server
    • MySQL Users Conferences
    • MySQL Workbench
    • Photography
    • PHP
    • Release Policy
    • Ruby on Rails
    • Running
    • Summer of Code
    • Sun
    • Sun visits
    • Travel
    • Use cases
    • Virtual company
  • Calendar

    November 2009
    M T W T F S S
    « Jul    
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
Observations by Kaj Arnö @Sun

Facebook: From 0 to 100 in less than 24h

Sunday, November 23rd, 2008

Three weeks ago, I started my sporadic series of blog posts where I share my experiences improving my online manners through social networking websites, many of which are powered by MySQL. My first target was the traveller site Dopplr, and the second one was Google’s picture sharing site Picasa Web.

This time, I’m taking a look at Facebook. As I said in the first (Dopplr related) blog post, I feel like a slow follower in the discipline of social networking on the web. And Facebook was a true case in point, where “everybody else” was there before me (my team, my boss, my aunt, my nephew, my goddaughter, countless colleagues; you get the picture).

Actually, there’s an advantage to being a follower: It’s easy to grow your network quickly. A mere 24 h ago I wasn’t even registered on Facebook, and now, I have over a hundred confirmed friends. And the fact that we’re talking about confirmed friends I take as a testimony to the power of Facebook: People actually use Facebook, actively. My Dopplr account hasn’t filled up in nearly a month to even half the amount of Facebook contacts in less than a day. Sure, Dopplr isn’t for my aunt, nephew or goddaughter, but still — the activity level correlates with the usefulness.


The two most distinct advantages of Facebook is its worldwide coverage and its technical connectivity. The worldwide coverage is quite a bit weaker in large, well-developed non-English-speaking countries (such as Germany). There is near-zero motivation for my children (13 and 14 years old) to join, as “everyone that matters” to them is on Lokalisten.de, the older siblings of “everyone that matters” are on StudiVZ and their parents on Xing.com. Some similar situation prevails in Japan or China, but not so in Finland. There, all age groups go on Facebook. And this provides lots of value: Sharing pictures with my aunt is done with the same medium as I can ask my goddaughter’s bigger sister for a favour, i.e. using her newly-acquired driver’s license to pick up my son from Helsinki airport for a pre-Christmas party next weekend. Sure, I could have called her mobile phone, but Facebook was much less intrusive. She’s there anyway!

The technical connectivity provides “networking effects between the networks“, if you will. I have connected Facebook to my Doppler and Twitter accounts, and to my Google Reader. So status changes in Twitter propagate to Facebook. And new blog entries on Google Reader propagate to my notes / feed on Facebook. And given that, in turn, I have connected Twitter to my SMS and Google Reader to my blogs, it means that my Facebook news page gets automatically updated through my SMS tweets and blog entries. Without any further effort my side. (Sure, it was non-trivial to set up blog aggregation on Google Reader, but I had already gone through that for my home page http://kaj.arno.fi).

For those who neither tweet nor blog, automatic updates of a Facebook page may not sound like nirvana. Yet, that’s very close to what it is, within the realm of social networking on the web. What’s the purpose of tweeting or blogging or writing stuff for the web, if nobody reads what you write? Or rather, to be more reader centric, which web updates would you rather follow — those that you get easily notified about in an app where you are anyway, or those for which you have to make a conscious effort to read, by starting a new app or web page? The effort should be on the side of the writer, and with Facebook, the effort is kept to a very manageable level of setup work, after which the updates propagate.

In order for the sentence “it’s less than 24 h before I registered on Facebook” to be fully honest, let me now proceed to my summary:

Positive experiences: Very many, quite significant

+ Suprisingly many friends, relatives, colleagues already connected
+ Good to get reminded of their existence and their daily life
+ Very good worldwide penetration
+ Great that Facebook integrates with Google Reader and my blogs
+ Great that Facebook integrates with Twitter, as this means that I can share things happening through SMS messages
+ Great that I could export an LDIF file from Thunderbird (my email program) and import them into Facebook, which based on email addresses identified already-connected friends very easily

Negative experiences: Few, if any
- Biggest irritation: When I uploaded the LDIF file at what seemingly was a peak time for Facebook, the connection broke several times — but after a sufficient number of re-tries, the time-outs didn’t reoccur
- There’s a lot to learn in Facebook (private messages, public messages, updates etc.)
- I didn’t find any outward-facing non-member landing page for invitations, along the lines of facebook.com/profile/kajarno
My own confusion — no fault of the social network itself

I’m using Facebook in Swedish (hey, why use a foreign language?), and this isn’t the language that the majority of my friends use in it — so I don’t know what “Upplagt”, “Anteckningar” and other similar concepts are in their languages
My network presence isn’t monolingual, and all of my friends don’t read all of the languages I use. So I end up spamming those who don’t understand Swedish with updates in Swedish. On the other hand, some stuff isn’t interesting for anybody else except those who read Swedish. I just have to hope that my friends aren’t annoyed by updates in languages they don’t understand.
It isn’t 100% clear to me what I should be public about. Why should I share the books I’ve read? The films I like? My favourite quotes? So far, I haven’t

Remaining questions from my side
People ask me to verify that we “worked at Polycon 1995-2000″ or “we travelled to Sorrento in 2006″ and I have verified that, but where do I update my past activities myself?
And do I have any real benefit from entering past data?
How do I best group my many contacts into groups, such as based on what language I use with them, where I met them, etc.?
Should I invite real-life friends who are not yet on Facebook, to join?
When should I share pics using Picasa Web, when using Flickr, when using Facebook?
What is the intended use of “puffa” (I think it’s “nudge” in English)?

All in all, Facebook is a scalable way of maintaining a social life, to keep in contact with people with a maximum of social interaction and a minimum of technical overhead. With less than a day’s experience, I expect to use Facebook several times a week, and improve my offline real social life through online activities.

Links:

  • Facebook: http://www.facebook.com
  • My Facebook page: http://www.facebook.com/profile.php?id=16….somethingverylong
  • Wikipedia: http://en.wikipedia.org/wiki/Facebook

Posted in Architecture of Participation, MySQL | 1 Comment »

Picasa Web: Sharing pictures, in particular for blogs

Saturday, November 1st, 2008

Yesterday, I started my sporadic series of blog posts where I share my experiences improving my online manners through social networking websites, many of which are powered by MySQL. My first target was the traveller site Dopplr, and this time, it’s Google’s picture sharing site Picasa Web.

My starting point is the same: “Everyone else” among colleagues and friends was there long before me, and I feel like a latecomer. I want to go in, do what seems to be the right thing, and share the observations I had. And everything within the time constraint of not being able to do a full evaluation, as I obviously have other things to do as well.

Unlike Dopplr, starting with Picasa Web never required invitations. My first exposure to Picasa was through MySQL colleague Zack Urlocker’s biking trips. He shared albums of his trips, which I browsed through, and found “quite OK”. Meaning: Easy to consume pics posted by others, but no trigger for me to start producing web albums myself. When running with Zack, the Picasa topic occasionally popped up, with me expressing skepticism towards the time expenditure for uploading a gallery, and Zack saying it wasn’t that hard, as there is a good picture uploader. It turns out Zack was right, as I learned much later.

What triggered me to join Picasa Web was my blogging. A blog entry without a single picture isn’t very appealing, and some blog entries require many pictures. I had for long used a complex setup, uploading my pictures using Unix utility scp from my Mac to my account on @arno.fi. The domain arno.fi was a parallel domain to a now-extinct server grankulla.mysql.com, which I had to stop using after the Sun acquisition, as the use was bordering on the private. So I started to host arno.fi privately (a different story entirely) and became worried about bandwidth cost for the pics referred to from blogs.mysql.com/kaj. So the MySQL Web Team enabled uploading of pictures as part of the MySQL Wordpress blog site itself. This worked fine, but by this time I had already thought a bit about hosting the pics on Picasa or Flickr. So when I saw Picasa pictures automatically connected to Google profiles and Google maps, I decided to try out Picasa.

Like for all social networking sites, I obviously had to register. This wasn’t hard, and it was part of my general Google profile (Google Reader, Google Mail etc.). The real obstacle which had kept me from doing it earlier was installing the picture uploader, called “Picasa Web Albums Uploader“. I’m not a person who likes to tweak with the technical setup of my computers, hence the reluctance. But it was OK. I didn’t have to know anything in advance; the Picasa web site gave the relevant pointers and I wasn’t lead astray during the installation.

Next came the learning part, which in fact turned out to be fun. Uploading the pictures was trivial. I am a character based (”command line”) type of guy, hence the perceived ease-of-use of the scp utility. But merely dragging the pictures from the Mac Finder to the Picasa Uploader was easier still. And uploading pics with the Picasa Uploader came with two real benefits:

  1. Automatic picture resizing into multiple sizes: 144px, 288px, 400px, 800px. For that I had used the resize command of Imagemagick, which took me quite a while to install, and which despite its command line nature wasn’t as fast and automagick as the ease of use of the Picasa Uploader for this specific task. Plus, Picasa relieves me of renaming pics in various resolutions to distinguish them from each other.
  2. Easy housekeeping of album names / directories. I like order (not that I always succeed in keeping it). So I dislike putting all pics into a one single directory. The Picasa uploader provides me with a drop-down list of my previously used albums ( “directories”), which I can refill, or the opportunity to create a new album (”directory”). And at the point of upload, I can very quickly label the pics.

The next step is completely optional, but very “cool” and inspiring: I can tag the pictures, and I can place them on Google Maps.

Tagging is merely about finding out multiple, good descriptions for pictures, for later searches. So that doesn’t take long.

Placing the picture on the map can be everything from dead easy to very frustrating. For my pictures from Munich, I very simply typed in the address: just “Balanstr. 22″ for the pictures of my son trying to be an actor, and “Kleinfeldstr. 28b, Germering” for the pictures of my daughter by Riccardo Desiderio. For South Africa, it was much harder. It didn’t know Kievits Kroon, Reier road, or even Kameeldrift. I just had to point manually to somewhere north-east of Pretoria, where I assumed the pics were taken. That was a time drain.

Still, as a result, I got a nice map of where I took the pics of the trip, and if I’d like more detail, I’ll even see the individual pictures placed on a map.

The last step is about using the Picasa pictures in the blog itself. And this is also a bit simplified from my character-based scp blogging, where I had to semi-manually concatenate the first part of the picture urls (”http://kaj.arno.fi/”) with the name of the picture (”IMG_1234_Blabla.JPG”). In Picasa, I do the opposite, i.e. I cut-and-paste the huge text provided by Picasa, e.g.

<table style=”width:auto;”><tr><td><a href=”http://picasaweb.google.com/lh/photo/YpJLrGsLVDIbs_jSHkAQ-Q”><img src=”http://lh5.ggpht.com/_6eAQKKvv8LA/SQwrd02hu3I/AAAAAAAAAXw/xvphDvabhsQ/s288/Kaj_RD_Kvadrat_B_7729.jpg” /></a></td></tr><tr><td style=”font-family:arial,sans-serif; font-size:11px; text-align:right”>Från <a href=”http://picasaweb.google.com/kaj.arno.2/KajArnPortraits”>Kaj Arnö Portraits</a></td></tr></table>

and clean it up from surplus stuff to get only what I want, i.e.

<img src=”http://lh5.ggpht.com/_6eAQKKvv8LA/SQwrd02hu3I/AAAAAAAAAXw/xvphDvabhsQ/s288/Kaj_RD_Kvadrat_B_7729.jpg”/>

which I then paste into my Wordpress blog entry, perhaps adding an align=”right” or align=”left” in the process. And I take care to select the desired resolution: 144px, 288px, 400px or 800px; more than once, I’ve been happy with reducing the picture size further than what I would have done during my Imagemagick resize days.

In all of this, I see little if any problem, except the huge size of the licensing agreement I clicked through. That’s another barrier of entry. I don’t know what I really agreed to. Who knows, perhaps I even violated the agreement by taking screen shots of what Picasa looks like, for this blog entry?

Which brings me to my summary:

Positive experiences: Many, and significant
 

+ Very easy and fast to upload pictures
+ No need to shrink the pictures before upload — Picasa does it for you
+ Great to get many resolutions (144px, 288px, 400px, 800px) automatically
+ Fast integration of pictures in blog entries
+ Easy to keep pictures in order
+ Cool to tag the pictures for searches
+ Cool to place pictures on maps

Negative experiences: Few, and all related to legalese
 

- Very irritating to have such a lengthy license agreement
- The license agreement was so long and difficult that I don’t know what I agreed to
- Meaning, I also don’t know if I’m missing something important
- And why didn’t I get http://picasaweb.google.com/kajarno as my public page?

My own confusion — no fault of the social network itself 

Privacy! It isn’t even 20 % clear to me when it’s in my interest to allow the albums to be visible for everyone, and when it should be private (sure, I won’t put up pictures of drunken friends, or of myself in a similar state — but what about the innocent family pictures I linked above?)
I first thought Picasa was a standalone photo organiser like iPhoto, and then learned it was a picture sharing thingie like Flickr, but only now reading Wikipedia do I understand I was right to begin with, and Picasa Web is separate from Picasa (good thing I read that before posting this blog entry, as I now sprinkled in the word “Web” here and there after “Picasa”)

Remaining questions from my side
 

How much time should I spend uploading my existing pictures?
Should I do that at least for my past blog pictures?
Privacy! When should I make my pictures public? Why?
Should I link the pictures from other social networking sites? How can I do that easily?
Privacy again! Who will use the tags I provide Picasa Web with? Will that be of benefit or harm to me?

Starting to use Picasa Web Albums has so far been a very positive experience, and I do expect to manage all my online pictures in it, and get lots of good vibes from it going forward.

Links:

  • Picasa Web Albums: http://picasaweb.google.com
  • My Picasa Web page: http://picasaweb.google.com/kaj.arno.2/
  • Wikipedia: http://en.wikipedia.org/wiki/Picasa#Picasa_Web_Albums

Posted in MySQL, Photography | 3 Comments »

Dopplr: Joining the Social Network for Travellers

Friday, October 31st, 2008

MySQL powers many of the social networks of Web 2.0. While it’s great that we constitute one of the tools of Web 2.0, we should also ourselves utilise the tools Web 2.0 provides for social networking. Comparing myself to colleagues, I feel like a slow follower in this discipline. “Everybody else” is already on Twitter, has hundreds and hundreds of contacts on LinkedIn, Xing and Facebook, puts their pics on Picasa and Flickr, bookmarks their pages on del.icio.us, and has fancy blogs that are registered everywhere. Myself, I have been half-heartedly entering contacts into LinkedIn, I have mismanaged my Xing account, I uploaded a tiny amount of pictures on Flickr two years ago, and have now taken my first steps trying out Twitter and Picasa. I’m not even registered on Facebook or del.icio.us.

And therefore I thought I would take a look at how to improve my online manners.

So what I’ll do over the next two months or so is to take a look at both the websites I’ve been mismanaging, and the new ones others have invited me to. I’ll do my best to fit in, but I’ll also come with some subjective commentary on what I experienced.

First in line is Dopplr, the social network for travellers.

Dopplr Logo for Kaj mid October 2008

I got invited to Dopplr by David Axmark in September 2007. I didn’t do anything with the invitation, as there were “other more important things to do”. In December 2007, I got invited by Giuseppe Maxia. One would think that these two invitations would have triggered me to do something about it, but no. I waited until I had to fix a complex set of travel involving David replacing myself in Japan so that I could go to South Africa. At the same time, I was asking Giuseppe about his travel plans and felt silly I had to ask and re-ask Giuseppe only because finding the relevant, freshest email was too cumbersome. That was the trigger that made me accept Giuseppe’s Dopplr invitation.

So I entered my basic data, which didn’t take many minutes. I could then see David’s and Giuseppe’s travel profiles, conveniently available under http://www.dopplr.com/ traveller/DavidAxmark and http://www.dopplr.com/traveller/gmaxia respectively. Looking at the right hand side on David’s data from today, it’s easy to see when he is where. I don’t need to ask him, nor does anyone else.

Next, I entered my travel plans for the rest of the year. Then, from my own itinerary, I noted something I hadn’t thought of. On the way back from Buenos Aires, I have a stopover in Frankfurt, which happens to coincide with when Giuseppe is there for a meeting. If the stopover is long enough, or Giuseppe has extra time to come to the airport, we might meet just because we happen to be in the same place at the same time. And that’s what Doppler is a lot about: Facilitating serendipitous meetings with people you know.

Next, I saw all the cool stats that Giuseppe and David had, based on having joined Dopplr a lot earlier. So I entered my 2008 travel, which took quite a while as I’ve travelled a lot and emitted carbon in a most horrible way. But it didn’t help — Dopplr still said I had travelled “0 km so far”. All that data entry in vain! Too bad.

But luckily, the stats were calculated for me overnight, in some kind of a batch job. I now have a nice timeline, telling me that I’ve been more on the road than at home in 2008:
Kaj's 2008 Dopplr timeline
Kaj the squirrel
I also have learnt that I’m as fast as a squirrel, with an average speed of 22,93 km/h.

Coolest of all is The Dopplr Raumzeitgeist, which tells me where I’ve been for the time period for which I’ve entered data into Dopplr:
Kaj's Raumzeitgeist

If I had a cool web page to which I aggregate blogs and other stuff, such as Colin Charles does, I could paste the nice badge Dopplr provides me onto it. Either the small format (the first pic on this blog), or a big one, like this:

And this brings me to my first frustration with Dopplr. It tells me I’ve frequently been to “Nauvo”. No, no, no! I most certainly refer to the place I’ve been to as “Nagu”, not “Nauvo”. It’s a place with two names, of which in this case, I happen to use the same name as the majority of people living there. In the case of the second-most frequently visited place, I personally use “Helsingfors” (the Swedish name), but I can understand most people would use “Helsinki” (Finnish). And again, on fourth place, I’ve got one more place with multiple names. With most people I’ve discussed that trip, I’ve used the name “Wolkenstein“, which Dopplr expands to a long dual name, “Selva di Val Gardena - Wolkenstein in Groeden”. Better than just Selva, but still, not what I would pick myself.

Which brings me to my summary:

Positive experiences: Many, and significant
 

+ Great to instantly see where friends and colleagues travel
+ Great not to have disturb them with questions on “when are you where”
+ Great to get alerted to serendipitous presence in the same location, for my own planned trips
+ Cool to get all kinds of travel stat
+ Cool to see pics from Flickr automatically associated with trips

Negative experiences: Few, and all related to Dopplr Big-Brother-changing place names
 

- Very irritating that Dopplr converted names like “Mariehamn” and “Nagu” to “Maarianhamina” and “Nauvo”, which are used only by a small minority of their respective inhabitants
- Irritating that Dopplr converted “Helsingfors” (which is how I refer to my birth town) to “Helsinki”
- Irritating that Dopplr converted “Wolkenstein” to the very long “Selva di Val Gardena - Wolkenstein in Groeden”

My own confusion — no fault of the social network itself 

I was first disappointed that Dopplr didn’t calculate my past travel stats, but happy again the following morning when they had been done
My bad conscience for my carbon footprint didn’t exactly diminish
It isn’t 100% clear to me whether it’s in my interest to allow the data to be visible for everyone, or just my approved co-travellers

Remaining questions from my side
 

Will I have any real benefit from entering past data from years before 2008?
Will there be an easy way to enter many past trips in batch, e.g. over email?
When will fellow travellers allow me to see their travel plans?
Should I enter “travel tips”?
Will I find some benefit from using the data entry from my mobile phone or Twitter?

All in all, Dopplr was a very positive experience, and I do expect to manage my travel in it, and get lots of good vibes from it going forward.

Links:

  • Dopplr: http://www.dopplr.com
  • My Dopplr page: http://www.dopplr.com/traveller/KajArno
  • Wikipedia: http://en.wikipedia.org/wiki/Dopplr

Posted in MySQL, Travel | 7 Comments »

Observations by Kaj Arnö @Sun is proudly powered by WordPress MU running on Blogs.mysql.com.
Entries (RSS) and Comments (RSS).