RSS feed for blog Linkin Skype Mail Me Twitter


Click for Full Blog Listing

New Anime Series: Kamigami no Asobi

First Episode(s) Review for: Kamigami no Asobi

A young shrine maiden who is following the path of the sword rather than getting ready for her entrance exams, is transported by an ancient sword to some form of Hogwarts’s cross with the playboy mansion but for young girls, in this case she is alone with a wide variety of very hot young men and the odd flying horse, it turns out that they are all young gods here to be taught about humans BY humans what could go wrong


This series is filled with the clear bright animation that makes me wish I lived in an anime world, not too shinny but just enough so that you think every day will be a bright new future, detail where it needed but not over done or seemingly trying too hard, A very nice middle ground with good use of light.

Plot Potential:

If it’s got a plot I have not yet found one, that might be because I’m rolling around on the floor at the sheer “teenage girls fantasy” nature of the environment, of particular note was the stunned “it’s so big” line when the flying stallion is standing next to the girl..


Lots of slow piano tinkles going on in the background (I honestly was expecting to hear Barry White a couple of times)

Reminds me of:

Mostly The Wallflower but with the humour and situations of El-Hazard


Anime often makes me chuckle in that it is seen to cater only to a male hetero audience but the number of truly beautiful young males is nearly equal to the number of imposable women, and this is a fun example of the former. easy watching


Disclaimer: These are mini reviews of anime’s that are fresh out in Japan and are not licensed in the UK, buy them once they have been licensed or at the very least buy the merchandise, remember if the anime makers make a loss, THEY WILL STOP MAKING ANIME!!

Connections Db Schema Tip2: Finding the UserID

Anyone who has had a dig around inside the back end SQL databases (or even compared a number of the ATOM feeds) for IBM Connections will have realised that ID’s are not a constant across the whole of Connections i.e. the userID that apparently created a file will not match the user ID that created a community even though you know that it was the same user that performed both actions, the reason for this is simple, IBM Connections was not build from the ground up as a cohesive whole, its a bunch of application and their databases that have been glued together, this makes it a bugger to link things together under the banner of a single user both for the more serious Developer and for Administrators trying restore/fix/edit records.

So I thought a little database relationship diagram would help make life a bit easier, the core of everything is the EMPLOYEE table in the PEOPLEDDB as that is where the global profile ID is generated for each person, you then have to find where that is mentioned in each of the applications individual member tables, from there you can use that to work out actually what that user has done in the system, thankfully most of the individual application database’s use the same sort of text identifier so they don’t cause a problem once you know they exist, the 2 exceptions are the FILES database which uses an IBM binary format (goodness know why, I’m guessing that it makes sense to use one for the files them selves and they were trying to be consistent within the FILES application) and the HOMEPAGE application in which the UNID is hidden inside a text string which you have to parse.

I will keep this diagram up to date, but please yell if you need more.

this diagram works equally well on both v4 and v4.5


NOTE: All these tips are not officaliy sanctioned by IBM as they do not release DB schema info to the public, so you use them at your own risk, Also if IBM are reading this and I either have somthing wrong or you have documented this for the public, then please tell me and I will correct :-)

NOTE: I’m not a proper Connections / Web Sphere admin, If you want proper Web Sphere and Connections admin you want the Turtle Partnership

New Anime Series: Captain Earth

First Episode(s) Review for: Captain Earth

The death of his astronaut farther has a detrimental effect on a teenagers life, meaning he is withdrawn despite being quite skilled and popular, when a huge floating rainbow ring appears in the sky he is drawn back to the place in his childhood where he first saw it, oh and chuck in a space princess in a giant pink mecha.


Slightly toned down cell animation (the sort they use when try to achieve realism without putting a lot of effort into detail) totally watchable.

Plot Potential:

So what looks at first to be a simple “boy finds secret life in space” starts to look a lot deeper than you would expect, with a lot more threads already coming into play, defiantly not a background series (some people who I thought were good guys already turned into bad guys within 15 mins)


Moving but not catchy, sounds like they have plundered NASA’s dramatic music store

Reminds me of:

Hard to say really, but you know those series that have a group of children going into an old temple when they are young and it going back to bite them then they are older? That but in space, I suppose like a slow moving and serious Tenchi Muyo!


