I recently posted an article about using BINARY(16) for storing MD5’s as unique identifiers instead of simple integer ID’s (usually auto increment); in that article I touched on one of the benefits, reducing JOIN’s, but there are other reasons for doing it too, so I thought I’d post an article discussing purely the reasons behind … Read More “MySQL and Binary(16) – The Reasons/Benefits/Drawbacks (#mysql)” »
Month: January 2010
Over the past few months at work, we’ve seen our database grown from silly big to really silly big, it’s still a way to go to get to the size of the big boys such as Facebook etc. but it’s still a database stored in MySQL that most day-to-day PHP programmers would avoid like a … Read More “MySQL – Binary(16) and scalability” »
On Tuesday night we went to see Avatar at the IMAX in Bradford’s National Museum of Film and Photography. I had semi high expectations for the film but had heard some bad press so how good it would be was left wide open. someone suggested we go to see it at the IMAX as it … Read More “Avatar is a must see film – at IMAX in 3D” »
It seems like it’s taken a long time for someone in the States to get up and do it, but someone seems to finally be ready to stand up in court and challenge the legality of banning same-sex marriage on a nationwide scale. The result of this trial should finally end the confusion the USA … Read More “Federal Court to determine constitutional legality of gay marriage” »
We’ve all seen the movies where interactive displays are done on transparent glass, well Samsung, using OLED (organic light emitting diodes) have finally created one for us all to gawp over. Details are scarce, but it shows that yet another sci-fi idea is becoming mainstream reality. For now, here’s a video of the display, courtesy … Read More “Transparent Laptop? Samsung’s new 14 inch OLED display” »
I’ve not watched much Celebrity Big Brother this time around, as usual it’s become extremely over the top and feels almost scripted (as in the housemates, obviously BB has a script!) One thing they have done this time around though is actually get a couple of people who can actually be classed as celebrities. I … Read More “What a line up – and now Ivana Trump! Celebrity Big Brother” »
NASA uploaded an image today of Great Britain from space as of 11:50 UTC today, it’s a truly remarkable picture showing just how much it has snowed here. For anyone not from the UK, snow like this has not hit Britain for over 30 years, hence all the hoo-haa about. It looks beautiful though, although … Read More “Snowy Britain – NASA Terra image” »
Yes, that’s right, we’re getting an extra bank holiday in 2012 (I know, a little bit of a wait still) as a result of the Queen’s Diamond Jubilee. The bank holiday will be on the 5th of June and the Whitsun bank Holiday will be moved to the 4th of June to give a nice … Read More “New Bank Holiday coming up (hopefully permanent)” »
Well, it was good while it was getting better, now we’re back to square one again, I’m talking about airport security of course. After the attempted plane bombing attempt on Christmas Day, security has now been upped at international US airports again for any incoming flights deemed to be from “terror-prone” countries. The new rules … Read More “US Toughens up on incoming planes from “terror-prone” countries” »