Even though this is a standard plot line, I really enjoyed the variants in it, the hero is not a d**k which always helps and one wonderful old school bonus, the giant machine transformations are truly ridiculous, there is more “clunk clinking” than talking in the first episode, this is a series to watch (and pull the odd Dragon ball Z pose too)


Disclaimer: These are mini reviews of anime’s that are fresh out in Japan and are not licensed in the UK, buy them once they have been licensed or at the very least buy the merchandise, remember if the anime makers make a loss, THEY WILL STOP MAKING ANIME!!

Working from anywhere

I was taught by Mr Ben Poole that a good contractor should leave his desk empty and clean at the end of each day, and watched how Gab Davis seems to be able to work from anywhere at a moments notice so I have been trying for some time to manage both things.

As normal I have not quite got the hang of the simple part, and given the small nature of my studio flat where I do most of my from home working I have tried to pack my whole office into one bag but it does have a few advantages

  • I don’t mind working anywhere as I have no ‘homebase’ as such.
  • I can always give my all at a clients site as I will never be lacking anything
  • I don’t mind doing less than a day at a clients as I can just get on with other stuff

This all works well for me as I enjoy people’s company and do my best work in a busy environment. so I though I might share what I carry in addition to a the real basics: a Laptop (Thinkpad W510), Phone (Nexus 5) and headphones (Sennheiser 550-X)


Core Stuff

  • The silent and powerful USB fan from Thermaltake, saved me from misery in many an over hot office.
  • In my opinion the best mouse in the world the Logitech M570
  • Baby TPLink 150Mbps Wireless N Nano Router , USB powered and perfect for sites where they may not have a desk setup for you, you can just plug this in and you are up and running.
  • Bloody huge Thinkpad charger, weighs a sodding ton, but can be used as a ball and chain in those tricky meetings.
  • At last a proper retractable and collapsible UK power cable this one by ReTrak
  • Western digital Elements Portable HDD inside its Caselogic case a more reliable and essential paring I have yet to see
  • Anker portable USB 15000mAh battery + the lovely smaller version provided by Panagenda
  • Decent 2Amp USB charger any brand is fine, but this one is from Lenovo
  • Torch: present from Matt White (for some late night working) + spare batteries (including ones for my headphones)


Abroad and in the dark

  • Eagle Creek bag to store everything from all the pictures in (they also supply the small bag in the next image)
  • The awesome GoalZero Luna LED light
  • Skross World Adaptor Pro+ which is by far and away the best socket adaptor I have found, both in terms of amperage it can take and the fact it is earthed.
  • Lenovo Travel charger + its thousands of cables and adaptors
  • Various adaptors: Euro to US, kettle lead to figure of eight and vs versa


Little Bag

  • 5 USB cables of various lengths
  • 2 USB OTG adaptors so that I can plug things like keyboards and usb sticks into my phone/tablet
  • Mini USB hub
  • SIM adaptor and tool (in case of phone dieing at a critial time)
  • USB Sticks
  • Audio adaptor cables for my Sennheiser 550-X bluetooth headphones
  • Lindy retractable Ethernet cable, this may look big but its nice and long and most importantly it protects the little clips from being broken which happened to its 2 predecessors
  • Spare mouse by Swiftpoint 
  • Spare headphones


One thing that people tease me about with my setup but frankly I simply could not do without is my Magma laptop Riser, this combined with a USB version of the ThinkPad Keyboard and a couple of mouse pads as arm rests mean I get to have the top third of my laptop’s screen at my sitting eye level which is how its supposed to be.

What do I carry all of this in?

After the destruction of many brands of rucksack including the Wenger backpacks that everybody else swears by, I have finally settled on the Lowepro pro runner 450aw which while rather large means I can carry everything I want and JUUUSSST get it on a plane as carry on (its right on the limit), if I’m travelling on a budget airline I use a Lowepro Fastpack 350 which always fits.


And here is how it looks when I’m all setup ( in this case at a Regus Office near a client at Bank station London )


Of course in addition to this I carry pens, pad, spork, small flask, umbrella and the usual ‘man bag’ stuff, but that was all boring

Click for Full Blog Listing
Latest Blogs